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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Database Restore

Author  Topic 

youngoz
Starting Member

6 Posts

Posted - 2007-08-03 : 13:31:41
Hey Guys

I'm doing a test on my SQL Enterprise application and I would like to know if it possible to delete a database and restore it using the restore feature on SQL Enterprise? Or do I need to created the database first and then restore it?

Thanks in Advance.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-08-03 : 13:48:06
IF you delete the DB, its gone. there's nothing you can restore from. You need to back up the DB and restore it with a different name. What exactly are you trying to do?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-03 : 13:59:20
If you have good backup, either way will work.
Go to Top of Page
   

- Advertisement -