Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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: 10,932 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

Tags

Classifications

Public