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 |
|
SqlZ
Yak Posting Veteran
69 Posts |
 Posted - 2003-09-09 : 10:18:33
|
| On one particular server I have I constantly need to keep backing up the logs with truncate_only and shrinking the database because I need more disk space. More disks are on the way but for now I have to deal with it. In any event, I recently received a requirement to log ship this db to our disaster recovery facility and was wondering if log shipping will work with the truncate_only backup log statement because doesn't that blow away the logs?Sorry for the long winded explaination...Thanks in advance. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-09-09 : 12:02:10
|
| No,TRUNCATE_ONLY truncates the log, and thus invalidates any log backups. A regular log backup however should still truncate the log for you, and give the same resultr the truncate_only is giving you. You may have to do it with a bit more frequency though.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 12:07:17
|
| BACKUP LOG without the TRUNCATE_ONLY will free up the space in the LDF file. But the data is saved in a backup file. So you will need the disk space for this for log shipping.Tara |
|
|
|
SqlZ
Yak Posting Veteran
69 Posts |
Posted - 2003-09-09 : 12:20:48
|
| Thanks for your replies."DBAs are overpaid and their jobs are easy...heck, I could do it."-Quote from a former boss who calls often for help and speaks to my voice mail :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 12:25:04
|
| I wish I was overpaid!Tara |
|
|
|
SqlZ
Yak Posting Veteran
69 Posts |
Posted - 2003-09-10 : 13:30:16
|
I wish I was overpaid as well.  |
|
|
|
|
|
|
Log Shipping Question