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!
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
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.
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.
When I try to open with ssms, I get a Visual Studio upgrade project window,what do I need to do with that
Premium Content
You need an Expert Office subscription to comment.Start Free Trial