1. Didn't see a BCC in my heading, so.. just a CC today.
2. Under 6.5, a good backup and restore is the best way.
3. Under 7.0, take a look at Backup and Restore as well as sp_detachdb and
The shrinkdatabase command works in a batch mode and you may not see the
You cannot issue a shrinkdatabase command and have it shrink to a size
smaller than originally implemented.
For example: CREATE DATABASE ... size = 200MB.
Even if there is no data in the database, issuing a shrinkdatabase will not
decrease the size of this database.
If you have a database that has grown due to autogrowth and then data has
been removed, you can shrink it.
> What is the safest/best way to move a database from a shared database
> device to its own database device in SQL Server 6.5 and 7.0?
> How can I shrink a database and database device in SQL Server 6.5 and 7.0.
> The Shrink Database option in the GUI is not working.
> Please BCC your reply to my email.
> Edward Paul