Avatar of Zolf
Zolf
Flag 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
Microsoft SQL ServerDatabases

Avatar of undefined
Last Comment
Zolf

8/22/2022 - Mon
arnold

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.
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.
arnold

You would use ssms, and load the project .ssmsin.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
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
arnold

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Zolf

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