Use of extended stored procedure with named instance

rdameron · June 15, 2005 2:57PM

master..sqlbackup '-SQL "BACKUP DATABASE pubs TO DISK = ''Z:\sqlrec\pubs.sqb'' " '

Executing the above command on a named instance gives the following error:

Output from SQL Backup (3.2.0)

SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
Serial number: 010-050-022804-A8DE
Backing up pubs (full database) to Z:\sqlrec\pubs.sqb ...
VDI error 1000: Failed to create virtual device. Check that the SQL Server instance you are trying to connect to is running. E

(4 row(s) affected)

The VDI.LOG hasn't been modified since 5/27/2005 but I'll post the contents anyway.

2005/05/20 23:37:21 pid(1792) tid(10232)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/20 23:37:21 pid(11092) tid(9928)
Error on Global\CvSQL_B5_HCMSEC
Error at CVD::GetCommand: AbortDetected

2005/05/20 23:37:21 pid(1792) tid(10232)
Error on Global\CvSQL_B5_HCMSEC
Error at SVDS::CloseDevice: Abort detected

2005/05/20 23:37:21 pid(11092) tid(9928)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/20 23:37:21 pid(1792) tid(10232)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/20 23:37:21 pid(1792) tid(6604)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/20 23:37:52 pid(11092) tid(11072)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/27 21:07:15 pid(1792) tid(9896)
Error on Global\CvSQL_B5_ESS
Error at TriggerAbort: invoked

2005/05/27 21:07:15 pid(13564) tid(14096)
Error on Global\CvSQL_B5_ESS
Error at CVD::GetCommand: AbortDetected

2005/05/27 21:07:15 pid(1792) tid(9896)
Error on Global\CvSQL_B5_ESS
Error at SVDS::CloseDevice: Abort detected

2005/05/27 21:07:15 pid(13564) tid(14096)
Error on Global\CvSQL_B5_ESS
Error at TriggerAbort: invoked

2005/05/27 21:07:15 pid(1792) tid(9896)
Error on Global\CvSQL_B5_ESS
Error at TriggerAbort: invoked

2005/05/27 21:07:15 pid(1792) tid(2840)
Error on Global\CvSQL_B5_ESS
Error at TriggerAbort: invoked

2005/05/27 21:07:35 pid(1792) tid(6008)
Error on Global\CvSQL_B5_DBAObjCopy
Error at TriggerAbort: invoked

2005/05/27 21:07:35 pid(12920) tid(12072)
Error on Global\CvSQL_B5_DBAObjCopy
Error at CVD::GetCommand: AbortDetected

2005/05/27 21:07:35 pid(1792) tid(6008)
Error on Global\CvSQL_B5_DBAObjCopy
Error at SVDS::CloseDevice: Abort detected

2005/05/27 21:07:35 pid(12920) tid(12072)
Error on Global\CvSQL_B5_DBAObjCopy
Error at TriggerAbort: invoked

2005/05/27 21:07:35 pid(1792) tid(6008)
Error on Global\CvSQL_B5_DBAObjCopy
Error at TriggerAbort: invoked

2005/05/27 21:07:35 pid(1792) tid(2856)
Error on Global\CvSQL_B5_DBAObjCopy
Error at TriggerAbort: invoked

2005/05/27 21:07:45 pid(13564) tid(13344)
Error on Global\CvSQL_B5_ESS
Error at TriggerAbort: invoked

2005/05/27 21:08:05 pid(12920) tid(14180)
Error on Global\CvSQL_B5_DBAObjCopy
Error at TriggerAbort: invoked

2005/05/27 21:23:39 pid(1792) tid(7684)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/27 21:23:39 pid(13556) tid(12464)
Error on Global\CvSQL_B5_HCMSEC
Error at CVD::GetCommand: AbortDetected

2005/05/27 21:23:39 pid(1792) tid(7684)
Error on Global\CvSQL_B5_HCMSEC
Error at SVDS::CloseDevice: Abort detected

