Command Line Utility on SQL 2005

michellem33

Hi,

I have been testing the command line tool to backup database on my SQLEXpress instance using SQLBackup. When running the following command:

SQLBackupC -E -SQL "BACKUP DATABASE master
TO DISK = 'c:\sqlBackups\master.sqb' WITH PASSWORD = 'test' "

I get the following:

Red Gate SQL Backup 4.0.0.113, (c) Red Gate Software Ltd 2004 - 2006
Trial - 10 days remaining

Backing up master (full database) to:
c:\sqlBackups\master.sqb

Login timeout expired
Login timeout expired
Named Pipes Provider: Could not open a connection to SQL Server [2].
Last SQL error code: 2

I have checked and Named Pipes is enabled and I can run a sqlcmd session over named pipes.

michellem33

:oops: It's alright. I just didn't read the help properly :oops:

Brian Donahue

When using the command-line version, you need to specify the instance name still: sqlbackupc -SQL "backup database [northwind] to disk='c:\temp\nwbackup.sqb'" -I SQLEXPRESS -E

You don't need to use -I or -E with the Extended Stored Procedure any more, though.