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)
 Restore Error

Author  Topic 

srini99usa
Starting Member

4 Posts

Posted - 2009-06-23 : 18:21:59
hi

i am restoring a db through the full back up and by tran log backup both WITH THE "NO RECOVERY" MODE

but my db shows like DbName(Restoring...)


when i try to launch the mirroring it shows this error message:

database cannot be opened.it is in the middle of a restore

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-06-23 : 18:41:14
It shows that state because you specified NORECOVERY. Specify RECOVERY on the last transaction log backup file and then the state will be what you want.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

srini99usa
Starting Member

4 Posts

Posted - 2009-06-24 : 15:19:58
Thanks to all of u......it worked for me
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-06-24 : 15:25:45
You're welcome.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -