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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Restoring a db without overwriting the original

Author  Topic 

kote_alex
Posting Yak Master

112 Posts

Posted - 2009-02-02 : 10:21:49
I want to get some data from a old db ... and i have the backup but i don't want to restore and overwrite the existing one ...

Can it be done ? 10x ! :)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-02 : 10:26:12
then restore it with a new db name and change file specs to point to new location.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-02 : 10:26:43
Restore under different name and location with Move option.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-02 : 10:27:46
also see this

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300
Go to Top of Page
   

- Advertisement -