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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:13 AM
Points: 2,044, Visits: 3,060
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)
"In America, every man is innocent until proven broke!" Brant Parker
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, June 16, 2014 10:44 AM
Points: 153, Visits: 583
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: Tuesday, August 26, 2014 1:40 PM
Points: 85, Visits: 400
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