How to resolve Log Shipping Error “Exclusive access could not be obtained because the database is in use.RESTORE LOG is terminating abnormally”?

Hello Friends,
This error normally came when you did log shipping on your database and  your secondary server database in stand by  mode.
In this error your secondary server database restore job will not work. To resolve this error you just need to change the log shipping setting.
When you configure secondary server database mode   there is check box which says disconnect all collection at the time of restore database so just check that check box and you will find your log shipping is working.

Thanks

Rajat

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s