When I need do maintenance task on a SQL Server DataBade, usually run the next steps: use dbname; GO –Full backup of DB BACKUP DATABASE dbname TO DISK = ‘Z:\SQLServerBackups\dbname.bak’ ; GO — Reclaim free space of the data base DBCC SHRINKDATABASE ; GO — verify and repair tables and […]