Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jtb1234
Starting Member
1 Post |
 Posted - 2009-08-17 : 07:26:15
|
| 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. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-17 : 11:09:36
|
| are you using WITH MOVE in your restore statement? |
 |
|
|
|
|
|
mirroring: two instances of SqlServer, one machine