Backups

I've got a question for everyone. I would like to make full backups of my
database on a daily basis. I would like to be able to store the last 7 days
worth of backups. I want to just backup to a regular disk directory as I
will move to tape from that directory. Is there any good way to do this
built in or do I need to search elsewhere? Something like:
Monday.bak
Tuesday.bak
Wednesday.bak
Thursday.bak
Friday.bak
Saturday.bak
Sunday.bak
Excuse me if this is obvious and I've missed it. I don't know exactly what
to google for. Thanks for any assistance.
...ScottHave a look at maintenance plans (Management folder | Database Maintenance
plans)
They will walk you through the procedure. The names will not be Monday.bak,
Tuesday.bak but they will be easily identifiable as to
A. Which DB the backup represents
2. What date and time the backup was taken.
You can roll your own but this will do what you want.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Scott Hunter" <coolcsh@.hotmail.com> wrote in message
news:OvXy2nduDHA.1740@.TK2MSFTNGP12.phx.gbl...
> I've got a question for everyone. I would like to make full backups of my
> database on a daily basis. I would like to be able to store the last 7
days
> worth of backups. I want to just backup to a regular disk directory as I
> will move to tape from that directory. Is there any good way to do this
> built in or do I need to search elsewhere? Something like:
> Monday.bak
> Tuesday.bak
> Wednesday.bak
> Thursday.bak
> Friday.bak
> Saturday.bak
> Sunday.bak
> Excuse me if this is obvious and I've missed it. I don't know exactly what
> to google for. Thanks for any assistance.
> ...Scott
>