2005/05/27 21:23:39 pid(13556) tid(12464)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/27 21:23:39 pid(1792) tid(7684)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/27 21:23:39 pid(1792) tid(7264)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/27 21:24:00 pid(1792) tid(6500)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

2005/05/27 21:24:00 pid(12976) tid(13124)
Error on Global\CvSQL_B5_extensity
Error at CVD::GetCommand: AbortDetected

2005/05/27 21:24:00 pid(1792) tid(6500)
Error on Global\CvSQL_B5_extensity
Error at SVDS::CloseDevice: Abort detected

2005/05/27 21:24:00 pid(12976) tid(13124)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

2005/05/27 21:24:00 pid(1792) tid(6500)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

2005/05/27 21:24:00 pid(1792) tid(10760)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

2005/05/27 21:24:09 pid(13556) tid(13328)
Error on Global\CvSQL_B5_HCMSEC
Error at TriggerAbort: invoked

2005/05/27 21:24:30 pid(12976) tid(13496)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

2005/05/27 21:49:56 pid(1792) tid(6008)
Error on Global\CvSQL_B5_extensityold
Error at TriggerAbort: invoked

2005/05/27 21:49:56 pid(12572) tid(12492)
Error on Global\CvSQL_B5_extensityold
Error at CVD::GetCommand: AbortDetected

2005/05/27 21:49:56 pid(1792) tid(6008)
Error on Global\CvSQL_B5_extensityold
Error at SVDS::CloseDevice: Abort detected

2005/05/27 21:49:56 pid(12572) tid(12492)
Error on Global\CvSQL_B5_extensityold
Error at TriggerAbort: invoked

2005/05/27 21:49:56 pid(1792) tid(6008)
Error on Global\CvSQL_B5_extensityold
Error at TriggerAbort: invoked

2005/05/27 21:49:56 pid(1792) tid(7916)
Error on Global\CvSQL_B5_extensityold
Error at TriggerAbort: invoked

2005/05/27 21:50:26 pid(12572) tid(10436)
Error on Global\CvSQL_B5_extensityold
Error at TriggerAbort: invoked

2005/05/27 21:58:32 pid(1792) tid(6008)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

2005/05/27 21:58:32 pid(13972) tid(12400)
Error on Global\CvSQL_B5_extensity
Error at CVD::GetCommand: AbortDetected

2005/05/27 21:58:32 pid(1792) tid(6008)
Error on Global\CvSQL_B5_extensity
Error at SVDS::CloseDevice: Abort detected

2005/05/27 21:58:32 pid(13972) tid(12400)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

2005/05/27 21:58:32 pid(1792) tid(6008)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

2005/05/27 21:58:32 pid(1792) tid(7916)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

2005/05/27 21:59:02 pid(13972) tid(10444)
Error on Global\CvSQL_B5_extensity
Error at TriggerAbort: invoked

I also tried
master..sqlbackup '-SQL "BACKUP DATABASE pubs TO DISK = ''\\camelxa\z$\sqlrec\pubs.sqb'' " '

Similar error...

Output from SQL Backup (3.2.0)

SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
Serial number: 010-050-022804-A8DE
Backing up pubs (full database) to \\camelxa\z$\sqlrec\pubs.sqb ...
VDI error 1000: Failed to create virtual device. Check that the SQL Server instance you are trying to connect to is running. E

(4 row(s) affected)

Another one of our DBAs has used the command line version works.

We've just installed SQL Backup 3.2 this week.

I don't see much in the forums regarding usage on named instances.

Thanks.

petey · June 16, 2005 6:37AM

Use the same parameters as you would for the command line i.e. use the -I parameter to specify an instance name e.g.

master..sqlbackup '-sql "BACKUP DATABASE pubs TO DISK = [Z:\sqlrec\pubs.sqb]" -I INSTANCE2'

rdameron · June 16, 2005 9:25AM

The -I parameter did the trick!

Thanks.

petey · June 16, 2005 10:54AM

Usage of the -I parameter from within the extended stored procedure is not really intuitive, and will not be necessary in future versions.

Use of extended stored procedure with named instance

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk