Microsoft SQL LocalServer/AutoEmail – Unable to perform differential backup: an external program has made a full backup of this database. Please run a full backup before attempting another differential backup.

Situation: The client replaced their SQL server with a new server and keep the same name and IP. They deleted the old server backup from the Barracuda and create the new backup. The backup gives this error:

Microsoft SQL

        LocalServer/AutoEmail – Unable to perform differential backup: an external program has made a full backup of this database. Please run a full backup before attempting another differential backup.

Troubleshooting: Since this is the new server replacing the old one. you need to do full backup at the first time.

Go to Backup>Schedules. Fine the server and click Edit. In SQL/Exchange Backup, switch the Smart to Full, After the backup success, switch the Full back to Smart.

Published by

Bob Lin

Bob Lin, Chicagotech-MVP, MCSE & CNE Data recovery, Windows OS Recovery, Networking, and Computer Troubleshooting on http://www.ChicagoTech.net How to Install and Configure Windows, VMware, Virtualization and Cisco on http://www.HowToNetworking.com

Leave a Reply