How can we help you today? How can we help you today?

Command Line Utility on SQL 2005

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
0

Comments

2 comments

Sort by
  • michellem33
    :oops: It's alright. I just didn't read the help properly :oops:
    michellem33
    0
  • 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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.