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

script - growing database. Expand / Collapse
Author
Message
Posted Monday, September 23, 2013 2:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 61, Visits: 386
Friends,

someone could share with me a script that calculates the growth of a database and store on table? weekly and monthly?
Post #1497551
Posted Monday, September 23, 2013 8:36 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:00 PM
Points: 5,567, Visits: 24,747
This will give you the current size of the database;

select SIZE AS '8k PAGES' FROM sys.database_files WHERE TYPE = 0
run this as a select, inserting the output into a table.

Then to do what you want to do, set up a job and run at your desired time(s)


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1497625
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse