Implementing LogShipping

[thulasi]

HI all,

I implemented logshipping concept in our environment by using two server.

1.I am able to getting the backup file from primary server
2.that backup file is copying in to the secondary server based on the schedule based..

3.After that while restoring that transactional files i am getting error:


[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4306: [Microsoft][ODBC SQL
Server Driver][SQL Server]The preceding restore operation did not specify
WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying
WITH NORECOVERY or WITH STANDBY for all but the final step.

Could any one help me on i will highly appriciate..

Thanks,
Thulasi.

[skhanal]

When using log shipping you should restore database and subsequenct logs with WITH NORECOVERY option. If you do not do that SQL Server rollsback any uncommitted transaction and opens database for Read/Write. The database should always be in recovering mode.

You need to restore the fullbackup again and apply all subsequence transaction log backups.

[rmiao]

Default is norecovery when you set log shipping in maintenance plan. How did you set that?

[thulasi]

Dear


By default it is with no recovery mode only i kept the same thing ...

[thulasi]

HI Khanal,


when i am doing the logshipping process at that time i created a database and i restored full backup after that only i started the servies to run logshipping ....This is the intial stage i am implementing the logshipping concept..

[rmiao]

You have to specify norecovery option when restore db.