Why did the model database log file grow every day with no activity? The reader was backing up the model database every night. Here is the proof.
SQL SERVER – master Database Log File Grew Too Big
A reader found the master database log file grew very large even in simple recovery mode. I share the full email and ask what you would suggest.
Striped Backups: Writing One Backup to Several Files
Use striped backups across several files, inspect media families, restore every stripe, and test resource settings on your own server.
Restoring to a Newer SQL Server Is a One-Way Trip
Plan a restore to newer SQL Server with the version boundary in mind, preserve the original backup, and understand options for moving data back.
SQL SERVER – Installing AdventureWorks for SQL Server
SQL Server 2012 Denali had no sample database, so here is how to install AdventureWorks for SQL Server by attaching the data file with FOR ATTACH_REBUILD_LOG.
SQL SERVER – Get Database Backup History for a Single Database
A reader script by aasim abdullah to get database backup history for a single database: backup file, size, time taken, LSNs and the type of each backup.
SQL SERVER – Finding Last Backup Time for All Database
A quick script I use to find the Last Backup Time for all the databases on my server, joining sys.sysdatabases with msdb.dbo.backupset.