Backup everything except data

We have a SQL2000 database that is created via a dump from a third party
product. Being as this dump runs every day, we don't need to back up the
data. However we need the schema, views, triggers, etc. Everything except
the actual data in the tables. Is there a way to make a backup of this?
Thanks!
BrianYes, use some tool that generates DDL script for the database:
http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Brian" <me@.here.there> wrote in message news:O%2323gnK8HHA.484@.TK2MSFTNGP06.phx.gbl...
> We have a SQL2000 database that is created via a dump from a third party product. Being as this
> dump runs every day, we don't need to back up the data. However we need the schema, views,
> triggers, etc. Everything except the actual data in the tables. Is there a way to make a backup of
> this?
> Thanks!
> Brian
>

Backup devices and backup expire

We have a third party application that backs up a sql server database as
part of its overall backup plan. This is hardwired into the application, so
that it must have a backup device with a specific name. I would like to drop
backup sets from the device after a week, so that the backup device does not
grow without bounds. I have played with expiredate/retaindays but this is
not the answer.
Any suggestions would be most appreciated.
Thanks,
John
Unfortunately, you cannot remove part of a backup device, it is all or nothing. An option can be to copy the
physical file at regular intervals over to a new file name and then delete these files as they get too old.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"John" <jkraeck@.NOprincetonSPAM.edu> wrote in message news:uol5hQWIEHA.308@.tk2msftngp13.phx.gbl...
> We have a third party application that backs up a sql server database as
> part of its overall backup plan. This is hardwired into the application, so
> that it must have a backup device with a specific name. I would like to drop
> backup sets from the device after a week, so that the backup device does not
> grow without bounds. I have played with expiredate/retaindays but this is
> not the answer.
> Any suggestions would be most appreciated.
> Thanks,
> John
>
|||Tibor,
Thanks for the response. Alas, I thought that might be the case.
I will look into alternate methods of working around the issue. There is
always some way out.
Cheers,
John
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23FnpQhWIEHA.2688@.tk2msftngp13.phx.gbl...
> Unfortunately, you cannot remove part of a backup device, it is all or
nothing. An option can be to copy the
> physical file at regular intervals over to a new file name and then delete
these files as they get too old.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
news:uol5hQWIEHA.308@.tk2msftngp13.phx.gbl...[color=darkblue]
so[color=darkblue]
drop[color=darkblue]
not[color=darkblue]
is
>

Backup devices and backup expire

We have a third party application that backs up a sql server database as
part of its overall backup plan. This is hardwired into the application, so
that it must have a backup device with a specific name. I would like to drop
backup sets from the device after a week, so that the backup device does not
grow without bounds. I have played with expiredate/retaindays but this is
not the answer.
Any suggestions would be most appreciated.
Thanks,
JohnUnfortunately, you cannot remove part of a backup device, it is all or nothi
ng. An option can be to copy the
physical file at regular intervals over to a new file name and then delete t
hese files as they get too old.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"John" <jkraeck@.NOprincetonSPAM.edu> wrote in message news:uol5hQWIEHA.308@.tk2msftngp13.phx
.gbl...
> We have a third party application that backs up a sql server database as
> part of its overall backup plan. This is hardwired into the application, s
o
> that it must have a backup device with a specific name. I would like to dr
op
> backup sets from the device after a week, so that the backup device does n
ot
> grow without bounds. I have played with expiredate/retaindays but this is
> not the answer.
> Any suggestions would be most appreciated.
> Thanks,
> John
>|||Tibor,
Thanks for the response. Alas, I thought that might be the case.
I will look into alternate methods of working around the issue. There is
always some way out.
Cheers,
John
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23FnpQhWIEHA.2688@.tk2msftngp13.phx.gbl...
> Unfortunately, you cannot remove part of a backup device, it is all or
nothing. An option can be to copy the
> physical file at regular intervals over to a new file name and then delete
these files as they get too old.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
news:uol5hQWIEHA.308@.tk2msftngp13.phx.gbl...
so
drop
not
is
>

Backup devices and backup expire

We have a third party application that backs up a sql server database as
part of its overall backup plan. This is hardwired into the application, so
that it must have a backup device with a specific name. I would like to drop
backup sets from the device after a week, so that the backup device does not
grow without bounds. I have played with expiredate/retaindays but this is
not the answer.
Any suggestions would be most appreciated.
Thanks,
JohnUnfortunately, you cannot remove part of a backup device, it is all or nothing. An option can be to copy the
physical file at regular intervals over to a new file name and then delete these files as they get too old.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"John" <jkraeck@.NOprincetonSPAM.edu> wrote in message news:uol5hQWIEHA.308@.tk2msftngp13.phx.gbl...
> We have a third party application that backs up a sql server database as
> part of its overall backup plan. This is hardwired into the application, so
> that it must have a backup device with a specific name. I would like to drop
> backup sets from the device after a week, so that the backup device does not
> grow without bounds. I have played with expiredate/retaindays but this is
> not the answer.
> Any suggestions would be most appreciated.
> Thanks,
> John
>|||Tibor,
Thanks for the response. Alas, I thought that might be the case.
I will look into alternate methods of working around the issue. There is
always some way out.
Cheers,
John
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23FnpQhWIEHA.2688@.tk2msftngp13.phx.gbl...
> Unfortunately, you cannot remove part of a backup device, it is all or
nothing. An option can be to copy the
> physical file at regular intervals over to a new file name and then delete
these files as they get too old.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
news:uol5hQWIEHA.308@.tk2msftngp13.phx.gbl...
> > We have a third party application that backs up a sql server database as
> > part of its overall backup plan. This is hardwired into the application,
so
> > that it must have a backup device with a specific name. I would like to
drop
> > backup sets from the device after a week, so that the backup device does
not
> > grow without bounds. I have played with expiredate/retaindays but this
is
> > not the answer.
> >
> > Any suggestions would be most appreciated.
> >
> > Thanks,
> > John
> >
> >
>