Make your database backups easier when using SQL Server Management Studio
Script to view database sizes:
SELECT
D.name, F.Name AS FileType, F.physical_name AS PhysicalFile,
F.state_desc AS OnlineStatus,
CAST((F.size*8)/1024 AS VARCHAR(26)) + ' MB' AS FileSize,
CAST(F.size*8 AS VARCHAR(32)) + ' Bytes' as SizeInBytes
FROM sys.master_files F
INNER JOIN sys.databases D ON D.database_id = F.database_id
ORDER BY D.name
BigTables.sql script:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=10932
