SQL Server keeps backup history in msdb forever. Use sp_delete_backuphistory to delete backup history older than 30 days, or any number you pick.
Handing Over a Database to Another Team
Handing over a database should include a current map, tested recovery path, access transfer, open risks, and a defined support period.
SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)
My review of Pro SQL Server 2005 Replication by Sujoy Paul, a good book for any novice who wants to learn database replication setup and maintenance.
The Tools a DBA Installs on Day One
The tools a DBA installs on day one include SSMS, command line utilities, a checked script library, and managed source control.
SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
Why does an LDF file keep growing even with hourly log backups? Imran Mohammed explains what goes on behind the scene of the Transaction Log and shrinking.
SQL SERVER – Download and Install Sample Database AdventureWorks 2005 – Detail Tutorial
Installed SQL Server 2008 and found no samples? A quick tutorial to download and install the Sample Database AdventureWorks, and a note on WideWorldImporters.
SQL SERVER – mssqlsystemresource – Resource Database
What is mssqlsystemresource? It is the Resource Database, a read only database of system objects that makes upgrading SQL Server much easier.