topic Re: SQL backup job issue on win2003 in Windows Server 2003

SQL backup job issue on win2003

sam chen — Sun, 20 Feb 2005 21:50:04 GMT

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.

Re: SQL backup job issue on win2003

Roger Faucher — Sun, 20 Feb 2005 21:53:22 GMT

Sam:

I think you'll need to translate for us.

Make a great day!

Roger

Re: SQL backup job issue on win2003

sam chen — Sun, 20 Feb 2005 22:09:12 GMT

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?

Re: SQL backup job issue on win2003

Roger Faucher — Sun, 20 Feb 2005 22:45:56 GMT

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

Re: SQL backup job issue on win2003

Roger Faucher — Sun, 20 Feb 2005 22:47:20 GMT

Sam:

Here's another one worth looking at:

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

Roger

Re: SQL backup job issue on win2003

Roger Faucher — Sun, 20 Feb 2005 22:50:23 GMT

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

Re: SQL backup job issue on win2003

Norman_21 — Tue, 22 Feb 2005 12:43:29 GMT

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

Re: SQL backup job issue on win2003

Norman_21 — Tue, 22 Feb 2005 12:46:16 GMT

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

Re: SQL backup job issue on win2003

Roger Faucher — Wed, 23 Feb 2005 07:24:26 GMT

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

Re: SQL backup job issue on win2003

Norman_21 — Wed, 23 Feb 2005 11:15:27 GMT

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?

Re: SQL backup job issue on win2003

Norman_21 — Sat, 26 Feb 2005 23:51:13 GMT

Hello Sam
Can you keep us updated please?

Re: SQL backup job issue on win2003

Norman_21 — Wed, 09 Mar 2005 04:09:57 GMT

Sammmmmmmm?
Any updates please?