Backup using osql and named pipes - Syntax help

Use sqlcmd instead of osql.
osql is outdated in SQL Server 2005.

Hope this helps:

http://msdn.microsoft.com/en-us/library/ms162773(SQL.90).aspx

Thanks but that does not really answer my question.  sqlcmd uses the same syntax's but that does not work either if I use that instead of osql.  If your going to suggest using something different can you please specify the syntax as im a stranger to sql so need extra help.

Question remains, can I do a backup like this using the alias name which is currently what is casuing me trouble with osql.

Thanks

Hope this helps:

replace all those values like user_name, password, etc., before trying to run it out

sqlcmd -U user_name -P password -S server_name -d db_name -E -Q "BACKUP DATABASE BESMgmt TO DISK = 'D:\backup\besDBbackup.bak' WITH INIT" 

Select allOpen in new window

Thanks, i have been suplimenting -u -p with -S  apart from taht I kept the same syntax.

C:\Users\Administrator>sqlcmd -E -S backupsql -d vim_vcdb -E -Q "BACKUP DATABASE
 vim_vcbd TO DISK = 'D:\backup\besDBbackup.bak' WITH INIT"

Comes out with

Msg 911, Level 16, State 11, Server servername\SQLEXP_VIM, Line 1
Could not locate entry in sysdatabases for database 'vim_vcbd'. No entry found w
ith that name. Make sure that the name is entered correctly.
Msg 3013, Level 16, State 1, Server servername\SQLEXP_VIM, Line 1
BACKUP DATABASE is terminating abnormally.

Regarding the error "Could not locate entry in sysdatabases for database 'vim_vcbd'.  I fired up SQL server management studio express and I see that the vin_vcdb database is at "root" level or the same level as the "System Databases" folder which this command is trying to look inside to find this database.

Is the backup still possible with this configuration?

Thanks

The -E is not Named Pipes it security authorization. The -E is indicating that you want to use username of whoever is running the sqlcmd.exe from the command prompt. So if you are logged on the server as MyDomain\Admin, the SQL Server has the login MyDomain\Admin in the SQL Server --> Security --> Logins with appropriate permissions to complete the task.

SQLCMD.EXE -E -S MyServerName -Q "BACKUP DATABASE BESMgmt TO DISK = 'D:\backup\besDBbackup.bak' WITH INIT"

Also the drive you are backing up to has to be local to the server, and the path must exist already.

As an aside -- I highly recommend you disable Named Pipes. They are nothing but problems. The protocol was designed for very small, fast, stable networks. However I have never heard of them working well over the long term. Even M$ has backed away from it to a large extent.

The backup path exists but

SQLCMD.EXE -E -S MyServerName

Will not connect as it's trying to connect using the default 1433 port which then fails.  Using the named pipe is the only way I could see to get the connection on the right port.

Is there any other way I could specify a port?

Great thanks.   I have spent 4 days trying to find a method of specifying the port number.

Glad to be of assistance. May all your days get brighter and brighter.