Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Environment: Shared Hosting
- No MSSQL control panel
- Only have mssql management studio

MSSQL Server: Remote
- YES Remote SQL Connections
- NO Shared Drive

Is there a way to backup MSSQL 2005 or 2008 databases to my local machine or shared server? Ive read and tried Microsofts SMO code base and it looks like it backs the files up to the SQL server or shared drive only. Backup type im looking to make is a .BAK type.

share|improve this question

You may use a code which is similar to the one below.


With this (C$) you need not create a new share instead you can use the existing Administrative Share on the target server. However the user taking the backup needs to have administrative privileges on the target server.

share|improve this answer
The MSSQL servers cannot talk to the shared servers. Only access I have to the MSSQL servers is via sql management studio express. – meh Aug 3 '10 at 9:54
If you don't have access to any remote server - try to backup your database in folder where your database located (it definitely should be accessible). After that you cant try to upload your database backup to any accessible remote server using commands executed via xp_cmdshell or so on... – Sergey Nov 16 '10 at 18:25

No, what you ask for is not feasible. And would likely result in trouble with your hoster -they should handle backups through the control panel. If they do not, contact their support and ASK. Do not play around in their environment without actually knowing what you do.

Backups always originate on the SQL Server and can there go to discs or reachable network drives.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.