SQL backup job issue on win2003

[sam chen]

hi, i have a SQL backup job issue on win2003.
When i create a backup job for SQL-database on win2003.
It's fail and pop an error message (see attached).
Thanks for your help.

[Roger Faucher]

Sam:

I think you'll need to translate for us.

Make a great day!

Roger

[sam chen]

Roger,
Thanks, It's describe below.
"a fault on general network issue and please refer to your documents for network"

I can not understand.
Thank you, could you help me?

[Roger Faucher]

Sam:

I think it made just as much sense to me when the error message was in Chinese. ;-)

If you're using VSS, check out this article:

https://mvp.support.microsoft.com/default.aspx?scid=kb;en-us;833167

Roger

[Roger Faucher]

Sam:

Here's another one worth looking at:

https://mvp.support.microsoft.com/default.aspx?scid=kb;en-us;843515

Roger

[Roger Faucher]

Sam:

If you're using a third-party backup program, this is a possibility:

https://mvp.support.microsoft.com/default.aspx?scid=kb;en-us;822219

Roger

[Norman_21]

From the attached screen shot, it appears that your SQL Server Manager ICON on the task bar is not started?
You must start the SQLServer Agent Service before you can create a SQL backup job.

1. Double cilck on the SQLServer Manager ICON
From the drop down list, select SQLServer Agent
Hit the Green PLAY button to start the Service

If you have problems starting the service due to a logon failure, then refer to these articles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;282254

http://support.microsoft.com/default.aspx?scid=kb;en-us;322140

2. If you have the SQLServer Agent Started and you are trying to create the backup disk device name in a remote server, then run this script in the SQL Query Analyzer:

USE yourdatabasename
EXEC sp_addumpdevice 'disk', 'MyBackup', '\\Server\Shared Name\MyBackup.bak'

If you want to create the disk device locally which is not recommended by Microsoft:

USE yourdatabasename
EXEC sp_addumpdevice 'disk', 'MyBackup', 'C:\My SQL DB\MyBackup.bak'

The default SQL backup directory is:
C:\Program Files\Microsoft SQL Server\MSSQL\Data\Backup if I'm not mistaken but you can see it while creating a backup job.

Now that you have a disk device created, use the SQL Server Enterprise Manager to create a backup job.
At the General Tab and under the Destination tab, Click on DISK and ADD the Disk device you have created.

Please keep us updated

[Norman_21]

Also, add to your notes that it is very important to monitor the SQLServer Agent Error Log:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_0tyf.asp

[Roger Faucher]

Sam:

I just realized I posted links from the MS MVP KB. I should have posted as follows:

http://support.microsoft.com/default.aspx?scid=kb;en-us;833167

http://support.microsoft.com/default.aspx?scid=kb;en-us;843515

http://support.microsoft.com/default.aspx?scid=kb;en-us;822219

Sorry.

Roger

[Norman_21]

Sam,

Creating a Maintenance Plan will give you the option to create a SQL backup as well and it's the easiest way:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_378k.asp


Would you mind to keep us updated please?

[Norman_21]

Hello Sam
Can you keep us updated please?

[Norman_21]

Sammmmmmmm?
Any updates please?