SQL Server Backup Tips

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
ORDER BY D.name