Reducing db Size help, Please

[rkasnick]

I have a SQL2K database that is 12 GB in size. I would like to make the max size 9 GB. Shrinking the db frees up space but doesn't reduce the overall size. THe online manuals aren't much help, probably because I am using the wrong search term. Can anyone point me in the right direction?

Thanks

 

[SQLSister]

If the database was originally created as 12G, then it cannot be shrunk smaller than that.

Questions about posting. See faq183-874

 

[rkasnick]

Well, that explains why I can't find anything on how to do it. THanks for your response.

Rod