sql server ???
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