November 13, 2014 at 9:59 am
From Database Properties Initial Log file size = 25 MB
From DBCC sqlperf (logspace) LogSize 24.87 and LogSpaceUsed 1.04%
From Shrink File Currently allocated space 24.88 MB and Available free space 24.63 MB (98%)
DBCC Loginfo:
filed filesize startOffset FsqlNo. Status Parity Create LSN
2 13042664 8192 80 2 64 0
2 13042664 13049856 77 0 128 0
Since free space is more than 24 MB and I trying to make .ldf file size to 10 MB.
I changed 'Initial size' in Database Properties to 10 MB
I did, 'Release unused Space'
I did Shrink file to 10 MB
Took Log backup
Nothing working, can't make .ldf log size to 10 MB !!!!!!!!!!
Am I missing something here?
Please help.
November 13, 2014 at 10:01 am
You're fighting about 15MB of space?
November 13, 2014 at 10:18 am
IIRC, the initial size of the log is stored in the header, and you cannot shrink below this initial size. As mentioned, not sure this is worth it for 15MB, but if it's a lot larger, like 15GB, then I think you need to create a new database with the size log you want at the smallest size needed.
The first answer here as more info: http://dba.stackexchange.com/questions/56883/shrink-the-database-only-up-to-its-initial-size-which-is-set-after-creating-data
November 13, 2014 at 11:03 am
No sir, trying to do on a 'Test' so I can do it on Prod.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply