Comments
9 comments
-
Are you using the -I parameter for the backup on the named instance?
-
Yes. Like I mentioned, most of the backups on both sides work fine. Further proof that these are copies of the same databases is that the size of the backup files differs on the named instance side vs. the default instance side.
-
You mentioned that the backups on the named instance succeeds while the one for the default instance fails, for the 2 large databases.
What is the timing of the backups, for these 2 databases on both instances i.e. does backup for database A on named instance starts first, then backup for database A on default instance starts next etc?
Thanks. -
As I said initially, both jobs start at exactly the same time. Since there are a few more databases in development (default instance) than QA, QA reaches the databases that fail first. So the error happens in the default instance which got to the databases while the backup on the named instance was in progress.
-
Could you pls check the vdi.log file in the SQL Server log folder, and see if any errors were recorded at the time of the backup failure on the 2 large databases? Thanks.
-
Here is the entire VDI.LOG file from the default instance. The backups are at 2 AM so that is where you will see the errors. I suspect those Status Code 2 errors.
2005/09/04 02:00:08 pid(2084) tid(4492)
Error on Global\SQLBACKUP_210230381
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/06 11:02:39 pid(4752) tid(3700)
Error on Global\SQLBACKUP_7567773
Error at CVDS::Close: Abnormal termination state
2005/09/06 11:02:39 pid(4752) tid(3700)
Error on Global\SQLBACKUP_7567773
Error at TriggerAbort: invoked
2005/09/11 02:00:08 pid(4916) tid(5612)
Error on Global\SQLBACKUP_48553885
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/14 10:00:50 pid(4664) tid(5468)
Error on Global\SQLBACKUP_9447037
Error at CVDS::Close: Abnormal termination state
2005/09/14 10:00:50 pid(4664) tid(5468)
Error on Global\SQLBACKUP_9447037
Error at TriggerAbort: invoked
2005/09/14 10:03:21 pid(1800) tid(420)
Error on Global\SQLBACKUP_9447037
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/14 10:26:37 pid(4812) tid(5688)
Error on Global\SQLBACKUP_177411613
Error at CVDS::Close: Abnormal termination state
2005/09/14 10:26:37 pid(4812) tid(5688)
Error on Global\SQLBACKUP_177411613
Error at TriggerAbort: invoked
2005/09/14 12:00:04 pid(672) tid(1956)
Error on Global\SQLBACKUP_9787245
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/14 12:00:08 pid(4916) tid(5876)
Error on Global\SQLBACKUP_9803629
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/14 12:00:17 pid(1676) tid(4252)
Error on Global\SQLBACKUP_9615213
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/14 14:00:08 pid(4000) tid(4292)
Error on Global\SQLBACKUP_48750221
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/14 16:00:23 pid(5604) tid(4900)
Error on Global\SQLBACKUP_48303757
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/14 16:00:43 pid(6116) tid(4620)
Error on Global\SQLBACKUP_48365197
Error at CVDS::Close: Abnormal termination state
2005/09/14 16:00:43 pid(6116) tid(4620)
Error on Global\SQLBACKUP_48365197
Error at TriggerAbort: invoked
2005/09/14 16:03:39 pid(1800) tid(4892)
Error on Global\SQLBACKUP_48365197
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/15 02:00:02 pid(5260) tid(4204)
Error on Global\SQLBACKUP_48775069
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/15 02:00:33 pid(2252) tid(5152)
Error on Global\SQLBACKUP_49274781
Error at CVDS::Close: Abnormal termination state
2005/09/15 02:00:33 pid(2252) tid(5152)
Error on Global\SQLBACKUP_49274781
Error at TriggerAbort: invoked
2005/09/15 02:01:23 pid(1800) tid(3872)
Error on Global\SQLBACKUP_49274781
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/15 02:01:57 pid(1384) tid(752)
Error on Global\SQLBACKUP_99368861
Error at CVDS::Close: Abnormal termination state
2005/09/15 02:01:57 pid(1384) tid(752)
Error on Global\SQLBACKUP_99368861
Error at TriggerAbort: invoked
2005/09/15 02:03:29 pid(1800) tid(5352)
Error on Global\SQLBACKUP_99368861
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/15 10:00:06 pid(248) tid(5160)
Error on Global\SQLBACKUP_6674045
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/15 12:00:19 pid(3808) tid(680)
Error on Global\SQLBACKUP_6457197
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/15 12:00:23 pid(904) tid(592)
Error on Global\SQLBACKUP_6514541
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/15 14:00:07 pid(1892) tid(5052)
Error on Global\SQLBACKUP_48819853
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/15 16:00:08 pid(960) tid(5600)
Error on Global\SQLBACKUP_48823949
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/15 16:00:52 pid(2164) tid(2444)
Error on Global\SQLBACKUP_49139341
Error at CVDS::Close: Abnormal termination state
2005/09/15 16:00:52 pid(2164) tid(2444)
Error on Global\SQLBACKUP_49139341
Error at TriggerAbort: invoked
2005/09/15 16:02:00 pid(1800) tid(556)
Error on Global\SQLBACKUP_49139341
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/16 02:00:02 pid(4640) tid(4556)
Error on Global\SQLBACKUP_48840605
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/16 02:00:06 pid(740) tid(4668)
Error on Global\SQLBACKUP_48889757
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/16 02:00:31 pid(2080) tid(3936)
Error on Global\SQLBACKUP_49217437
Error at CVDS::Close: Abnormal termination state
2005/09/16 02:00:31 pid(2080) tid(3936)
Error on Global\SQLBACKUP_49217437
Error at TriggerAbort: invoked
2005/09/16 02:01:25 pid(1800) tid(264)
Error on Global\SQLBACKUP_49217437
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/16 02:02:03 pid(220) tid(4652)
Error on Global\SQLBACKUP_99475357
Error at CVDS::Close: Abnormal termination state
2005/09/16 02:02:03 pid(220) tid(4652)
Error on Global\SQLBACKUP_99475357
Error at TriggerAbort: invoked
2005/09/16 02:05:01 pid(1800) tid(4184)
Error on Global\SQLBACKUP_99475357
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/16 10:00:03 pid(4848) tid(4652)
Error on Global\SQLBACKUP_7669373
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/16 12:00:28 pid(3904) tid(4880)
Error on Global\SQLBACKUP_7575405
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/16 14:00:15 pid(5296) tid(1672)
Error on Global\SQLBACKUP_49155725
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/16 16:00:03 pid(3916) tid(5772)
Error on Global\SQLBACKUP_48828045
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/16 16:00:08 pid(2092) tid(4520)
Error on Global\SQLBACKUP_48889485
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/17 02:00:37 pid(216) tid(296)
Error on Global\SQLBACKUP_49037213
Error at CVDS::Close: Abnormal termination state
2005/09/17 02:00:37 pid(216) tid(296)
Error on Global\SQLBACKUP_49037213
Error at TriggerAbort: invoked
2005/09/17 02:01:30 pid(1800) tid(4208)
Error on Global\SQLBACKUP_49037213
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/17 02:02:04 pid(4372) tid(2460)
Error on Global\SQLBACKUP_99536797
Error at CVDS::Close: Abnormal termination state
2005/09/17 02:02:04 pid(4372) tid(2460)
Error on Global\SQLBACKUP_99536797
Error at TriggerAbort: invoked
2005/09/17 02:05:06 pid(1800) tid(1772)
Error on Global\SQLBACKUP_99536797
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/17 10:00:04 pid(3700) tid(1080)
Error on Global\SQLBACKUP_4535933
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/17 10:00:17 pid(1312) tid(4768)
Error on Global\SQLBACKUP_4376189
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/17 14:00:21 pid(4732) tid(5688)
Error on Global\SQLBACKUP_49041037
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/18 02:00:03 pid(4332) tid(3860)
Error on Global\SQLBACKUP_48967581
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/18 02:00:12 pid(3476) tid(1976)
Error on Global\SQLBACKUP_49037213
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/18 02:00:44 pid(904) tid(5800)
Error on Global\SQLBACKUP_49139613
Error at CVDS::Close: Abnormal termination state
2005/09/18 02:00:44 pid(904) tid(5800)
Error on Global\SQLBACKUP_49139613
Error at TriggerAbort: invoked
2005/09/18 02:01:32 pid(1800) tid(5676)
Error on Global\SQLBACKUP_49139613
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/18 02:02:06 pid(4548) tid(220)
Error on Global\SQLBACKUP_98586525
Error at CVDS::Close: Abnormal termination state
2005/09/18 02:02:06 pid(4548) tid(220)
Error on Global\SQLBACKUP_98586525
Error at TriggerAbort: invoked
2005/09/18 02:05:10 pid(1800) tid(4208)
Error on Global\SQLBACKUP_98586525
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/19 02:00:36 pid(1504) tid(5740)
Error on Global\SQLBACKUP_48910237
Error at CVDS::Close: Abnormal termination state
2005/09/19 02:00:36 pid(1504) tid(5740)
Error on Global\SQLBACKUP_48910237
Error at TriggerAbort: invoked
2005/09/19 02:01:28 pid(1800) tid(5060)
Error on Global\SQLBACKUP_48910237
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/19 02:02:02 pid(4328) tid(4724)
Error on Global\SQLBACKUP_99151773
Error at CVDS::Close: Abnormal termination state
2005/09/19 02:02:02 pid(4328) tid(4724)
Error on Global\SQLBACKUP_99151773
Error at TriggerAbort: invoked
2005/09/19 02:05:01 pid(1800) tid(1772)
Error on Global\SQLBACKUP_99151773
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/19 10:00:04 pid(4728) tid(4496)
Error on Global\SQLBACKUP_2438781
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/19 16:00:04 pid(3724) tid(5012)
Error on Global\SQLBACKUP_49036941
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/19 16:00:28 pid(5532) tid(1692)
Error on Global\SQLBACKUP_48955021
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/20 02:00:37 pid(5156) tid(1076)
Error on Global\SQLBACKUP_49627037
Error at CVDS::Close: Abnormal termination state
2005/09/20 02:00:37 pid(5156) tid(1076)
Error on Global\SQLBACKUP_49627037
Error at TriggerAbort: invoked
2005/09/20 02:01:29 pid(1800) tid(5060)
Error on Global\SQLBACKUP_49627037
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/20 02:02:03 pid(348) tid(2444)
Error on Global\SQLBACKUP_100130717
Error at CVDS::Close: Abnormal termination state
2005/09/20 02:02:03 pid(348) tid(2444)
Error on Global\SQLBACKUP_100130717
Error at TriggerAbort: invoked
2005/09/20 02:05:03 pid(1800) tid(5060)
Error on Global\SQLBACKUP_100130717
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/20 10:00:10 pid(344) tid(152)
Error on Global\SQLBACKUP_30570109
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/20 12:00:03 pid(4968) tid(4500)
Error on Global\SQLBACKUP_30762861
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/20 14:00:19 pid(3536) tid(4612)
Error on Global\SQLBACKUP_49602189
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/21 02:00:36 pid(4320) tid(4144)
Error on Global\SQLBACKUP_49434525
Error at CVDS::Close: Abnormal termination state
2005/09/21 02:00:36 pid(4320) tid(4144)
Error on Global\SQLBACKUP_49434525
Error at TriggerAbort: invoked
2005/09/21 02:01:30 pid(1800) tid(3872)
Error on Global\SQLBACKUP_49434525
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/21 02:02:04 pid(5180) tid(4364)
Error on Global\SQLBACKUP_99667869
Error at CVDS::Close: Abnormal termination state
2005/09/21 02:02:04 pid(5180) tid(4364)
Error on Global\SQLBACKUP_99667869
Error at TriggerAbort: invoked
2005/09/21 02:05:03 pid(1800) tid(3872)
Error on Global\SQLBACKUP_99667869
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/21 10:00:02 pid(3812) tid(2440)
Error on Global\SQLBACKUP_27596413
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/21 12:00:02 pid(5612) tid(4860)
Error on Global\SQLBACKUP_27621229
Error at CVDS::Create: Create Memory Status Code: 5, x5
Explanation: Access is denied.
2005/09/21 16:36:17 pid(2444) tid(5024)
Error on Global\SQLBACKUP_150216413
Error at CVDS::Close: Abnormal termination state
2005/09/21 16:36:17 pid(2444) tid(5024)
Error on Global\SQLBACKUP_150216413
Error at TriggerAbort: invoked
2005/09/22 02:01:09 pid(3904) tid(5036)
Error on Global\SQLBACKUP_50208669
Error at CVDS::Close: Abnormal termination state
2005/09/22 02:01:09 pid(3904) tid(5036)
Error on Global\SQLBACKUP_50208669
Error at TriggerAbort: invoked
2005/09/22 02:01:45 pid(1800) tid(1500)
Error on Global\SQLBACKUP_50208669
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/22 02:02:18 pid(4472) tid(884)
Error on Global\SQLBACKUP_83177373
Error at CVDS::Close: Abnormal termination state
2005/09/22 02:02:18 pid(4472) tid(884)
Error on Global\SQLBACKUP_83177373
Error at TriggerAbort: invoked
2005/09/22 02:05:24 pid(1800) tid(1500)
Error on Global\SQLBACKUP_83177373
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/22 10:43:29 pid(5284) tid(2364)
Error on Global\SQLBACKUP_{C8570AF3-DAB5-4220-83FD-68FD7AB64188}
Error at CVDS::Close: Abnormal termination state
2005/09/22 10:43:29 pid(5284) tid(2364)
Error on Global\SQLBACKUP_{C8570AF3-DAB5-4220-83FD-68FD7AB64188}
Error at TriggerAbort: invoked
2005/09/22 10:44:24 pid(784) tid(5656)
Error on Global\SQLBACKUP_{C8570AF3-DAB5-4220-83FD-68FD7AB64188}
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/22 10:44:59 pid(5132) tid(1992)
Error on Global\SQLBACKUP_{331C262A-7F54-4D46-B3DF-7E840714AECC}
Error at CVDS::Close: Abnormal termination state
2005/09/22 10:44:59 pid(5132) tid(1992)
Error on Global\SQLBACKUP_{331C262A-7F54-4D46-B3DF-7E840714AECC}
Error at TriggerAbort: invoked
2005/09/22 10:48:59 pid(4844) tid(2024)
Error on Global\SQLBACKUP_{BA3D999E-3DEA-4E8E-B892-3AA948D0FAB5}
Error at CVDS::Close: Abnormal termination state
2005/09/22 10:48:59 pid(4844) tid(2024)
Error on Global\SQLBACKUP_{BA3D999E-3DEA-4E8E-B892-3AA948D0FAB5}
Error at TriggerAbort: invoked
2005/09/22 10:49:27 pid(784) tid(5864)
Error on Global\SQLBACKUP_{331C262A-7F54-4D46-B3DF-7E840714AECC}
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/22 10:49:27 pid(784) tid(4800)
Error on Global\SQLBACKUP_{BA3D999E-3DEA-4E8E-B892-3AA948D0FAB5}
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/22 13:22:00 pid(5744) tid(5300)
Error on Global\SQLBACKUP_{32D2381E-FA06-4969-892B-74AC920BF0A9}
Error at CVDS::Close: Abnormal termination state
2005/09/22 13:22:00 pid(5744) tid(5300)
Error on Global\SQLBACKUP_{32D2381E-FA06-4969-892B-74AC920BF0A9}
Error at TriggerAbort: invoked
2005/09/22 13:22:38 pid(784) tid(5704)
Error on Global\SQLBACKUP_{32D2381E-FA06-4969-892B-74AC920BF0A9}
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/22 13:46:00 pid(4600) tid(5592)
Error on Global\SQLBACKUP_{548654FC-286E-4E34-9BA8-868B92193DAC}
Error at CVDS::Close: Abnormal termination state
2005/09/22 13:46:00 pid(4600) tid(5592)
Error on Global\SQLBACKUP_{548654FC-286E-4E34-9BA8-868B92193DAC}
Error at TriggerAbort: invoked
2005/09/22 13:46:38 pid(784) tid(5704)
Error on Global\SQLBACKUP_{548654FC-286E-4E34-9BA8-868B92193DAC}
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.
2005/09/22 13:47:12 pid(5524) tid(652)
Error on Global\SQLBACKUP_{1044DB74-B5CB-4A73-9C98-A7040AB43E84}
Error at CVDS::Close: Abnormal termination state
2005/09/22 13:47:12 pid(5524) tid(652)
Error on Global\SQLBACKUP_{1044DB74-B5CB-4A73-9C98-A7040AB43E84}
Error at TriggerAbort: invoked
2005/09/22 13:50:12 pid(784) tid(5864)
Error on Global\SQLBACKUP_{1044DB74-B5CB-4A73-9C98-A7040AB43E84}
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified. -
Do you encounter the error if you manually backup the large database on the named instance using the extended stored procedure (in Query Analyzer), wait a while, then backup the large database on the default instance, again using the extended stored procedure?
Thanks. -
No. I have now the two backup jobs an hour apart (each jobs backs up multiple databases), and there are no errors being reported.
-
I meant if you could reproduce the problem manually by backing up on one instance, then while the backup runs, start another manual backup on the other instance, for the database of the same name. Then try with a database of a different name.
Thanks.
Add comment
Please sign in to leave a comment.
Only the two largest databases produce the error. They do so only on the default instance, not the named instance. The rest of the backups are OK in both instances.
I upgraded to the FTP patch 3.2.0.5 and still get the error.
I've changed the time of the backup, but I'd like to see this working.
Also, please document that the extented proc interface gives a zero on success and a one on failure.