Database in Recovery - SQL Server Forums

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)

Database in Recovery

Author

Topic

vani_r14
Starting Member

24 Posts

Posted - 2009-07-06 : 17:55:38

Hi

I restored a database (using Restore with No Recovery) Option. Can you please let me know if there is a way we can change this option without having to drop and recreate the database

thanks
Vani

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2009-07-06 : 18:54:01

Try:

RESTORE DATABASE MyDatabaseName
WITH RECOVERY

--------------------------------------------
Brand yourself at EmeraldCityDomains.com

vani_r14
Starting Member

24 Posts

Posted - 2009-07-07 : 16:34:12

Thanks for your help will try that

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2009-07-07 : 18:58:44

Wpould the "WITH REPLACE" option be of use to you?

=======================================
Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources