Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CoffeeAddict
Yak Posting Veteran
94 Posts |
 Posted - 2009-09-17 : 14:59:20
|
| I want to remove a database and restore it with a new version from production.I assume if I delete it in SQL Server Management studio then try to restore the newer .bak that the master database won't conflict saying it exists from before? I've never tried to delete and refresh basically like this for a large database. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-09-17 : 15:54:44
|
| sure... you can delete existing database and restore the back up and give it any name as long as it doesnt conflict with existing database names.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
CoffeeAddict
Yak Posting Veteran
94 Posts |
Posted - 2009-09-17 : 16:21:01
|
| Thank you. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-09-18 : 17:31:37
|
| You can restore on existing database by replacing it. Use the same path for MDF and LDF. That will save time. If u drop and then recreate the database, sql server first create a shell database and then expend it to restore the source. |
|
|
|
|
|
|
Removing and Adding a new Database