Database Resizing

[paulpr]

Hi Folks,

Can someone please help?

I am using 7.0 and need to resize a database. The database is currently 9.5gb and I have resized to 15gb all is well and database has been resized.

I arrive at work next day and guess what database back to 9.5gb. Has anyone experienced this problem it is driving me insane. I cannot see any maintenance plans etc. Please help....

Paul.......

 

[tlbroadbent]

SQL Server 7.0 dynamically resizes databases. Make sure the Auto Shrink option is not set ON for the database. If Auto Shrink is on SQL Server will shrink the file. You'll also need to make sure no maintenance runs shrink the database or its files.

Another option is to let SQL Server grow the file as needed and not resize it manually. Is there a compelling reason to set the database size to 15GB?

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[bertrandkis]

Firstly, I will advise you to let SQL server handle the database growth by turning on the Autofilegrowth database property.Secondly If you realy need allocate such a big space before hand just specify the size you want in the file growth property. You can quickly access the DB property page by right clicking on the DB and Choose the Data file tab.

Black belt Sequelist

 

[paulpr]

Cheers guys,

All that you have suggested I have checked. The reason for the database size is it is used for transaction logging and we have 1000's of transactions per day.

I have got it fixed by backing up the database straight after its size has been increased perhaps this sets the database to 15gb as default, dont know but its working. Thanks for your ideas..

Paul........