I have two SQL Server 2008 R2 servers one for PROD and the other for DR. I am trying to add log shipping for a database called School.
Steps so far
Back up School database
Restore with database using the UI or using the following SQL statement i.e.
Restore database "School" from disk ='t:\Data\School.bak' with NoRecovery
.The result is database is stuck in Restoring
If I restore the database with
Restore database "School" from disk ='t:\Data\School.bak' with recovery.
the database restore completes but the log shipping fails. I have deleted the database and recreated it again usingRestore database "School" from disk ='t:\Data\School.bak' with NoRecovery
.but it is still stuck in**Norecovery**
.Is there a way that I can restore the database so that is not stuck in the restoring state and I can complete the log shipping.