Backup retention should preserve restore chains while meeting recovery, legal, and storage needs across full, differential, and log backups.
SQL SERVER – Restore SQL Database using SSMS – SQL in Sixty Seconds #044 – Video
How do I restore SQL Database backups? Everyone takes backups, but few ever test a restore. This SQL in Sixty Seconds video shows the steps in SSMS.
Rehearsing a master Database Restore on a Test Instance
Rehearse a master database restore on a matching test instance, including single-user sqlcmd, automatic shutdown, and configuration checks.
SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD
Good DBAs automate the boring work. Here is a simple script to run Backup and Restore of a database from the command prompt with SQLCMD.
Piecemeal Restore: Bringing the Primary Filegroup Online First
Rehearse a piecemeal restore that brings PRIMARY and current data online first, then restores archive filegroups with the right log chain.
SQL SERVER – Best Practices to Store the SQL Server Backups
Where should SQL Server backups live? I compare popular storage options and what each one risks, using the destinations in SQLBackupAndFTP for the demo.
Maintaining SharePoint Content Databases: What the DBA Still Owns
Review SharePoint content databases for CHECKDB, backup history, log growth, recovery model, and a tested site-collection restore.