SQL 2005 Beginner - making a full database backup daily. 1

[stla]

Good day,

I am an absolute beginner with SQL 2005.

My goal is to make a full backup of the database every day without stopping the database. The backup will be saved to a network volume.

Can anyone give me any pointers on how to achieve this?

Best regards

 

[bborissov]

In Object browser Open "Management", right click on "Maintenance Plans" node, select "Maintenance Plan Wizard" and follow it.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[bborissov]

I forgot. To do so you need SQL Server Agent to be started.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[stla]

Well I successfully activated the agent,started the wizard and planned my strategy (Full back up of database every weekday).

All went well until I wanted to save the maintenance plan; the wizard accepted all of my entries but failed when trying to save the plan.

I have checked all my entries going as far as to accept the suggested values and paths from the wizard to no avail.

The wizard informs me that there is an error when saving.

I have appended (and translated) the text below.

Any ideas where I might be going wrong?

Best regards

===================================

Fehler beim Speichern des Wartungsplanes.
(Error when saving the maintenance plan.)

===================================

Mindestens ein Argument ist ungültig.
(At least one argument is invalid.)


------------------------------
Speicherort des Programms:
(Save location of programme

bei Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
bei Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save()
bei Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()

 

[bborissov]

Have no idea, sorry :-(

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP