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.
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 ;) )