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 2008 Forums
 SQL Server Administration (2008)
 Turn Transaction Log Shipping back on

Author  Topic 

Cowski
Starting Member

30 Posts

Posted - 2011-07-15 : 16:42:11
I may be overlooking something simple but I can't figure out how to turn transaction log shipping back on after turning it off successfully.

I used the following code to turn it off:


Use Master
Go

Restore Database databasename with Recovery


Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-15 : 18:09:33
You'll need to start over actually. You'll need to restore the full backup with norecovery and go from there.

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

Subscribe to my blog
Go to Top of Page
   

- Advertisement -