MSSQL 2008- Running Log Shipping script

zolf
zolf used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
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.

Author

Commented:
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.
Distinguished Expert 2017

Commented:
You would use ssms, and load the project .ssmsin.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
When I try to open with ssms, I get a Visual Studio upgrade project window,what do I need to do with that
Distinguished Expert 2017
Commented:
Not sure I understand. Which version of ssms, which version of studio? Which versions were used to create the ssms in project?

Is this a production system?
Usually it will be in plated via updates or when apps are installed.

Author

Commented:
thanks!!....the problem was the versions.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial