How do my database sql2005 database to another server with management studio

25 pts.
SQL Server 2005
SQL Server backup
SQL Server Management Studio
Has sql 2005, using management studio to do a full backup of my database. Using maintenance wizard to set the backup. I only see my local drive and not my share folder created onthe other server where i want to place the .bak file. Any idea will be helpfull.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You basically cant backup your database to a shared resource as SQL server runs under a less priviliged account that does not have access to your shared resources. It does not matter if you execute a command (either manually or from the wizard) from an Administrator account and you have full access to the shared drives. SQL will call the backup process from its running account (Networkservice).
You could get around this in a couple of ways :
1. Change the user account running the sql service to an account that can access network shares. This however can be a security risk.
2. Backup to a local folder and have a seperate scheduled job move the backup file to the shared folder.
3. Buy a 3rd party backup software (Red Gate SQL Backup) that can backup to a shared drive.

Once you had open the management studio and connected to your server,
1) using management studio
2) select management, then select maintenance plan, right click to get maintenance wizard
3) name your Plan, then set the schedule by selecting the change button. (select your time/date you want the job to start)
4) select backup database (full) – as an example !!, OK
5) press next
verify the task and selct next
6) in database(s): select data database you want to backup
7) select crate backup file for every database, ( no need to place a check mark in creat a subdirectory box. Now, in folder path….you have to make sure to create a share folder in your other server where you will place the backup file.
8) path should look like this: \\ have to place the name not ip. Then you domain)\yoursharefolder this should to the trick.
for example: \\\sqlbackup

good luck

Discuss This Question:  

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: