Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

configuring Loghsipping in 2k8 Expand / Collapse
Author
Message
Posted Sunday, January 6, 2013 10:21 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 11:07 PM
Points: 29, Visits: 410
Hi,

If anyone knows configuring the logshipping using scripts instead of GUI in slq server 2008..

Provide scripts..
Post #1403404
Posted Monday, January 7, 2013 1:55 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 4:14 AM
Points: 709, Visits: 1,430
Just go through the process of setting up Log Shipping in the GUI of SSMS and instead of hitting Ok to apply the action click the Generate Script > New Query Window button in the top left corner of the window. It will generate the T-SQL script you need. You can then incorporate that how you wish.

Joie Andrew
"Since 1982"
Post #1403477
Posted Monday, January 7, 2013 2:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 11:07 PM
Points: 29, Visits: 410
i Will Try...
Post #1403492
Posted Monday, January 7, 2013 3:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 11:07 PM
Points: 29, Visits: 410
its Working
Post #1403519
Posted Monday, January 7, 2013 4:18 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 4:14 AM
Points: 709, Visits: 1,430
Glad to hear it!

Joie Andrew
"Since 1982"
Post #1403529
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse