Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Waring alters when the database (files MDF, NDF & LDF) reaching the MAX size. Expand / Collapse
Author
Message
Posted Monday, February 18, 2013 4:56 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 4:14 PM
Points: 3,050, Visits: 4,673
Ranzz (2/18/2013)
It cant be possible to set unlimited growth.

So, that is the reason, I am looking for some thing that will help us.





It is possible in SQL Server.

Maybe your specific company has a policy against it, so you're not allowed to do it?

Stupid policy, but you may not be able to change it.


SQL DBA,SQL Server MVP('07, '08, '09)

"If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them." James Blackburn, in closing argument in the "Fatal Vision" murders trial
Post #1421380
Posted Tuesday, February 19, 2013 3:08 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 24, 2015 8:24 AM
Points: 159, Visits: 601
Any help from the other members!
Post #1421871
Posted Wednesday, February 20, 2013 8:00 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 9, 2015 12:22 PM
Points: 85, Visits: 410
At some point you will need to do some work yourself. If you need to set max size, then YOU need to find out how much the database is growing, by day, week, or month. Then determine the max number to set and monitor the growth.

Several options have been suggested. They may not work "as is" but look at them and determine for your situation what will work best. You will learn valuable information about your server and database and gain a better understanding for the future.



______________________________
AJ Mendo | @SQLAJ
Post #1422099
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse