To get the size of the database based on the tables

• Smash125

  Hall of Fame

  Points: 3562

  More actions

  November 17, 2014 at 4:04 am

  #295108

  I have 57 tables,7 views and 1 stored procedure. Just wanted know based on these requirements how can I find the size of the database. Though the DB contains lots of tables, views and procedures. I am moving these details to new DB server. So I need to put right requirements. Any anybody help on this

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 17, 2014 at 4:07 am

  #1758922

  Here is the script I'm using:

  http://www.sqlservercentral.com/Forums/FindPost1002319.aspx

  -- Gianluca Sartori

• Xedni

  SSCertifiable

  Points: 6951

  More actions

  November 17, 2014 at 2:21 pm

  #1759093

  Unless you need a more granular breakdown, you can just run sp_spaceused on the database itself. e.g.

  use AdventureWorks2014

  go

  exec sp_spaceused

  Executive Junior Cowboy Developer, Esq.[/url]