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
 General SQL Server Forums
 New to SQL Server Administration
 how to understand log shipping ?

Author  Topic 

java148
Yak Posting Veteran

63 Posts
Posted - 2011-11-07 : 22:38:53
reading online tutorial, found this, don't understand. what is "Log shipping failover"? , meaning it can't copy transaction log to network drive ? what is "manually failover the server" ? meaning replace the failed primary server with secondary one ?

Thanks

Log shipping failover is not automatic. The DBA must still manually failover the server, which means the DBA must be present when the failover occurs.

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2011-11-07 : 22:41:26
A failover means that you've decided to make the secondary server the primary and you've restored the final transaction log to the secondary and switched roles. Manual failover means manual intervention by a DBA.

Mirroring allows for automatic failover, log shipping doesn't, well not really.

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

Subscribe to my blog
Go to Top of Page

java148
Yak Posting Veteran

63 Posts
Posted - 2011-11-08 : 16:22:56

what do you mean "not really"?

Thanks

Mirroring allows for automatic failover, log shipping doesn't, well not really.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2011-11-08 : 17:06:35
I mean you could script it (log shipping) so that it would be automatic. It would take a lot of work, but it certainly can be done.

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

Subscribe to my blog
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site