Alternative to sp_spaceused

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  October 6, 2011 at 3:51 am

  #1391114

  opc.three (10/5/2011)

  ---

  george sibbald (10/4/2011)

  ---

  declare @dbname sysname

  set @dbname = db_name()

  print @dbname

  select backup_start_date,backup_finish_date,backup_size/1024 as 'size in MB'

  from msdb..backupset

  where database_name = @dbname and type = 'D'

  I have just one tweak. backup_size is in bytes so the label should say 'size in KB'.

  oops, cheers.

  If you want size in MB

  declare @dbname sysname

  set @dbname = db_name()

  print @dbname

  select backup_start_date,backup_finish_date,backup_size,backup_size/1048576 as 'size in MB'

  from msdb..backupset

  where database_name = @dbname and type = 'D'

  ---------------------------------------------------------------------

• sami.sqldba

  Ten Centuries

  Points: 1248

  More actions

  November 16, 2011 at 7:30 am

  #1408508

  Hi Lexa

  Have you ever tryied

  exec sp_help

  or

  exec sp_helpdb

  hope either of this sp will solve out your problem.

  Thanks & Regards
  Syed Sami Ur Rehman
  SQL-Server (Developer)
  Hyderabad
  Email-sami.sqldba@gmail.com