We have been performing our sql database using osql as follows:
osql -s IP-9873743\SQLEXPRESS -E -Q "BACKUP DATABASE DBNAME TO
Disk ='e:\sysbkup\sqlbackup\DBNAME.bak' WITH NOFORMAT,
INIT, NAME = N' DBNAME-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10"
We want to do the same from another host but when we add the -H for host option on the command we get "The login failed". With MS SQL Server Management Studio, we are able to login to the other server fine with Windows Authentication since my machine and the other host are using the same usernames with same password.
When I run the backup statement from the MGMT Studio console the backup is saved to the disk of the other host, instead of transferring the backup to the client machine. Any ideas how I will be able to backup an MSSQL database from another host different than the mssql engine itself?