登入

Microsoft.com

Microsoft

Remove From My Forums

sqlcmd error

問題
0

登入以投票

I would like to use sqlcmd to backup. My code as the below:
sqlcmd -S.\SQLExpress -Q"BACKUP DATABASE test TO DISK = 'C:/sqlbackup/auto/test.dat'"

But it prompt a error message as the below:
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

How can I solve it?

2009年9月8日上午 03:40

回覆

|

引述

所有回覆

0

登入以投票

Did you run it on sql server machine? Should add login info in the command with -U -P or -E option.

2009年9月8日下午 01:28

回覆

|

引述
0

登入以投票

I have change the command to

sqlcmd -U sa -P mypass -S.\SQLExpress -Q"BACKUP DATABASE test TO DISK = 'C:/sqlbackup/auto/test.dat'"

But it still has the same result.

2009年9月12日上午 08:08

回覆

|

引述
0

登入以投票

Did you run it on sql server?

2009年9月12日下午 03:54

回覆

|

引述