A database maintenace plan will do this for you. You might want to check out
Books On Line (BOL) which you can access via the F1 key in EM. There's a lot
of good info there.

Carolyn J.


-----Original Message-----
From: Douglas Zhande [mailto:mssqldba-ezmlmshield-
x54413229.[Email address protected]
Sent: Friday, August 31, 2007 4:15 AM
To: LazyDBA Discussion
Subject: RE: Schedule Backup

How do I schedule a backup, each day the backup should have a different
name .i.e BACKUPYYYYMMDD the backups should be differentiated by date


MS Sql Server LazyDBA home page