Backup cmd line using named instance

paulnxwebpaulnxweb Posts: 21
edited September 10, 2007 12:04PM in SQL Backup Previous Versions
We have been using Sql Backup V4.5.0.704 for over a year successfully in command line mode for SQL Server 2000.

We have upgraded to Microsoft SQL Server 2005.

When we execute the backup command we get "VID error 1000: Failed VDI error 1000: Failed to create virtual device"

The GUI backup works perfectly as we can specify the named instance of SQL Server 2005. However we can not get the command line to execute successfully. Attached is the output we see.

Besides executing in SQL Server 2005, we also are running under named
instance of 172.16.6.49\MSSQL2K5STD (previously under SQL 2000 we were running on the default instance).

What's going on? Do we need to specify the named instance? If so how?

Thanks
Paul

**************************Fails for he command line*******
"C:\Program Files\Red Gate\SQL Backup\MSSQL2K5STD\SQLBackupC.exe" -SQL "BACKUP DATABASE Assesspoint TO DISK = 'C:\SqlServerData\RedGateData\BackupDump\DATABASE__Assesspoint_200709101449.sqb' WITH NAME='<AUTO>', DESCRIPTION = '<AUTO>', MAILTO_ONERROR='errors@somewhere.com',PASSWORD='password',KEYSIZE = 128, COMPRESSION = 3, THREADS=8, THREADPRIORITY=2"


Backing up Assesspoint (full database) to:
C:\SqlServerData\RedGateData\BackupDump\DATABASE__Assesspoint_200709101449_01.
sqb
C:\SqlServerData\RedGateData\BackupDump\DATABASE__Assesspoint_200709101449_02.
sqb
C:\SqlServerData\RedGateData\BackupDump\DATABASE__Assesspoint_200709101449_03.
sqb
C:\SqlServerData\RedGateData\BackupDump\DATABASE__Assesspoint_200709101449_04.
sqb
C:\SqlServerData\RedGateData\BackupDump\DATABASE__Assesspoint_200709101449_05.
sqb
C:\SqlServerData\RedGateData\BackupDump\DATABASE__Assesspoint_200709101449_06.
sqb
C:\SqlServerData\RedGateData\BackupDump\DATABASE__Assesspoint_200709101449_07.
sqb
C:\SqlServerData\RedGateData\BackupDump\DATABASE__Assesspoint_200709101449_08.
sqb

VDI error 1000: Failed to create virtual device. Check that the SQL Server instance you are trying to connect to is running. Error code: (-2139684857: Failed to recognize the SQL Server instance name.)



************Works using the GUI see below for log entry**********
SQL Backup log file
9/10/2007 9:52:06 AM: Backing up Assesspoint (transaction log) on MSSQL2K5STD instance to:
C:\SqlServerData\RedGateData\BackupDump\LOG_MSSQL2K5STD_Assesspoint_20070910_095137.sqb

9/10/2007 9:52:06 AM: BACKUP LOG [Assesspoint] TO DISK = 'C:\SqlServerData\RedGateData\BackupDump\LOG_MSSQL2K5STD_Assesspoint_20070910_095137.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 3

9/10/2007 9:54:18 AM: Backup data size : 3.464 GB
9/10/2007 9:54:18 AM: Compressed data size: 796.278 MB
9/10/2007 9:54:18 AM: Compression rate : 77.55%

Processed 450710 pages for database 'Assesspoint', file 'assesspoint_Log' on file 1.
BACKUP LOG successfully processed 450710 pages in 131.006 seconds (28.183 MB/sec).
9/10/2007 9:54:21 AM: SQL Backup process ended.

Comments

  • Nevermind. I found "-I" command for specifying the instance for SQLBACKUPC.exe

    The way the Redgate manual was written made me focus on the "-SQL" parameter section. The answers is part of SQLBACKUPC.exe windows command line parameter.

    So below works.

    "C:\Program Files\Red Gate\SQL Backup\MSSQL2K5STD\SQLBackupC.exe" -I MSSQL2K5STD -SQL ".......switches"
Sign In or Register to comment.