How can we help you today? How can we help you today?

VDI error 1000: Failed to create virtual device

Dears:

I found if I want to backup multiple databases at the same time, it will show "VDI error 1000: Failed to create virtual device".
Here is my sql command :
master..sqlbackup ' -SQL "BACKUP DATABASE [TSR_20050719] TO DISK = ''d:\sqlbackup\Full_(local)_TSR_20050719_200508291517.sqb'' WITH NAME = ''Database (TSR_20050719), 200508291517'', ERASEFILES = 2 " -U xxx -P xxx'

master..sqlbackup ' -SQL "RESTORE DATABASE [TSR_20050719] FROM DISK = ''\\clt-dha1\sqlbackup\Full_(local)_TSR_20050719_200508291517.sqb'' WITH STANDBY = ''c:\sqlbackup\UNDO_TSR_20050719_200508291517.DAT'', MOVE ''TSR_Data'' TO ''c:\program files\Microsoft SQL Server\MSSQL\data\TSR_20050719.mdf'', MOVE ''TSR_Log'' TO ''c:\program files\Microsoft SQL Server\MSSQL\data\TSR_20050719_log.ldf'' " -U xxx -P xxx'

But if I run sql one by one in TSQL, it works fine. I guess it wouldn't permission error. Could your program support concurrent backup ?

Regards,
Mago
mago
0

Comments

6 comments

Sort by
  • petey
    One command is to backup, while the other is to restore, both against the same database [TSR_20050719]. This can't be performed concurrently.
    petey
    0
  • mago
    petey wrote:
    One command is to backup, while the other is to restore, both against the same database [TSR_20050719]. This can't be performed concurrently.


    Dears:

    Sorry to make you confuse.

    I didn't mean to backup and to restore at the same time.
    I mean if I want to backup multiple database at the same time using extended stored procedure, it shows error message. I don't know if it support concurrent backup using command line(sqlbackup.exe) at the same time. But in my test, it doesn't work using extended stored procedure.
    (Please ignore restore sql, it's no matter with the problem. The other database backup sql is alike as the backup sql, but has different database name.)


    Regards,
    Mago
    mago
    0
  • mago
    Dears:

    I set "Sleep" after run the script. It won't appear the error message again. So it's okay now.
    Thanks a lot. :)
    ==========================================
    For Each DBName In DBList.Items
    Set WshShell = WScript.CreateObject("WScript.Shell")
    WshShell.Run "sync.wsf " & DBName, 2, 0
    WScript.Sleep 60
    Next
    ==========================================

    Regards,
    Mago
    mago
    0
  • mago
    It still didn't work if to backup two database or above at the same time.
    So it's the limit of sql backup ?
    mago
    0
  • petey
    There is a known issue with SQL Backup relating to making backups/restores concurrently or within a short space of time within each other. Contact support for a patch.
    petey
    0
  • mago
    Got it. Thanks for your reply. :-)
    mago
    0

Add comment

Please sign in to leave a comment.