Use of extended stored procedure with named instance

rdameron

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

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

The -I parameter did the trick!

Thanks.

petey

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