Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQl 2008 suspend log shipping

Posted on 2011-09-13
10
Medium Priority
?
530 Views
Last Modified: 2012-05-12
Experts,

what's the best way to suspend log shipping. I need to do a little maintenance on my standby server which may take a few hours. I'd like not to loose my settings so don't want to uncheck the "enable this as primary database......" flag. Should i just disable the jobs? or is there a more convenient way to do this?

thanks,
0
Comment
Question by:telliot79
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 8

Accepted Solution

by:
venk_r earned 1000 total points
ID: 36529824
You can disable  and then enable the jobs thats responsible for log shipping.Make sure you have enough space to store the logs in the meantime as they may get huge.
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36529862
By the way what kind of maintanance are you going to perform.?
0
 

Author Comment

by:telliot79
ID: 36530044
one of the hardware guys needed to reconfigure the disc allocation on a set of our servers.

so is disabling the jobs the only way to do this? or the best way?
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 
LVL 8

Expert Comment

by:venk_r
ID: 36530067
So will you be moving the databse around  with new disc allocation?
0
 

Author Comment

by:telliot79
ID: 36530097
nope. from my side nothing changes. the server just needed to be down for half a day while they worked on it.
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36530128
Then I would say is just disable the jobs and enable them back on when the server is up.It should work.Just make sure you have enough space to store the log backups in the meantime.
0
 

Author Comment

by:telliot79
ID: 36530143
okay thanks, one last question - is there an alternative?
0
 
LVL 8

Assisted Solution

by:venk_r
venk_r earned 1000 total points
ID: 36530163
Well. I dont think so.The other alternatives are really not worth it.
0
 

Author Closing Comment

by:telliot79
ID: 36530231
assumed that was the case, but wanted to make sure. thanks for your help and prompt responses.
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36530300
Your'e welcome.
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question