Estimate backup size

To get a quick estimate of the full backup size of our user databases – for planning – I ran this across production and pasted ‘database_name’ and ‘reserved’ into a spreadsheet.

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; if db_id()>4 EXEC sp_spaceused'

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s