What are the challenges you face when working across database platforms? Take the survey
Options

VDI error 1010 - repeatable

viacoboniviacoboni Posts: 13
edited September 28, 2005 10:03AM in SQL Backup Previous Versions
I have been getting VDI error 1010: Failed to get configuration from server error messages every day on 2 of 8 databases that I backup sequentially. Turns out I had a default instance and a named instance, with mostly the exact same database names (one is development, one is QA) executing the backup job at exactly the same time on the same box.

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.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Are you using the -I parameter for the backup on the named instance?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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.
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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.
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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.
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    No. I have now the two backup jobs an hour apart (each jobs backs up multiple databases), and there are no errors being reported.
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.