View Full Version : SQL express Backup job


koolguy
06-16-2008, 07:43 AM
hi all,

Basically, Via the sql express I have managed to create a manual backup of my customer database on the hard disk. And its saved in the following location.

C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup\Customer.bak

Can anyon ehelp me automate the backups (instead of me having to do it manually) such that the 'Customer.bak' is updated every day at a certain time so that it includes the data stored in the tables every day.

Any help shall be much appreciated.

SQL_Hell
06-17-2008, 02:54 AM
This post seems to have lost 2 replies? Can admin please investigate?

koolguy
06-17-2008, 11:06 AM
hey SQL Hell,

do u have solution to my query?

SQL_Hell
06-18-2008, 01:13 AM
Hi,

Can you re-post it? I cant remember exactly what you previously wrote