administracion de sql server

--espacio disponible en discos duros
EXEC master..xp_fixeddrives
--fechas desde la ultamia creacion de respaldo de bases de datos
SELECT B.name as Database_Name, ISNULL(STR(ABS(DATEDIFF(day, GetDate(),
MAX(Backup_finish_date)))), 'NUNCA') as DaysSinceLastBackup,
ISNULL(Convert(char(10), MAX(backup_finish_date), 101), 'NUNCA') as LastBackupDate
FROM master.dbo.sysdatabases B LEFT OUTER JOIN msdb.dbo.backupset A
ON A.database_name = B.name AND A.type = 'D' GROUP BY B.Name ORDER BY B.name
--tamaño de bases de datos
--exec sp_helpdb 'captura'
use captura exec sp_spaceused
--use master exec sp_helptext 'sp_spaceused'