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 |
|
tkatende
Starting Member
8 Posts |
 Posted - 2010-03-18 : 10:59:52
|
| 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 |
|
|
acollins74
Yak Posting Veteran
82 Posts |
Posted - 2010-03-18 : 11:23:24
|
| Your data file probably will not shrink because you do not have any free space available in the datafile.Are you concerned about the file size limit on Express? You may be looking at needing to either archiving off data and then shrinking or upgrading your version. |
 |
|
|
|
|
|
RE:shrinking database