Hello,
I have been trying to set up my Control-M 6.4 mirroring for a while, and whenever I can do it , I keep receiving the same error almost half a day after enabling the Mirroring:
I got this error from proclog:
1026 00:23:28.18 Primary: Provider Error number: 80004005 Timeout expired
1026 00:23:28.18 COM Error Code = 80004005 ;Code meaning = Unspecified error ;Source = Microsoft OLE DB Provider for SQL Server ;Description = Timeout expired
1026 00:23:28.18 DB_GetDBproc(StructProc=00604FB4) - Failed in (MIRROR)
1026 00:23:28.18 CTM6001 -> DB_GL_mirrordb_mark_nouse: ERROR occured. marking mirror db as unused!!
I am using 2 servers in LAN, Windows 2003 OS with Microsoft SQL Server 2005 Installed.
I also keep getting this type of errors:
0722 18:28:02.57 Failed to open file :'.\TEMP\dbcheck_logspace.out'
1004 15:12:02.57 Failed to open file :'.\TEMP\dbcheck_logspace.out'
0113 19:55:02.56 Failed to open file :'.\TEMP\dbcheck_logspace.out'
1026 11:29:01.81 Failed to open file :'.\TEMP\dbcheck_logspace.out'
Only as a comment, when I perform the mirror between the 2 databases it takes almost 2 hours for the mirror to complete.
I hope you can help me solve this problem or having my database mirroring setup...
2 days after I could enable mirroring, I got this error:
1031 00:41:21.84 Primary: Provider Error number: 80004005 Timeout expired
1031 00:41:21.84 COM Error Code = 80004005 ;Code meaning = Unspecified error ;Source = Microsoft OLE DB Provider for SQL Server ;Description = Timeout expired
1031 00:41:21.84 DB_GetDBproc(StructProc=00604FB4) - Failed in (MIRROR)
1031 00:41:21.85 CTM6001 -> DB_GL_mirrordb_mark_nouse: ERROR occured. marking mirror db as unused!!
I am using Windows 2003 R2 and Microsoft SQL Server 2005.
Thanks.
Problem with mirroring in Control-M Server 6.4
- rich_arredondo
- Nouveau
- Posts: 16
- Joined: 04 Nov 2011 12:00
- rich_arredondo
- Nouveau
- Posts: 16
- Joined: 04 Nov 2011 12:00
Both servers on same LAN
They are on the same LAN, the response time betweeen them is less than 1 milisecond, that is because the error sounds really strange to me also.
Both servers are in the same Datacenter.
Both servers are in the same Datacenter.
I installed CTM in a site earlier this year. It took hours for installation process to build the schema. It turned out that the problem was configuration of SQL server. When just hostname was specified, it took hours to build schema. When hostname and instance was specified, installation completed in minutes.
Your problem sounds similar. Check with your DBA about instance in the SQL server.
Your problem sounds similar. Check with your DBA about instance in the SQL server.
- rich_arredondo
- Nouveau
- Posts: 16
- Joined: 04 Nov 2011 12:00
Standalone
What about if I have a standalone installation?
Does that apply for that case?
Thanks for your support.
Does that apply for that case?
Thanks for your support.