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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2007-08-23 : 00:02:16
|
| Hi there I'm doing maintenance on one of transaction log database by doing DBCC SHRINKFILE and sets the size as 10% data size. Before DBCC:55130.44MB data size / 54631.12MB used space / 499.82MB unused space46619.99MB tlog size / 162.89MB used space / 46457.1MB unused spaceAfter DBCC:55130.44MB data size / 54631.12MB used space / 499.82MB unused space46619.99MB tlog size / 57.89MB used space / 5437.1MB unused spaceThe TLOg size was shrink to what I want but how come the size of the used space also shrink from 162.89 to 57.89. Is this going to be problem if we have an hour transaction log?Thanks |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-08-23 : 00:09:35
|
| There will not have any issues, but why do you need to shrink it, ass most likely the file will grow back to the size before you shrink it anyway, through some rebuild index or other batch import or whatever.It growth to that size for a reason, unless you find out that cause, you will find the log file become big again very soon. |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-08-24 : 04:19:46
|
quote:
There will not have any issues, but why do you need to shrink it, ass most likely the file will grow back to the size before you shrink it anyway, through some rebuild index or other batch import or whatever. It growth to that size for a reason, unless you find out that cause, you will find the log file become big again very soon.
I realise this and I just want to know the initial size of transaction log and see how's the file growth after indexdefrag etc etc. We might have tuning again for transaction log backup make it more frequent (at the moment is already running 15 minutes).Are you sure not affecting when you do a restore later on? Let say you have 15 minutes transaction log backup start at 00:00 and let say at 7.20am i have to do dbcc shrinkfile (the tlog file was shrink including the used space) and for unknown reason 10:00am database corrupted and i have to restore full and then apply transaction log from middnight till 10am. My concern is actually what happen with the 7.30am one?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-25 : 00:01:38
|
| That will not affect log file size, sql set file size when restore from full backup. |
|
|
|
|
|
|
Any impact on DBCC SHRINKFILE?