Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Network Performance Monitor (NPM) > Database restore failed The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)

Database restore failed The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)

Created by Malik Haider, last modified by MindTouch on Jun 23, 2016

Views: 2,530 Votes: 0 Revisions: 6

Overview

You are trying to restore Orion DB backup to SQL server . 

When restoring a database in Microsoft SQL Server Management Studio, you receive the following dialog box similar to the following:

Restore failed for Server ‘myserver’. (Microsoft SqlServer.SmoExtended)

 

System.Data.SqlClient.SqlError: File ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mydatabase.mdf’ is claimed by ‘mydatabase_FG1′(3) and ‘mydatabase'(1).  The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)

 

Environment

  • All Orion Core versions

Resolution

 

Note: Resorting DB is out os SolarWinds scope of support. Please consult your DBA before making/following any changes within the DB as the provided steps are only for demo/test lab. 

 

On the Restore Database – mydatabase window inside of Microsoft SQL Server Management Studio:

  1. Click on the Options page.
  2. Underneath Restore the database files as: label, make sure all of the “Restore As” values are unique.  In this case, rename each *.mdf file to its “Original File Name” column value.

Before

 

After 

 

 

 

 

 

Last modified
22:05, 22 Jun 2016

Tags

Classifications

Public