- Knowledge Base
- Troubleshoot
- Database
-
Getting Help
-
12.3 Specific changes
-
Installation
-
Learn
- Business Activities
- Business Activity Manager
- Business Alerts
- Configuration
- Customer
- Database
- EDI
- General
- Inventory
- Manager Windows
- Mobile
- Picklists (Advanced Picking)
- Product
- Purchasing
- Purchase Order Manager
- QuickBooks & Acctivate Basics
- QuickBooks Desktop Sync
- QuickBooks Online Sync
- Reporting
- Sales
- Sales Order Manager
- Sales Tax
- Server
- Shipping
- Startup
- User Interface
- Webstore
-
Troubleshoot
-
Specs
-
FAQs
Resolving error 'Restore failed for Server 'servername\instancename'.
Restoring a backup of a database to a new database may return an error message in newer versions of SQL Server.
Users may receive the following message when restoring a database backup to a different database in Acctivate Database Maintenance.
Restore failed for Server {servername\instance}. --> To accomplish this action, set property Database.
This message is typically returned when the backup file contains a backup set for a different database. Restoring a copy of your live data to your MODEL company, for instance, could cause the error to be returned.
The simple workaround is to use SQL Server Management Studio to restore a backup to a different database. Take a look at this guide on accomplishing this task.