SQL Backup and Restore Archives - Page 45 of 48 - SQL Authority with Pinal Dave

SQLAuthority News – Best Articles on SQLAuthority.com

November 4, 2007

Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

A list of my best articles so far, from killing all processes in a database and shrinking the log file to deleting duplicate rows and UNION vs UNION ALL.

A lifeboat hanging in its davits on a ferry deck, cover tight and ropes coiled, salt dried across the canvas.

What RESTORE VERIFYONLY Checks and What It Misses

October 17, 2007

Pinal Dave

SQL Tips and Tricks

Database Corruption, DBA, SQL Backup and Restore, SQL Server DBCC

RESTORE VERIFYONLY checks backup readability and checksums, but it cannot prove a full restore or healthy data; pair it with restore tests.

A key that does not fit the padlock on a wooden crate marked BACKUP.

SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database

September 27, 2007

Pinal Dave

SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

Error 3154 says the backup set holds a backup of a database other than the existing database. Use WITH REPLACE in RESTORE, or drop the old database first.

A cook seen from behind tastes from a small trial saucepan while a large covered pot waits beside it.

Testing a Cumulative Update Before Production

September 6, 2007

Pinal Dave

SQL Tips and Tricks

Cumulative Update, SQL Backup and Restore, SQL Patch, SQL Server, Testing

Testing a Cumulative Update means restoring real data, replaying key jobs, comparing plans and timings, and signing off before production.

SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward

September 2, 2007

Pinal Dave

SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

Msg 3117 means the log or differential backup cannot be restored because no files are ready to rollforward. Restore the full backup WITH NORECOVERY first.

SQL SERVER – 2005 – No Backup Support For Named Pipes

August 26, 2007

Pinal Dave

SQL Tips and Tricks

SQL Backup and Restore

SQL Server 2000 had backup support for named pipes, but SQL Server 2005 only backs up to disk and tape. I also share how we back up our own databases.

SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error

August 25, 2007

Pinal Dave

SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

Msg 2540 means the system cannot self repair this error, usually corrupt metadata or system files. My fix order: restore the backup, DBCC repair, check hardware.