Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
djj55
Constraint Violating Yak Guru
352 Posts |
 Posted - 2013-04-22 : 11:00:04
|
| 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?Thanksdjj |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-04-22 : 15:08:17
|
| 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? |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-04-22 : 15:14:20
|
| 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 |
|
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-04-22 : 15:41:29
|
| 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 |
|
|
|
|
|
|
Log backup/Log shipping