November 26, 2014 at 3:01 am
I have SQL Server 2008 R2 installed in my production server which has almost 10-15 databases. all these databases are live and clients are accessing all the time. i have setup a log shipping against all these databases. which means one Log backup job and 2(copy log,restore log) jobs for each site i have to manange.
is there anyway i can configure one backup job for all sites and then 2 jobs only for copy and restore.
I have set-up previously a maintenance task to take log backup for all the databases and then a script on log ship server to check the last log file for each database and then restore that.. but i am not comfortable with that..
November 26, 2014 at 3:37 am
I have a Powershell script for that: http://spaghettidba.com/2013/02/08/manual-log-shipping-with-powershell/
Hope it helps
-- Gianluca Sartori
November 26, 2014 at 5:07 am
Thanks, i am doing similar sort of stuff within SQL Server. but with two Jobs on to take backup and second to copy file across and restore it.
The only drawback is that if somehow secondary server goes offline for an hour or so, log shipping will not catchup. but in normal log shipping everything comes backup automatically.
December 12, 2014 at 11:49 am
Shahzadi (11/26/2014)
The only drawback is that if somehow secondary server goes offline for an hour or so, log shipping will not catchup. but in normal log shipping everything comes backup automatically.
Use a differential backup to bridge the LSN gap and help LS catch up 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply