From a real project: conventional backup and restore, split file backup when a disk runs short of space, mirror file backup, and the FORMAT clause.
What Is a Database Backup? Full, Differential, Log
A database backup comes in three kinds and they work together. Measured sizes for full, differential and log, why the recovery model decides everything, and the restore order that cannot be improvised.
Planning for Data Growth
Planning for data growth uses backup and file trends, workload events, storage lead times, and a dated request for more capacity.
SQL SERVER – Find Current Location of Data and Log File of All the Database
A one line query on sys.master_files that shows the current data and log file location for all databases, handy when cleaning up old .mdf and .ldf files.
SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup
Why should you backup master database? It holds all logins, system configuration and the details SQL Server needs to reach every other database.
SQL SERVER – Restore Master Database – An Easy Solution
A two step easy way to restore master database: start SQL Server in single user mode, then restore from a full backup of master. No full backup, no restore.
Estimating Table Growth for Next Year From Backup History
Estimate table growth with monthly full backup history, a twelve month forecast, and table space checks that separate evidence from guesses.