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 2005 Forums
 SQL Server Administration (2005)
 Log Shipping - Change Server Name

Author  Topic 

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2009-10-31 : 10:33:57
Hi,

Once log shipping has been setup and is working, can the server name of the secondary server be changed without breaking log shipping?

Also - Are there any issues with configuring a primary server to ship logs to TWO secondary servers?

Thanks,
Terry

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-31 : 12:20:52
1. Yes, but you'd have to update all of the log shipping tables in the msdb database to reflect the new name.
2. No, that's one of the reasons to use log shipping in SQL Server 2005 over database mirroring.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2009-11-01 : 14:59:54
Thanks Tara.

Is there a place you can point me to where I can see which log shipping tables need to be modified and the necessary queries? I searched Google but cannot find any specifics.

Regards,
Terry
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-01 : 21:51:12
Look in the msdb database and find all of the tables that have log_shipping in the name. Modify the ones where your secondary server appears.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -