Friday, February 10, 2012

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 you 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=djq&as_ugroup=microsoft.public.sqlserver
"Steve K." <steve@.kitley.com> wrote in message news:OAKHDO86DHA.1632@.TK2MSFTNGP12.phx.gbl...
> 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.
>|||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...
> The only thing that RETAINDAYS and EXPIREDATE does is that it won't allow
you 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=djq&as_ugroup=microsoft.public.sqlserver
>
> "Steve K." <steve@.kitley.com> wrote in message
news:OAKHDO86DHA.1632@.TK2MSFTNGP12.phx.gbl...
> > 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.
> >
> >
>|||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=djq&as_ugroup=microsoft.public.sqlserver
"SteveK" <steve(removethis)@.kitley.com> wrote in message
news:u28ooH96DHA.632@.TK2MSFTNGP12.phx.gbl...
> 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...
> > The only thing that RETAINDAYS and EXPIREDATE does is that it won't allow
> you 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=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "Steve K." <steve@.kitley.com> wrote in message
> news:OAKHDO86DHA.1632@.TK2MSFTNGP12.phx.gbl...
> > > 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.
> > >
> > >
> >
> >
>|||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...
> 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=djq&as_ugroup=microsoft.public.sqlserver
>
> "SteveK" <steve(removethis)@.kitley.com> wrote in message
> news:u28ooH96DHA.632@.TK2MSFTNGP12.phx.gbl...
> > 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...
> > > The only thing that RETAINDAYS and EXPIREDATE does is that it won't
allow
> > you 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=djq&as_ugroup=microsoft.public.sqlserver
> > >
> > >
> > > "Steve K." <steve@.kitley.com> wrote in message
> > news:OAKHDO86DHA.1632@.TK2MSFTNGP12.phx.gbl...
> > > > 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 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 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...
>>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=djq&as_ugroup=microsoft.public.sqlserver
>>"SteveK" <steve(removethis)@.kitley.com> wrote in message
>>news:u28ooH96DHA.632@.TK2MSFTNGP12.phx.gbl...
>>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...
>>The only thing that RETAINDAYS and EXPIREDATE does is that it won't
> allow
>>you 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=djq&as_ugroup=microsoft.public.sqlserver
>>"Steve K." <steve@.kitley.com> wrote in message
>>news:OAKHDO86DHA.1632@.TK2MSFTNGP12.phx.gbl...
>>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.
>>
>>
>>
>

No comments:

Post a Comment