DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql server ???

  1. #1
    Join Date
    Oct 2000


    Has anyone here done admin on sql server 6.0. I am an oracle
    DBA but have been told to resize a sql server database ...the
    current size is 12gb and it has only 1gb of data. I want to resize it
    to 2gb and use the rest of the space to upgrade to sql server 2000.

    PS: I have absolutely no knowledge of sql server. Is there any
    forum from where i will get this information.

    Thanks !


  2. #2
    Join Date
    Nov 2000
    Baltimore, MD USA
    Wow. It's been a while, but when I did SQLServer, I found almost everything was fully documented in the books on-line. Their documentation is very good. Of course, I last used SQLServer 6.5, so I may be a little hazy on 6.0. But search the books on-line (the normal electronic documentation that comes with the product) for 'SHRINK DATABASE'. There should be several matching entries for that. You'll want to back up everything, of course - especially master. I think the command is DBCC SHRINKDB, but it's been a very long time. There are several restrictions for doing this, but I don't remember what. The docs should tell you. If not, let me know and I'll try to dig up some of my old SQLServer stuff tonight (If I remember ;) )

    Hope this helps

    - Chris

  3. #3
    Join Date
    Oct 2000
    Some sites I have browsed/used in the past are:

    Good Luck!

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.