<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 High Availability
»
Setting up log shipping for multiple...
Setting up log shipping for multiple databases
Rate Topic
Display Mode
Topic Options
Author
Message
stephen.chapman 77519
stephen.chapman 77519
Posted Tuesday, July 24, 2012 3:54 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 5:49 AM
Points: 1,
Visits: 127
Hi,
I am new to this forum but I have just had to deal with setting up log shipping for a DR site which would have meant setting this up for 25 databases. As most of you may be aware doing this on a single database can be a chore so you can imagine 25 is laborious work.
After searching around for an easier solution and not really finding much to help (I was on a time limit) I ended up writing my own set of procedures that set up all the log shipping backup jobs, copy jobs and restore jobs in addition to remotely creating the databases on the secondary server, these stored procedures were all initiated from the primary server with minimal configuration.
As I have not seen anything like this in my searches I was wondering if it is something that other DBA's may find useful.
If so I can try to write and publish an article on this site with the code and background information. I assume this is how I go about things.
Post #1334340
Perry Whittle
Perry Whittle
Posted Tuesday, July 24, 2012 4:58 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201,
Visits: 11,153
stephen.chapman 77519 (7/24/2012)
Hi,
I am new to this forum but I have just had to deal with setting up log shipping for a DR site which would have meant setting this up for 25 databases. As most of you may be aware doing this on a single database can be a chore so you can imagine 25 is laborious work.
After searching around for an easier solution and not really finding much to help (I was on a time limit) I ended up writing my own set of procedures that set up all the log shipping backup jobs, copy jobs and restore jobs in addition to remotely creating the databases on the secondary server, these stored procedures were all initiated from the primary server with minimal configuration.
As I have not seen anything like this in my searches I was wondering if it is something that other DBA's may find useful.
If so I can try to write and publish an article on this site with the code and background information. I assume this is how I go about things.
Microsoft already supply a complete set of SPs for setting up and maintaining log shipping
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1334380
opc.three
opc.three
Posted Sunday, July 29, 2012 9:08 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 5:44 PM
Points: 6,703,
Visits: 11,734
stephen.chapman 77519 (7/24/2012)
Hi,
I am new to this forum but I have just had to deal with setting up log shipping for a DR site which would have meant setting this up for 25 databases. As most of you may be aware doing this on a single database can be a chore so you can imagine 25 is laborious work.
After searching around for an easier solution and not really finding much to help (I was on a time limit) I ended up writing my own set of procedures that set up all the log shipping backup jobs, copy jobs and restore jobs in addition to remotely creating the databases on the secondary server, these stored procedures were all initiated from the primary server with minimal configuration.
As I have not seen anything like this in my searches I was wondering if it is something that other DBA's may find useful.
If so I can try to write and publish an article on this site with the code and background information. I assume this is how I go about things.
Hopefully I am misunderstanding you and you did not manually implement log shipping.
How to: Enable Log Shipping (Transact-SQL) - SQL Server 2008 R2
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1337052
jmaikido
jmaikido
Posted Wednesday, December 05, 2012 5:58 PM
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 11:07 PM
Points: 1,
Visits: 65
Hi Stephen,
I have the exact same requirement whereby I have been given the task to LS multiple databases. approx. 25 @ this stage. (SQL2008R2) As I'm not one for reinventing the wheel I presumed there would be code 'out there' available to the SQL community generated by like minded people who have previously encountered such a requirement.
I would be supremely appreciative if you could post your code to enable others to benefit from the time you have devoted towards creating a soluiton.
Many thanks,
John
Post #1393286
Perry Whittle
Perry Whittle
Posted Wednesday, December 05, 2012 11:41 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201,
Visits: 11,153
jmaikido (12/5/2012)
Hi Stephen,
I have the exact same requirement whereby I have been given the task to LS multiple databases. approx. 25 @ this stage. (SQL2008R2) As I'm not one for reinventing the wheel I presumed there would be code 'out there' available to the SQL community generated by like minded people who have previously encountered such a requirement.
I would be supremely appreciative if you could post your code to enable others to benefit from the time you have devoted towards creating a soluiton.
Many thanks,
John
Errr yes, it's called log shipping and its built into the sql server database engine. There are a complete set of SPs for implementing, maintaining and monitoring log shipping so why re invent the wheel?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1393332
Chris Becker
Chris Becker
Posted Thursday, December 06, 2012 2:56 PM
SSC Veteran
Group: General Forum Members
Last Login: Friday, February 22, 2013 11:49 AM
Points: 220,
Visits: 216
Right-click db, properties, see Trans Log Shipping on left?? Follow wizards :)
Regards,
Chris
mssqlconsulting.com
Post #1393763
opc.three
opc.three
Posted Thursday, December 06, 2012 5:43 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 5:44 PM
Points: 6,703,
Visits: 11,734
I think the point is, is there an easy way to setup 25 databases for log shipping without hitting the wizard 25 times.
My answer would be sure, anything can be scripted. Since you're needing to talk to more than one instance at a time as well as potentially setup 25 Windows shares a PowerShell script that calls the procs in the link I showed above would be where I would go with it. You could then call said PowerShell script 25 times, once for each database. Once you have a script that works you could come up with lots of ways to "feed" it the list of
n
primary and secondary instance and database names.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1393811
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
