PDA

Click to See Complete Forum and Search --> : Reduce SQL Server7.0 database


Nauj
Jan 12th, 2000, 03:50 PM
I'm worhing with SQL Server7.0 and I have created a database.
I have objets and data in my database
My database have 300Mb and I only need about 50.
How can I reduce to 50 the dimension of my database.
Is it posible??
Any advice will be greatly apreciatted.

Nauj

JP
Jan 12th, 2000, 10:31 PM
Hi,

Try this....
1. Start Enterprise Manager
2. Find the database you want to resize and click on it's name.The right hand side split shows database details.
3. In the top grey box is an option to shrink database. Click on it and off you go....

Hope this is correct and helps!!

JP