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

[firoz.raj]

Hi friends ,when i try to take backup using Sql server Management Studio.i am unable to browse my local disk.it shows Server Disk .i want to take backup from server to my System Disk .Let me know the idea .any help would be highly appreciated.

[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??