http://www.askmefast.com/Programming_~_Design-ycat.html

http://www.askmefast.com/Programming_~_Design-ycat.html#.T4__NsXNcP4.blogger

Store Procesure

Log shipping

                        Log Shipping is a basic SQL Server high-availability technology that is part of SQL Server.Log backup is taken on primary server  for certain periods and  Log are restore on secondary server on schedule basis.

                        Log shipping create  backup job.Example on primary server job name will LSBackup_AdventureWorksLT2008.

                        Log shipping create restore job  on secondary server for example LSRestore_DINESH\TEST3_AdventureWorksLT2008 .