script - growing database.

• LOVER OF SQL

  SSCommitted

  Points: 1900

  More actions

  September 23, 2013 at 2:23 pm

  #283614

  Friends,

  someone could share with me a script that calculates the growth of a database and store on table? weekly and monthly?

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  September 23, 2013 at 8:36 pm

  #1652542

  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[/url]
  Before posting a performance problem please read[/url]