What is the best way to set up a daily backup?

[aolb]

Does anyone have any thought as to the best approach to setting up daily backups?

Currently I have set up a backup device and have a batch job that overwrites the previous back up.

 

[osjohnm]

Hi

You might consider setting up a Database Maintenance Plan.
In that you can setup database backups with a variety of options that you can use.

You can select only a few databases or all of them, there are optimizations, integrity checks and fixes you can turn on or off, database backup options, transaction log backups and you can even setup reporting options such as a txt file or netsend. You will be able to choose for how long a backup file may exist before you overwrite it

Then all you do is setup a job(or it might actually do it for you when creating the plan's schedule, haven't done it for a while) and let the job execute the maintenance plan.

Go to Management in Enterprise Manager and then click on Database Maintenance Plans.

BOL contains quite a bit of info on this.
Here is two links to Maintenance Plans and Backup Performance Tuning

http://www.sql-server-performance.com/ak_inside_sql_server_maintenance_plans.asp

http://www.sql-server-performance.com/backup_restore_tuning.asp

John

 

[Fampofo]

HI
YOU CAN SET IT UP THROUGH ENTERPRISE MANAGER...
GO TO MANAGEMENT then SQL SERVER AGENT then JOBS.
If you havnt used this tool before you need to read about it before you can find it useful.