Scheduler Usage

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.

Hi,

Is the communication between the primary server and the secondary DB stable? Are they on the same LAN?

If it is not, then you have a problem... if the ping average response time from the two servers is more than 10~12ms, then it's not safe to use this feature.

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.

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.

What about if I have a standalone installation?

Does that apply for that case?


Thanks for your support.

Hi Ricardo, How did you solved this issue?
I'm having the same one and I have no idea whats happening here.