1 Reply Latest reply on Jun 17, 2015 9:09 AM by tehjolly81

    NPM 11.5.2 - Error when trying to migrate from SQL Server 2008R2 Express Advanced to SQL Server 2014 Express Advanced

    tehjolly81

      Hello,

       

      I am trying to migrate my NPM 11.5.2/NCM 7.4 install to a new Win2012R2 server. After installing SQL Server 2014 Express w/ Advanced Services, I backed up my NetPerfMon and ConfigMgmt databases on the old server (using SQL server management studio), transferred them to the new server, and tried to restore them. When restoring the NPM database, I get the following error. Any ideas? Thanks.

       

      TITLE: Microsoft SQL Server Management Studio

      ------------------------------

       

       

      Restore of database 'NetPerfMon' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

       

       

      ------------------------------

      ADDITIONAL INFORMATION:

       

       

      System.Data.SqlClient.SqlError: Logical file 'ConfigMgmt' is not part of database 'NetPerfMon'. Use RESTORE FILELISTONLY to list the logical file names. (Microsoft.SqlServer.SmoExtended)

       

       

      For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&LinkId=20476

       

       

      ------------------------------

      BUTTONS:

       

       

      OK

      ------------------------------