May 24, 2012 at 1:09 am
Hi all,
Now there is one problem about CN Principal DB and US Mirror DB.The status of principal is Principal/Disconneted and the mirror database(having no status) seems like read-write(but I cannot access the database ,the error message is: database is not accessible) .
When I run the following sql
select state_desc from sys.databases where name='dbname',it showes that the query result is :"Recovery_Pending".
BTW,there are other databases mirrored between the two instances, and they ran normally.
Then check the database error log on the mirror instance:
Unable to open the physical file "D:\DATA\Tfs_TFS2005Collection\LOG\TfsVersionControl.LDF". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
A file activation error occurred. The physical file name 'D:\DATA\Tfs_TFS2005Collection\LOG\TfsVersionControl.LDF' may be incorrect. Diagnose and correct additional errors, and retry the operation.
We have tried the below methods to fix the error one by one,but they could not work.
1:alter database dbname set partner resume----on the principal
2:alter endpoint endponitname state=stopped -----on principal and mirror
alter endpoint endponitname state=started
3:ALTER DATABASE dbname SET PARTNER='TCP://Principal:5022'----on mirror
When executing the third sql statement, there was one error came out.
Msg 945, Level 14, State 2, Line 1
Database 'Tfs_TFS2005Collection' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Appreciate your help,
Thanks in advance.
May 24, 2012 at 1:44 am
Later we used the ProcessExplorer to check which program occupy the database files. and there is no any result.
Then we decided to reboot the mirror server.
After the server is back,we found that the mirror returned normal......
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply