by Edward P » Sun, 10 Jun 2001 01:46:30
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
by Rick Sawtel » Sun, 10 Jun 2001 04:09:36
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
sp_attachdb <sp>
The shrinkdatabase command works in a batch mode and you may not see the
results immediately.
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.
HTH
Rick Sawtell
Quote:> 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
1. Moving databases and data devices to new server in SQL 6.5
I have SQL databases and devices which are on SQL 6.5. The server which
runs the SQL 6.5 is old hardware and we recently got a brand new computer.
I would like to move all the SQL databases and related devices from this old
server to the new SQL 6.5 server.
Any suggestions on how I can do this?
Atif Butt
3. Moving database to new devices
5. moving database to new device
7. How to move Master database to new device
8. help move database to new device
9. Moving Devices and SQL Server to a New Physical Location
10. Problem-- Move Transaction Log to New Device
11. Negative DB Device sizes after moving to new HDD
12. Problem -- Move Log to New Device