Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

quickly create logshipping for 100 db

Posted on 2014-10-09
Last Modified: 2014-10-27

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


Question by:bibi92
  • 2
  • 2
LVL 26

Expert Comment

ID: 40373078
LVL 42

Expert Comment

ID: 40373722
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 ...
LVL 51

Expert Comment

by:Mark Wills
ID: 40374040
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
LVL 26

Expert Comment

ID: 40374086
And by the way, there is no such thing like "a script for create quickly logshipping for 100 db", unfortunately. :)
LVL 51

Accepted Solution

Mark Wills earned 500 total points
ID: 40374202
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).

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question