How can I back up to a device with out over writing the last backu

I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
database's to a device,,which works fine but it over writes the files in the
directory. The code i am using is
BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , N
AME =
N'my backup', NOSKIP , STATS = 10, NOFORMAT
Can anyone please help me with this, I tried using a mapped drive but that
does not work. Is there any way I can use a maint plan to back up to a devic
e
and not over write the last back up file? in the use this directory can I us
e
the unc?It WILL overwrite the old since you give same name to the backup file. You
must figure out another way to work for you. My backup will write to a
folder depend on what day of the week. So I always have a 7 days of backup.
hth,
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in
> the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD ,
NAME =
> N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a
> device
> and not over write the last back up file? in the use this directory can I
> use
> the unc?
>|||The answer to my question is yes you can use the unc path in the use this
dircetory. but I still don't know about the device over write problem.
"DAVID S" wrote:

> I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in t
he
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD ,
NAME =
> N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but tha
t
> does not work. Is there any way I can use a maint plan to back up to a dev
ice
> and not over write the last back up file? in the use this directory can I
use
> the unc?
>|||NOINIT means append and INIT means overwrite. Your statement posted will app
end.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in t
he
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD ,
NAME =
> N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a dev
ice
> and not over write the last back up file? in the use this directory can I
use
> the unc?
>