The Curious Case of… restoring a table into a different database

Posted on: February 9, 2020 2:17 pm

New Pluralsight course: Understanding and Performing Backups

Posted on: November 8, 2017 4:54 am

SQLskills SQL101: Log shipping performance problems

Posted on: August 15, 2017 11:56 am

SQLskills SQL101: Why is restore slower than backup

Posted on: May 17, 2017 10:41 am

SQLskills SQL101: Restoring to an earlier version

Posted on: April 20, 2017 10:50 am

SQLskills SQL101: Switching recovery models

Posted on: March 29, 2017 12:44 am

You can upgrade from any version 2005+ to any other version

Posted on: May 27, 2016 10:58 am

Finding a transaction in the log for a particular user

Posted on: June 3, 2015 11:45 am

When is fast recovery used?

Posted on: September 15, 2014 1:40 pm

Why is log_reuse_wait_desc saying LOG_BACKUP after doing a log backup?

Posted on: November 13, 2013 12:33 pm

The Accidental DBA (Day 11 of 30): Backups: Backup Storage and Retention

Posted on: June 11, 2013 8:00 am

The Accidental DBA (Day 10 of 30): Backups: Backup Testing for Validation

Posted on: June 10, 2013 8:00 am

The Accidental DBA (Day 9 of 30): Backups: Essential BACKUP Options

Posted on: June 9, 2013 8:00 am

The Accidental DBA (Day 8 of 30): Backups: Planning a Recovery Strategy

Posted on: June 8, 2013 8:00 am

The Accidental DBA (Day 7 of 30): Backups: Recovery Models and Backup Types

Posted on: June 7, 2013 8:00 am

The Accidental DBA (Day 6 of 30): Backups: Understanding RTO and RPO

Posted on: June 6, 2013 8:00 am

Easy automation of SQL Server database maintenance

Posted on: April 16, 2013 1:32 pm

Importance of how often you take full backups

Posted on: December 21, 2012 11:39 am

Importance of where you store your backups

Posted on: December 21, 2012 6:52 am

Survey: how often do you perform a full backup?

Posted on: December 6, 2012 6:41 pm

Survey: where do you store your database backups?

Posted on: December 4, 2012 10:49 am

Using fn_dblog, fn_dump_dblog, and restoring with STOPBEFOREMARK to an LSN

Posted on: May 17, 2012 3:05 am

SQL Server Magazine: feature article on using database repair

Posted on: August 25, 2011 11:29 am

TechNet Magazine: July 2011 SQL Q&A column

Posted on: July 21, 2011 3:11 pm

SQL Server Magazine: feature article on advanced BACKUP and RESTORE options

Posted on: May 24, 2011 11:31 am

Disaster recovery 101: backing up the tail of the log

Posted on: June 18, 2010 9:21 am

Presenting for PASS DBA virtual chapter June 9th

Posted on: June 3, 2010 10:06 am

A SQL Server DBA myth a day: (30/30) backup myths

Posted on: April 30, 2010 9:19 am

