Rolling Back a Cumulative Update needs backups, setup evidence, a tested uninstall path, and special care for databases changed after patching.
SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified
Database backup demystified was my article in the January 2007 edition of SQL Server Magazine, written to sharpen your basic SQL Server skills.
SQL SERVER – Mirrored Backup Introduction and Explanation
SQL Server 2005 Enterprise and Developer editions support mirrored backup: one BACKUP DATABASE command with MIRROR TO writes the same backup to two places.
SQL SERVER – Solution – Log File Very Large – Log Full
Is your log file too big, or is the log full? Fix it in three steps: back up the log file, truncate it, then shrink it. I link my two detailed posts too.
SQLite or SQL Server Express for a Small App
SQLite or SQL Server Express depends on write concurrency, deployment, backup, and the growth path your small application really needs.
SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2
About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments.
SQL SERVER – Generate Script with Data from Database – Database Publishing Wizard
Need to copy data along with the schema? The Database Publishing Wizard scripts schema, data or both into one SQL file you can run on another server.