Home Forums SQL Server 7,2000 Administration Database size issues RE: Database size issues
jsph152
Ten Centuries
Points: 1366
More actions
August 20, 2009 at 9:02 am
#1042188
If you go to enterprise manager and right click the database name and go all tasks, shrink database then click on the Files button. You can specify a size to Shrink the file to. Or if you would rather you could use DBCC SHRINKFILE.