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 |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2009-06-18 : 09:40:05
|
I'm wondering if you guy can help, if you have a copy of a database i.e.Test_DB_Copy which was created by restoring an original database backup file as a new database name. Could you then restore the old database back to it original state for example Restore Test_Db from Test_db_copyI've looked in BOL and web and it appears that you can't do this but wondered if people have ever done something similar.my other Thought was to go along the lines of renameing the databases and filesFor example:Test_db_Copy become Test_db_RestoreTest_db becomes Test_Db_CorruptTest_db_restore becomes Test_Db Drop database Test_Db_Corruptby then renaming the relevent data/log files also, would this bring the server back online.Only testing things at the moment and at current with these hacking methods i'm gonna be asking to upgrade to Enterpise version for the Snapshot option.  |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-06-18 : 12:01:32
|
| You can do it with database snapshots only. Otherwise you'll have to restore from a backup file.--Gail ShawSQL Server MVP |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-06-19 : 04:29:40
|
| Thanks - thats what i thought, but also in principal would the renaming actually work, these are all just option i'm going to present but the renaming option will be highlighted as being very unstable but achivable if needed. |
|
|
|
|
|
|
Restoring from a database