Link to home
Start Free TrialLog in
Avatar of Zolf
ZolfFlag for United Arab Emirates

asked on

MSSQL 2008- Running Log Shipping script

Hello there,

I created a Log shipping between 2 servers and at the end I selected the option to save the script. Now,can somebody help me to explain how to use the script as the file extention is (.ssmssln). NExt time I want to create a log shipping how do I run this script,so I dont have to go over all those clicks and windows.

cheers
Zolf
Avatar of arnold
arnold
Flag of United States of America image

Not sure I understand.m if you setup log shipping between two servers, this means there are three jobs on the primary and three on the receiving

Deals with notifying the a transaction login available, create the transactional log backup since the
Last one placing into a location that is shared. One that deals with triggering the remote to copy the backup log, and restore it.
The remaining jobs are to cleanup older transaction logs to maintain free space.
Avatar of Zolf

ASKER

Thanks for your comments.

Let me say it again, How do I use the  the script which has file extension (.ssmssln) to create a new Log shipping next time I restore my Server's OS.
You would use ssms, and load the project .ssmsin.
Avatar of Zolf

ASKER

When I try to open with ssms, I get a Visual Studio upgrade project window,what do I need to do with that
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zolf

ASKER

thanks!!....the problem was the versions.