mirroring: two instances, one machine

  • hello all,

    i'm trying to set up mirroring between two databases that are installed on two different instances of sql server on the same machine. i get an error saying that the database on the named instance needs to be restored from a backup file, but when i try to do so, i get an error messages saying 'the backup set holds a backup of a database other than the existing database.'

    i read that one problem is that i'm trying to restore to a new database that was created at a different time than the original but has the same name. i tried to change the name of the new database in my RESTORE statement, but then i get this error: 'the file is in use by another process.' but i dont know which process (i've tried using microsoft process explorer and it doesn't even list the backup file from which i'm trying to restore onto the named instance).

    another possible solution that i read regarding the first error message above is to RESTORE WITH REPLACE but when i try to restore the log backup, i get an error saying 'the log or differential backup cannot be restored because no files are ready to roll forward'.

    any tips?

    thanks in advance.

  • Can I ask why you would do this?

    CEWII

  • t-jonat (8/19/2009)


    another possible solution that i read regarding the first error message above is to RESTORE WITH REPLACE but when i try to restore the log backup, i get an error saying 'the log or differential backup cannot be restored because no files are ready to roll forward'.

    RESTORE ... WITH REPLACE, NORECOVERY

    Anytime you want to apply more backups (diff or log), you need to use NoRecovery. Make sure you're also using the MOVE option so that you're not trying to overwrite files belonging to the DB on the other instance.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • WITH REPLACE, NORECOVERY and MOVE didn't work either, although I don't remember the exact error message and im not on that machine right now.

    im doing this not for the sake of the data as much as to play around with sql server.

  • t-jonat (8/25/2009)


    WITH REPLACE, NORECOVERY and MOVE didn't work either, although I don't remember the exact error message and im not on that machine right now.

    To offer any useful help, I'll need the command that you ran and the error message it gave.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • t-jonat (8/19/2009)


    hello all,

    i'm trying to set up mirroring between two databases that are installed on two different instances of sql server on the same machine.

    Hi,

    Quick question about setting up the mirroring - I'm trying to do the same, but seem to be getting the following error message:

    The server network address "TCP://FPTSQL02.forthports.net:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

    Did you get an similiar issue and did you have to change the port numbers?

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply