Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up 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: 1,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