August 12, 2013 at 8:38 am
Dear colleagues, need help!!!
Set up mirroring between two servers A - principial, B - mirror:
Created certificates, created endpoints for server instances using its certificate,
created logins at units, created at B RESTORE DATABASE and RESTORE LOG with the WITH NORECOVERY.
Run on the server B
ALTER DATABASE DBName
SET PARTNER = 'TCP://110.110.10.15:5024';
GO
That’s finished successfully.
Run on the server A
ALTER DATABASE DBName
SET PARTNER = 'TCP://110.110.10.16:5024';
GO
got the following error:
"Msg 5003, Level 16, State 1, Line 1
Database mirroring cannot be enabled while the database has offline files."
Done it many times, the result is the same.
Configuration: Windows Server 2003 SP2 at both servers, servers is not at domain.
Principial SQL Server 2008, mirror SQL Server 2008R2.
Returns are not planned. DB around 800Gb. Partitioned tables exists.
Just for testing created test database on the server A, and restored it on Server B and turn on mirroring.
It is well earned.
The basic database can’t be mirrored!
Please prompt me, what is the reason for this behavior?
Shortly before this, did this operation on the test servers with the same configuration,
mirroring worked without problems.
thanks.
August 15, 2013 at 10:56 am
Are any of the database files on Server A offline?
This query will show you the status of the database files.
select name,
state_desc
FROM sys.database_files
August 17, 2013 at 2:02 pm
all files of a database have the status online.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply