Tuesday, September 23, 2014

DB Restore Error: Restore failed for server 'ServerName'. (Microsoft.SqlServer.SmoExtended):

I created a testing environment(test1_MSAX) for one of my Live-Organisation through Import Organization in the deployment Manager. For some further RnD purpose, I wanted to create yet another test organization (test2_MSAX) for the same Live-Organization on the Same server where I already had previous test1_MSAX.
Error:
 
Solution:
  • Click on Options.
  • At right side, Under ‘Restore the database file as:‘ section. The first column represent the original file names of file type .mdf and .ldf and right most column represents the file name which you want to provide and restore the DB file as.


  • Click on the browse button and scroll all the way to see the file name and change it to your preferred name(test2_MSAX.mdf and test2_MSAX.ldf).
     
    After changing the restore database file name as, my DB restore succeeded.

     

    No comments:

    Post a Comment

    update_recordset with joins

     update_recordset with joins update_recordSet storeTransfer         setting      TransactionId = transfertable.TransferId     join transfert...