Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
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)
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: