I have a backup device setup (x)
I wish to have the logfile (Y) BACKEDUP to X every hour.
I want ever Y to be appended to X.
I then want Y to expire after two days as I have a
dif_backup occuring 24hrs.
Within EM I am unable to see how this works. Is there a
way within EM? Or did I need to generate TSQL to iniate
this task?
Please help this novice.
BenThe maintenance plans has options for deleting backup files after a number
of days. Or write your own code.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Benjamin" <ben.jones@.trendwest.com.au> wrote in message
news:065201c3a4e4$e84ac9a0$a401280a@.phx.gbl...
> I have a backup device setup (x)
> I wish to have the logfile (Y) BACKEDUP to X every hour.
> I want ever Y to be appended to X.
> I then want Y to expire after two days as I have a
> dif_backup occuring 24hrs.
> Within EM I am unable to see how this works. Is there a
> way within EM? Or did I need to generate TSQL to iniate
> this task?
> Please help this novice.
> Ben
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment