Log Shipping Solution for 500+ databases

Question

Log Shipping Solution for 500+ databases

Keith West

Mr or Mrs. 500

Points: 516
More actions
March 20, 2008 at 10:21 am

#183520

I am looking for a solution to log ship 500+ databases. We have custom script that will backup the transaction logs of dbs that have logs older than 30 minutes to a shared network location. I am looking for the script that will loop through the files and restore them. We had this script in place on our log shipped server but there was a problem and the script was lost. The script worked perfectly, and we had no issues with it.
Any help is appreciated.
Regards,
Keith

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

This may help: http://www.sqlservercentral.com/articles/Administering/customlogshipping/1201/. I've implemented a variation of this and it has been working for about 1 year with very little intervention/maintenance.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Adam Bean One Orange Chip Points: 26631 More actions · Answer 2

SQL2005 has automated Log Shipping and can be all setup in the GUI if you want to make things easy ...

http://msdn2.microsoft.com/en-us/library/ms190640.aspx

Also, depending on the amount of transactional data you're working with here, you may want to consider using a third party compression tool. Both Quest and RedGate's backup products will build log shipping for you via wizards using their compressed TLOG backups, just like SSMS.

Keith West Mr or Mrs. 500 Points: 516 More actions · Answer 3

The scripts for this process are unavailable. Would anyone happen to know where I might find them?

Steve Jones - SSC Editor SSC Guru Points: 736063 More actions · Answer 4

I'll look around on the old instance for the scripts tomorrow (late now 🙁 )

I'd think about potentially separating out some log backups to separate drives to spread the load a bit.

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

May I recommend that you have scripted files of every object you keep in your databases. Back them up, and also put them into source code control system as well. :hehe:

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service