quickly create logshipping for 100 db


I search a script for create quickly logshipping for 100 db.


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
try to use 3rd party tools to setup Logship
e.g. idera sqlsafe https://www.idera.com/productssolutions/sqlserver/sqlsafebackup

Logship setup is much more complicated task than you may expect:
as the main idea it is backup trans log and restore.
however, it needs some experience to setup and  make sure all dependencies are in place..
it can not be too quickly ...
Mark WillsTopic AdvisorCommented:
And of course the "tricky bit" is restoring. So adding to zbertoc's setup entry is  : http://www.mssqltips.com/sqlservertip/1516/automate-restoration-of-log-shipping-databases-for-failover-in-sql-server/ and worthwhile reading the comments (keep an eye out for bassplayerdoc.wordpress.com link - worthwhile).

But, Eugene is quite correct... It is more involved (not quite sure "complicated" is the correct term - sorry Eugene)

See : http://blogs.technet.com/b/josebda/archive/2009/04/02/sql-server-2008-log-shipping.aspx for a good overview with appropriate MS links
And by the way, there is no such thing like "a script for create quickly logshipping for 100 db", unfortunately. :)
Mark WillsTopic AdvisorCommented:
Well, reluctantly, there is a pretty good example from Ms Gardner : http://blogs.msdn.com/b/sqlgardner/archive/2011/09/27/implementing-log-shipping-for-many-databases.aspx 

I used a version of it a couple of years back but (for me) was heavily modified. So, it is involved and didn't want to simply provide "a script" without further consideration (and knowledge). It can be a trap.

So, before anyone simply dives in to copy the scripts, they MUST first understand the procedures in use (let alone T-SQL techniques being used) : http://msdn.microsoft.com/en-us/library/ms190640.aspx#TsqlProcedure and then read through http://sqlserversblog.com/SQL_Server_Log_shipping.html

As I said before... It is more involved that one often considers - again echoing Eugene's warning.

And to echo Zbertoc, from my own experience, there is no such thing as a ready made script unless you have the experience and knowledge of what Log Shipping really is and does and experienced with first doing one manually so you discover your own conditions and circumstances. Each situation does need individual consideration and planning.

I am a little reluctant posting Lisa's script, so be warned and read very carefully - there are various assumptions (server setup, credentials+security, disks+folders, shares etc).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.