April 16, 2008 at 4:57 am
what is the initial size and auto growth values for your database?
and are you sure that ur fill factors are 100%? This is true for the master database...check the differences....
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
November 10, 2010 at 11:08 am
Your tip was really valuable! Thanks.
November 10, 2010 at 2:33 pm
Hi Lian,
Try this
SSMS --> Rt Click on the DB --> Tasks --> Shrink --> Files --> File Type = Data --> Select "Reorganize pages before releasing unused space " and Shrink file to 50 MB.
But before doing this make sure that you have enough free space listed under
"Available Free Space"
Shrink operation cannot shrink the file below the specified "Currently allocated space"
Also try this only after office hours as this will have huge user impact.
Thank You,
Best Regards,
SQLBuddy
August 10, 2011 at 7:35 am
Hi! i have the same problem that SSC Eights!, but a little bigger... i had a Log file of 1 TB,
i tried every single step of every one of the post on this topic and i can´t reduce the size (physical) of the file.
Info:
Shrink File - JDEData_Log
Database: JDEData
File type: Log
File name: JDEData_Log
Location: D:\Bases_simple\JDEData_Log
Currently allocated space: 1058233.44 MB
Available free space: 1055446.77 MB (99%)
Properties of the physical file:
Description: JDEData_Log
Location: D:\Bases_simple
Size: 1.00 TB (1,109,638,184,960 bytes)
Its a SQL Server 2005
any other ideas?
August 10, 2011 at 7:35 am
Hi! i have the same problem that SSC Eights!, but a little bigger... i had a Log file of 1 TB,
i tried every single step of every one of the post on this topic and i can´t reduce the size (physical) of the file.
Info:
Shrink File - JDEData_Log
Database: JDEData
File type: Log
File name: JDEData_Log
Location: D:\Bases_simple\JDEData_Log
Currently allocated space: 1058233.44 MB
Available free space: 1055446.77 MB (99%)
Properties of the physical file:
Description: JDEData_Log
Location: D:\Bases_simple
Size: 1.00 TB (1,109,638,184,960 bytes)
Its a SQL Server 2005
any other ideas?
August 10, 2011 at 8:19 am
sebastian.rodriguez 21698 (8/10/2011)
Hi! i have the same problem that SSC Eights!, but a little bigger... i had a Log file of 1 TB,i tried every single step of every one of the post on this topic and i can´t reduce the size (physical) of the file.
Info:
Shrink File - JDEData_Log
Database: JDEData
File type: Log
File name: JDEData_Log
Location: D:\Bases_simple\JDEData_Log
Currently allocated space: 1058233.44 MB
Available free space: 1055446.77 MB (99%)
Properties of the physical file:
Description: JDEData_Log
Location: D:\Bases_simple
Size: 1.00 TB (1,109,638,184,960 bytes)
Its a SQL Server 2005
any other ideas?
Please start a new thread after reading these (but you shouldn't have to) :
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
August 11, 2011 at 3:37 am
Ninja's_RGR'us (8/10/2011)
sebastian.rodriguez 21698 (8/10/2011)
Hi! i have the same problem that SSC Eights!, but a little bigger... i had a Log file of 1 TB,i tried every single step of every one of the post on this topic and i can´t reduce the size (physical) of the file.
Info:
Shrink File - JDEData_Log
Database: JDEData
File type: Log
File name: JDEData_Log
Location: D:\Bases_simple\JDEData_Log
Currently allocated space: 1058233.44 MB
Available free space: 1055446.77 MB (99%)
Properties of the physical file:
Description: JDEData_Log
Location: D:\Bases_simple
Size: 1.00 TB (1,109,638,184,960 bytes)
Its a SQL Server 2005
any other ideas?
Please start a new thread after reading these (but you shouldn't have to) :
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Blast from the past 🙂
Viewing 7 posts - 31 through 36 (of 36 total)
You must be logged in to reply to this topic. Login to reply