Taking Backup into local disk from server in Sql server management Studio

[szlamany]

The SERVICE in running on a remote server - and SSMS talks to the service.

So of course the disks available are SERVER-CENTRIC.

You could create a share or browse to a url that is on your local machine - such as if your workstation was called \\MYWORKSTATION you would browse to \\MYWORKSTATION\C$ - that's if C$ was an admin share available to the SERVER.

But more important - why do you want to do this??

If this is a production server - then you want regularly scheduled backups to occur on only local disks to the server

If this is a one-off backup then open a share on your workstation that the server can see.

I've done commands like this to send backups to remote folders

Backup Database TCSHemp To Disk='\\10.14.14.98\tcs folders\ARCHIVE TCS\TCSHemp.F07

Remember that the backup runs under the USERNAME of the SERVICE running on the remove server - not under your username on the workstation. That's only how you authenticate to connect to the SQL server "service".

[firoz.raj]

Even i tried to restore the Database it Says an Exception while Executing a Transact-sql statement or batch .Microsoft.Sqlserver.Express.ConnectionInfo
Kindly see the attachment also .and let me know some the same .any help would be highly appreciated .

[szlamany]

Why don't you move the error popup so we all can see what's under it - why are you trying to restore it - I thought we were discussing backup??