March 18, 2010 at 9:31 am
Hello there,
i do have a database running on sql 2005 express edition. Apparently the size of the databasefile is 3.86 Gb, the log file is 82.6 Mb. I tried using the dbcc shrinkdatabase ()script and it only dropped the log file from 82.6 Mb to 504 Kb, but the database file remained intact in size. please help me with what i should do to shrink the database file. I tried the shrinkdatafile script, it didn't work either.
Thanks,
Timothy
March 18, 2010 at 10:00 am
Why do want to shrinkdatabase? They are not big, even if you shrink it will expand if it is required.
what is the minimum size of the database?
March 18, 2010 at 10:05 am
well sql server 2005 express edition has a limit on the size of the database file. This limit is 4Gb and am already hitting the limit meaning no more transactions can be added to the Database.
March 18, 2010 at 10:31 am
Ok, then what is the Initial size and unused space on this file?
March 18, 2010 at 10:38 am
The initial size is 3912 MB.
March 18, 2010 at 12:08 pm
If you use DBCC shrinkfile option, You should be able to shrink the file size below initial size if there is unused space available in the file. Can you please post the script here which you were using to shrinkfile?
March 19, 2010 at 4:43 pm
If you don't have any free space in the file, then you will need to seek out alternative methods. Shrinkfile should help you shrink the database - if there is free space.
Alternative methods
1. Archive Data into a different database
2. Upgrade to a different version of SQL Server, rather than use SQL Express.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 8:05 pm
dbcc shrinkfile (testdatabase_Till)
March 19, 2010 at 11:59 pm
Yes that is the command we are referring to.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply