Tag Archives : differential backup

---

SQL Server A to Z – Backups

This entry was posted in Features General Maintenance and tagged a to z backups DCM differential backup on July 11, 2011 by Colleen M. Morrow

One of the most important, if not the most important tasks of the DBA is backing up your database.  The database backup is the most basic disaster recovery plan you can have in place.  It’s certainly the easiest to implement.  Today I’m going to go over the basics of backups, including the different types of […]

---

Error: “The file … cannot be moved by this RESTORE operation.”

This entry was posted in Troubleshooting and tagged differential backup differential restore error on June 21, 2011 by Colleen M. Morrow

This morning, I was trying to restore a database from a SQL 2005 backup to a new server.  The restore involved a full backup and a differential.  I restored the full backup with NORECOVERY via SSMS, but when I tried to restore the differential, also via SSMS, I got this error: Okaaay.  I was a […]

---