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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:59 PM
Points: 1,734, Visits: 2,534
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)
I'm not fat, I'm gravity challenged.
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, March 31, 2014 9:00 AM
Points: 153, Visits: 573
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, March 25, 2014 1:16 PM
Points: 85, Visits: 395
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