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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-30 : 09:15:11
|
| Wayne writes "I have a SQL 6.5 database that is 9GB in size, with a 500MB transaction log file. There is approximately 7.7 GB free on the database.I want to shrink it down to about 1.5 GB, but SQL Server will allow me to reduce it by only a few MB.Is there any way to get around this?Thank you." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-30 : 14:00:05
|
| You might be able to get around it by backing up the database, re-creating it on new devices with the appropriate size(s), and then restoring it from the backup. I would recommend creating new devices instead of recycling the old ones, that way if something goes wrong right away you still have the original database device AND the backup. |
 |
|
|
|
|
|
Shrinking 6.5 database