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 |
|
mdissel
Starting Member
4 Posts |
 Posted - 2004-06-07 : 07:15:43
|
| HelloWe've configured our database for FULL recovery mode. A full backup will be run twice a day and a Logfile backup every 15 minutes.Every month we're doing a mass import resulting in a very large file (40 gb, normal 1 gb). Is it possible to truncate and shrink the logfile without breaking the logfile restore functionality.I know that this is not possible when using Logshipping (we tried it, but logshipping will fail, but on this database we don't use logshipping..ThanksMarco |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-07 : 07:17:51
|
| You should be able to shrink the log file without problems but a truncate will lose log entries and you won't be able to restore any further ones until after a full backup.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
mdissel
Starting Member
4 Posts |
Posted - 2004-06-07 : 07:44:11
|
| So if do truncate and shrink of the logfile just before the full backup all should work fine?ThanksMarco |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-07 : 07:58:20
|
| YesMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mdissel
Starting Member
4 Posts |
Posted - 2004-06-07 : 08:59:30
|
| Just to verify.. will this also work when using logshipping?ThanksRegardsMarco |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-07 : 12:14:37
|
| Yes. You need to have a long enough pause between your logshipping and full backup to do this process. Otherwise, it will break.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
truncate shrink logfile with FULL recovery mode