Restore Database Into New Instance

• steelydtwang

  SSC Veteran

  Points: 226

  More actions

  June 21, 2010 at 11:34 am

  #225881

  Hi,

  I'm using SQL Server 2008 Express (and ESRI ArcSDE).

  I have a database that I'd like to use as a source to copy into a new 'test' database. I have a user database (an ArcSDE geodatabase) that I'd like to restore into a new instance.

  I created a new named instance (TEST_InstanceName) and tried to restore the user database into it, but I get the error '3154' (See Attachment).

  I'm restoring the original bak/log files into the TEST backup/log directories.

  I'm doing this through the SQLServer Management Studio dialogs.

  Please advise.

  Thank you.

• jjtetzlo

  SSCrazy

  Points: 2511

  More actions

  June 21, 2010 at 1:16 pm

  #1182948

  It sounds like you need to specify WITH REPLACE on your restore operation.

  See: http://msdn.microsoft.com/en-us/library/ms191315.aspx

  - Jeff