Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vincent721
Starting Member
2 Posts |
 Posted - 2011-09-15 : 03:15:00
|
| Hello i have a db SQL with SQL2008 R2 sp1 ,fore some reason my DB must be increase of size , and i do following the next procedure :To increase the size of a database1.In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.2.Expand Databases, right-click the database to increase, and then click Properties.3.In Database Properties, select the Files page.4.To increase the size of an existing file, increase the value in the Initial Size (MB) column for the file. You must increase the size of the database by at least 1 megabyte.5.To increase the size of the database by adding a new file, click Add and then enter the values for the new file. For more information, see How to: Add Data or Log Files to a Database (SQL Server Management Studio).6.Click OK.And the DB show new size about 30gb but this is my problem after few minutes the size of db became again 5gb , i can not understand why , in my hard disk there is free space for new size , but the db became always small, please help me.Thank you Vincent |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-15 : 03:54:04
|
| is there some backup jobs scheduled in db? is there some weekly purging activities happening?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
vincent721
Starting Member
2 Posts |
Posted - 2011-09-15 : 14:28:28
|
| i dont know i am new about sql , my db increase everyday , maybe do you have some setting to chek , pls help me ,thank you Vincy |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-15 : 14:34:45
|
| with limited information provided i dont think its easier for someone to suggest something------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-09-15 : 15:11:41
|
| You have autoshrink enabled. Turn it off.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
db sql problem