Results 1 to 2 of 2

Thread: Reduce SQL Server7.0 database

  1. Jan 12th, 2000, 04:50 PM #1
    Nauj
    Nauj is offline

    Thread Starter
    New Member
    Join Date
    Dec 1999
    Location
    Murcia
    Posts
    13

    Post

    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
    Reply With Quote Reply With Quote
  2. Jan 12th, 2000, 11:31 PM #2
    JP
    JP is offline
    Junior Member
    Join Date
    Jul 1999
    Posts
    16

    Post

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width