SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Log backup/Log shipping
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

djj55
Constraint Violating Yak Guru

USA
337 Posts

Posted - 04/22/2013 :  11:00:04  Show Profile  Reply with Quote
Hello,
We log ship. We also do a database backup nightly.
If we do a transaction log backup after the nightly backup will this break log shipping?

Thanks

djj

jeffw8713
Aged Yak Warrior

USA
798 Posts

Posted - 04/22/2013 :  15:08:17  Show Profile  Reply with Quote
If you perform any transaction log backups outside of the log shipping process - that will break log shipping. Why do you think you need to perform this additional log backup? What issue are you trying to address?
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 04/22/2013 :  15:14:20  Show Profile  Visit jackv's Homepage  Reply with Quote
Are you you looking for a high availability solution or a Disaster Recovery Solution , where you can recover to a point in time?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

djj55
Constraint Violating Yak Guru

USA
337 Posts

Posted - 04/22/2013 :  15:41:29  Show Profile  Reply with Quote
What is happening is the log files are getting big. We had one get to half the server storage size and that was just one of several databases stored there.

Point in time recovery is not as important. If we loose the fifteen minute since the last log shipping copy we will be okay.

I guess you would call it disaster reocvery but we would use it to have the database back in buisness quickly.

djj

Edited by - djj55 on 04/22/2013 15:41:52
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000