Options
Command Line Utility on SQL 2005
michellem33
Posts: 19
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.
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.
Comments
You don't need to use -I or -E with the Extended Stored Procedure any more, though.