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
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
Last Comment
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.
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.
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
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.
ASKER
thanks!!....the problem was the versions.
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.