A SQL Server DBA myth a day: (27/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB

Posted on: April 27, 2010 3:23 pm

A SQL Server DBA myth a day: (24/30) twenty six restore myths

Posted on: April 24, 2010 8:42 am

A SQL Server DBA myth a day: (20/30) restarting a log backup chain requires a full database backup

Posted on: April 20, 2010 1:24 pm

TechNet Magazine: March 2010 SQL Q&A column

Posted on: March 5, 2010 1:14 pm

TechNet Magazine: January 2010 SQL Q&A column

Posted on: January 4, 2010 1:09 pm

What can cause log reads and other transaction log questions

Posted on: December 9, 2009 4:14 pm

TechNet Magazine: feature article on recovering from disasters using backups

Posted on: November 5, 2009 8:36 am

New script: is that database REALLY in the FULL recovery mode?

Posted on: October 7, 2009 1:27 pm

SQL Server 2008 High Availability whitepaper published on MSDN

Posted on: September 28, 2009 12:42 pm

TechNet Magazine: Feature article on backups and backup strategy

Posted on: June 5, 2009 3:35 pm

Backup monitoring and reporting

Posted on: June 4, 2009 10:20 am

Misconceptions around the log and log backups: how to convince yourself

Posted on: May 29, 2009 11:09 am

New script: how much data will the next log backup include?

Posted on: May 24, 2009 2:32 pm

Weekly survey: have you ever tested your disaster recovery plan?

Posted on: May 17, 2009 5:38 pm

Importance of having the right backups

Posted on: May 2, 2009 6:32 am

Weekly survey: what kind of backups do you take?

Posted on: April 27, 2009 2:44 am

Why could restoring a log-shipping log backup be slow?

Posted on: April 21, 2009 5:48 pm

Importance of proper transaction log size management

Posted on: April 10, 2009 12:21 pm

Is running repair on msdb safe?

Posted on: March 25, 2009 9:02 am

Msg 602, Level 21, State 50, Line 1

Posted on: March 25, 2009 8:13 am

Measuring ‘churn’ in a SharePoint content database using SQL Server

Posted on: March 23, 2009 10:33 am

Importance of validating backups

Posted on: March 13, 2009 5:17 pm

How can a log backup fail but a full backup succeed?

Posted on: March 7, 2009 8:57 am

Testing a new survey method: backup validation

Posted on: March 5, 2009 5:54 pm

TechNet Magazine: February 2009 SQL Q&A column

Posted on: January 16, 2009 10:15 am

Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup

Posted on: November 26, 2008 5:43 am

Conference corruption demo scripts and example corrupt databases

Posted on: November 24, 2008 11:27 am

TechNet Magazine: December 2008 SQL Q&A column

Posted on: November 12, 2008 11:51 am

Conference Questions Pot-Pourri #9: Q&A around compression features

Posted on: November 11, 2008 9:29 am

High-end backup compression numbers

Posted on: October 29, 2008 8:36 pm

Planning a backup strategy – where to start?

Posted on: October 26, 2008 11:13 am

TechNet Magazine: October SQL Q&A column

Posted on: September 23, 2008 1:07 am

Search Engine Q&A #25: Why isn’t my log backup the same size as my log?

Posted on: August 25, 2008 12:23 am

SQL Server 2008: Does my database contain Enterprise-only features?

Posted on: August 23, 2008 4:06 pm

Search Engine Q&A #23: My transaction log is full – now what?

Posted on: August 14, 2008 3:05 pm

Search Engine Q&A #22: Can all page types be single-page restored?

Posted on: August 11, 2008 7:32 pm

How to tell if you have instant initialization enabled?

Posted on: August 11, 2008 7:10 pm

TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column

Posted on: July 8, 2008 5:35 pm

Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)

Posted on: June 8, 2008 5:12 pm

New script: How much of the database has changed since the last full backup?

Posted on: April 8, 2008 4:49 pm

Search Engine Q&A #17: Split a VLDB into filegroups or smaller databases for backups?

Posted on: March 13, 2008 5:41 pm

Search Engine Q&A #16: Concurrent log and full backups

Posted on: February 21, 2008 2:23 am

SQL Server 2008 JumpStart

Posted on: February 15, 2008 12:38 am

Search Engine Q&A #15: Mirrored backups

Posted on: February 5, 2008 5:39 pm

More on how much transaction log a full backup includes

Posted on: January 31, 2008 8:01 am

SQL Server 2008: Backup Compression CPU Cost

Posted on: January 9, 2008 10:26 am

Patents and parties

Posted on: December 23, 2007 5:27 am

Paul and Kimberly interview on RunAs Radio – What’s New in SQL Server 2008?

Posted on: December 12, 2007 6:07 pm

Fed up with BACKUP success messages bloating your error logs?

Posted on: October 30, 2007 7:26 pm

Debunking a couple of myths around full database backups

Posted on: October 25, 2007 9:42 pm

BACKUP WITH COPY_ONLY – how to avoid breaking the backup chain

Posted on: October 15, 2007 9:37 pm

SQL Server 2008: What’s been removed in this version? BACKUP LOG WITH NO_LOG for one!

Posted on: October 12, 2007 7:26 pm

BACKUP LOG WITH NO_LOG – use, abuse, and undocumented trace flags to stop it

Posted on: October 12, 2007 5:09 pm

Search Engine Q&A #7: Restoring from a backup file containing multiple database backups

Posted on: October 10, 2007 1:35 am

How does daylight savings time affect disaster recovery?

Posted on: October 6, 2007 5:49 pm

Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup

Posted on: October 6, 2007 1:00 am

Inside the Storage Engine: Anatomy of an extent

Posted on: October 3, 2007 10:13 pm

SQL Server 2008: Backup Compression

Posted on: September 20, 2007 6:38 pm

Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors

Posted on: September 4, 2007 8:31 pm