What are the challenges you face when working across database platforms? Take the survey
Options

Command Line Utility on SQL 2005

michellem33michellem33 Posts: 19
edited January 30, 2006 12:58PM in SQL Backup Previous Versions
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.

Comments

Sign In or Register to comment.