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
 Transact-SQL (2008)
 Log Shipping

Author  Topic 

loknathmahato
Starting Member

27 Posts

Posted - 2011-11-12 : 17:04:53
Hi Friends,

Can somebody explain me that if a Log shipping is running on primary and Secondary server and meanwhile i need to restart both the server for any reason then what should i do or what will actually happen on log shipping after restarting both the server.

1)What will happen if the transaction log is restoring during restarting time?
2)What will happen for copy job which which is running?
3)What will happen for back up job which is running?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-11-12 : 19:04:51
It'll all catch up after the restart. It knows what successfully finished. It keeps track of everything through the log shipping msdb tables.

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

Subscribe to my blog
Go to Top of Page

loknathmahato
Starting Member

27 Posts

Posted - 2011-11-14 : 02:59:17
Hi friends,

One more help , Is there any option in log shipping to delete older transaction file from secondary server as it is deleted in primary server.

Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-11-14 : 12:39:35
I haven't used log shipping since SQL 2000, but I recall that we put a custom script in place to do the delete on the secondary server.

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 -