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
Posted Monday, February 18, 2013 4:56 PM


Group: General Forum Members
Last Login: Yesterday @ 4:25 PM
Points: 2,937, Visits: 4,481
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)

Carl Sagan said: "There is no such thing as a dumb question." Sagan obviously never watched a congressional hearing!
Post #1421380
Posted Tuesday, February 19, 2013 3:08 PM


Group: General Forum Members
Last Login: Yesterday @ 1:00 PM
Points: 159, Visits: 597
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