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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2013-01-07 : 11:32:26
|
| Hello there.I am trying to backup a transaction log that is about 2 gig in size but only a couple of MBs are being truncated.what could be causing the log not to truncate. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2013-01-07 : 11:46:38
|
| What do you mean by truncated?Are you expecting the log backup to shrink the log?All a backup does is release log space to be reused.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2013-01-07 : 11:56:48
|
| that's it. when I back the log that is 2 gig. it doesn't release any spacethe log file still shows 2 gig |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2013-01-07 : 13:55:58
|
| Check log_reuse_wait and log_reuse_wait_desc in sys.databases. It will tell why it didn't. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2013-01-08 : 03:48:17
|
| when i select * from sys.databases i get the following messageAn error occurred while executing batch. Error message is: The directory name is invalid. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2013-01-08 : 03:56:52
|
| this is due to low disk space |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2013-01-08 : 04:01:49
|
| Is that 2GB in size or 2GB used? Is there free space in the log - if not it will grow in size, if there is free space it will be used and is not a problem - you can reduce the size by a shrink.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2013-01-08 : 04:04:06
|
| i thought shrinking was meant to be avoided? |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2013-01-08 : 04:08:29
|
| thank you i have done that and i have just freed up 2 gig.why does that happen. why dont the unallocated space become released when the log is backed up |
|
|
|
|
|
|
Transaction log not truncating when backing up