Backup to dump device

Hello:
I am trying to backup to a dump device using sqlserver 2000 to the local
disk.
I am using retaindays=3. I thought you need to use that with the init
command, but it is failing. So, I am using that alone and the backup is
ignoring the retention policy on the dump device and backing the files up
one after the other without removing those older than 3 days.
I keep getting the error message media has a date that has not expired.
Anybody now what is happening here:
Backup database x to xx
with
retaindays=3,
mediadescription = 'backupxxx'
medianname = 'backupxx'
thanks in advance for your help,
Steve K.The only thing that RETAINDAYS and EXPIREDATE does is that it won't allow yo
u to overwrite before
that date. These option will not, in any way, automate deletion of old files
or anything to that
effect.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Steve K." <steve@.kitley.com> wrote in message news:OAKHDO86DHA.1632@.TK2MSFTNGP12.phx.gbl...[QUOTE
]
> Hello:
> I am trying to backup to a dump device using sqlserver 2000 to the local
> disk.
> I am using retaindays=3. I thought you need to use that with the init
> command, but it is failing. So, I am using that alone and the backup is
> ignoring the retention policy on the dump device and backing the files up
> one after the other without removing those older than 3 days.
> I keep getting the error message media has a date that has not expired.
> Anybody now what is happening here:
> Backup database x to xx
> with
> retaindays=3,
> mediadescription = 'backupxxx'
> medianname = 'backupxx'
> thanks in advance for your help,
> Steve K.
>[/QUOTE]|||Thanks Tibor!
I used SQL Server 7.0 before and could have sworn I had done that. But,
unfortunately I have lost my code since that time.
I will forget the idea.
thanks,
Steve
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ezo9oq86DHA.1636@.TK2MSFTNGP12.phx.gbl...

quote:

---

> The only thing that RETAINDAYS and EXPIREDATE does is that it won't allow

---

you to overwrite before

quote:

---

> that date. These option will not, in any way, automate deletion of old

---

files or anything to that

quote:

---

> effect.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:

---

http://groups.google.com/groups?oi=...ublic.sqlserver

quote:

---

>
> "Steve K." <steve@.kitley.com> wrote in message

---

news:OAKHDO86DHA.1632@.TK2MSFTNGP12.phx.gbl...

quote:

---

up[QUOTE]
>

---

|||Sorry to disappoint you, Steve... :-)
You might want to verify in BOL, just to be absolutely certain. Just in case
you haven't seen this,
the Maintenance Wizard does automate deletion of old backup file...
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"SteveK" <steve(removethis)@.kitley.com> wrote in message
news:u28ooH96DHA.632@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Thanks Tibor!
> I used SQL Server 7.0 before and could have sworn I had done that. But,
> unfortunately I have lost my code since that time.
> I will forget the idea.
> thanks,
> Steve
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:ezo9oq86DHA.1636@.TK2MSFTNGP12.phx.gbl...
> you to overwrite before
> files or anything to that
> [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url
]
> news:OAKHDO86DHA.1632@.TK2MSFTNGP12.phx.gbl...
> up
>

---

|||Thanks Tibor,
I will check that out tonight. Great. If it works, then that must have been
the way I did it.
I really appreciate your help.
Best regards & thanks again,
Steve K.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u%237dsc96DHA.2628@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Sorry to disappoint you, Steve... :-)
> You might want to verify in BOL, just to be absolutely certain. Just in

---

case you haven't seen this,

quote:

---

> the Maintenance Wizard does automate deletion of old backup file...
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:

---

http://groups.google.com/groups?oi=...ublic.sqlserver

quote:

---

>
> "SteveK" <steve(removethis)@.kitley.com> wrote in message
> news:u28ooH96DHA.632@.TK2MSFTNGP12.phx.gbl...
in[QUOTE]
allow[QUOTE]
http://groups.google.com/groups?oi=...ublic.sqlserver[QUOTE]
local[QUOTE]
init[QUOTE]
backup is[QUOTE]
files[QUOTE]
expired.[QUOTE]
>

---

|||The maintenance wizard uses the 'sqlmaint' utility. Look that up in
books online. It is a great tool.
Charles
SteveK wrote:

> Thanks Tibor,
> I will check that out tonight. Great. If it works, then that must have be
en
> the way I did it.
> I really appreciate your help.
> Best regards & thanks again,
> Steve K.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:u%237dsc96DHA.2628@.TK2MSFTNGP10.phx.gbl...
>
> case you haven't seen this,
>
> [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url
]
>
> in
>
> allow
>
> [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url
]
>
> local
>
> init
>
> backup is
>
> files
>
> expired.
>
>