Can I delete BAK and TRN files?

I have an implementation of SQL Server 2000 with a job to
backup a customer database. The backup works file, but
none of the old backup and transaction files are removed
after each backup, so it is consuming a lot of disk
space. I have BAK and TRN files dating back 3 months.
Before I deleted any of the old files, I wanted to make
sure I am okay to do so. Does anyone know of a problem
with manually most of these files, leaving only the most
recent week or two of backups?
Thanks,
Jason... and if the backups are created by a SQL Server maintenance plan, you can
modify it to have the files older than a specified period removed. It's on
the Complete Backup and Transaction Log Backup tabs respectively, Remove
files older than item.
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:0b4a01c3d932$260faea0$a001280a@.phx.gbl...
> As far as whether deleting the old backup files will do
> any damage to the backup setup (e.g. your maintanance
> plans) is concerned, there is no problem. But you do need
> to make sure that if you ever need them, you can get them
> back (e.g. from your tape backup facility).
> Linchi
> >--Original Message--
> >I have an implementation of SQL Server 2000 with a job to
> >backup a customer database. The backup works file, but
> >none of the old backup and transaction files are removed
> >after each backup, so it is consuming a lot of disk
> >space. I have BAK and TRN files dating back 3 months.
> >Before I deleted any of the old files, I wanted to make
> >sure I am okay to do so. Does anyone know of a problem
> >with manually most of these files, leaving only the most
> >recent week or two of backups?
> >
> >Thanks,
> >
> >Jason
> >.
> >sql

Can I delete BAK and TRN files?

I have an implementation of SQL Server 2000 with a job to
backup a customer database. The backup works file, but
none of the old backup and transaction files are removed
after each backup, so it is consuming a lot of disk
space. I have BAK and TRN files dating back 3 months.
Before I deleted any of the old files, I wanted to make
sure I am okay to do so. Does anyone know of a problem
with manually most of these files, leaving only the most
recent week or two of backups?
Thanks,
JasonAs far as whether deleting the old backup files will do
any damage to the backup setup (e.g. your maintanance
plans) is concerned, there is no problem. But you do need
to make sure that if you ever need them, you can get them
back (e.g. from your tape backup facility).
Linchi

quote:

---

>--Original Message--
>I have an implementation of SQL Server 2000 with a job to
>backup a customer database. The backup works file, but
>none of the old backup and transaction files are removed
>after each backup, so it is consuming a lot of disk
>space. I have BAK and TRN files dating back 3 months.
>Before I deleted any of the old files, I wanted to make
>sure I am okay to do so. Does anyone know of a problem
>with manually most of these files, leaving only the most
>recent week or two of backups?
>Thanks,
>Jason
>.
>

---

|||... and if the backups are created by a SQL Server maintenance plan, you ca
n
modify it to have the files older than a specified period removed. It's on
the Complete Backup and Transaction Log Backup tabs respectively, Remove
files older than item.
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:0b4a01c3d932$260faea0$a001280a@.phx.gbl...[QUOTE]
> As far as whether deleting the old backup files will do
> any damage to the backup setup (e.g. your maintanance
> plans) is concerned, there is no problem. But you do need
> to make sure that if you ever need them, you can get them
> back (e.g. from your tape backup facility).
> Linchi
>

Can I delete a DB and add it back under same name?

Are there any "cleaning" issues I should know about if I delete a database
in 2005, and then add it back under the same name with a newer .BAK file?
I know how to delete, and how to import a backup, but I don't know if there
are suggested cleaning steps between. Anything I should do?
drop database <db>
should delete it from sql catalog and remove the data file from disk.
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> Are there any "cleaning" issues I should know about if I delete a database
> in 2005, and then add it back under the same name with a newer .BAK file?
> I know how to delete, and how to import a backup, but I don't know if
> there
> are suggested cleaning steps between. Anything I should do?
>
|||So no extra cleanup steps needed? I imagine there COULD be weird things
left behind.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> drop database <db>
> should delete it from sql catalog and remove the data file from disk.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
database[vbcol=seagreen]
file?
>
|||Just drop the database it will delete related files.
If database is offline only in that case you have to manually delete
files.
Then restore databse.
Regards
Amish Shah
|||The only thing I can think of is backup history in the msdb database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"HK" <replywithingroup@.notreal.com> wrote in message
news:0OHWf.17622$w86.15212@.tornado.socal.rr.com...
> So no extra cleanup steps needed? I imagine there COULD be weird things
> left behind.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> database
> file?
>
|||when you drop a database through EM it will ask to delete history about
backup and restore.
If you drop database using TSQL you will have to delete history
maually.
Regards
Amish Shah

Can I delete a DB and add it back under same name?

Are there any "cleaning" issues I should know about if I delete a database
in 2005, and then add it back under the same name with a newer .BAK file?
I know how to delete, and how to import a backup, but I don't know if there
are suggested cleaning steps between. Anything I should do?drop database <db>
should delete it from sql catalog and remove the data file from disk.
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> Are there any "cleaning" issues I should know about if I delete a database
> in 2005, and then add it back under the same name with a newer .BAK file?
> I know how to delete, and how to import a backup, but I don't know if
> there
> are suggested cleaning steps between. Anything I should do?
>|||So no extra cleanup steps needed? I imagine there COULD be weird things
left behind.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> drop database <db>
> should delete it from sql catalog and remove the data file from disk.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
database[vbcol=seagreen]
file?[vbcol=seagreen]
>|||Just drop the database it will delete related files.
If database is offline only in that case you have to manually delete
files.
Then restore databse.
Regards
Amish Shah|||The only thing I can think of is backup history in the msdb database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"HK" <replywithingroup@.notreal.com> wrote in message
news:0OHWf.17622$w86.15212@.tornado.socal.rr.com...
> So no extra cleanup steps needed? I imagine there COULD be weird things
> left behind.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> database
> file?
>|||when you drop a database through EM it will ask to delete history about
backup and restore.
If you drop database using TSQL you will have to delete history
maually.
Regards
Amish Shah

Can I delete a DB and add it back under same name?

Are there any "cleaning" issues I should know about if I delete a database
in 2005, and then add it back under the same name with a newer .BAK file?
I know how to delete, and how to import a backup, but I don't know if there
are suggested cleaning steps between. Anything I should do?drop database <db>
should delete it from sql catalog and remove the data file from disk.
--
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> Are there any "cleaning" issues I should know about if I delete a database
> in 2005, and then add it back under the same name with a newer .BAK file?
> I know how to delete, and how to import a backup, but I don't know if
> there
> are suggested cleaning steps between. Anything I should do?
>|||So no extra cleanup steps needed? I imagine there COULD be weird things
left behind.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> drop database <db>
> should delete it from sql catalog and remove the data file from disk.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> > Are there any "cleaning" issues I should know about if I delete a
database
> > in 2005, and then add it back under the same name with a newer .BAK
file?
> > I know how to delete, and how to import a backup, but I don't know if
> > there
> > are suggested cleaning steps between. Anything I should do?
> >
> >
>|||Just drop the database it will delete related files.
If database is offline only in that case you have to manually delete
files.
Then restore databse.
Regards
Amish Shah|||The only thing I can think of is backup history in the msdb database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"HK" <replywithingroup@.notreal.com> wrote in message
news:0OHWf.17622$w86.15212@.tornado.socal.rr.com...
> So no extra cleanup steps needed? I imagine there COULD be weird things
> left behind.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
>> drop database <db>
>> should delete it from sql catalog and remove the data file from disk.
>> --
>> -oj
>>
>> "HK" <replywithingroup@.notreal.com> wrote in message
>> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
>> > Are there any "cleaning" issues I should know about if I delete a
> database
>> > in 2005, and then add it back under the same name with a newer .BAK
> file?
>> > I know how to delete, and how to import a backup, but I don't know if
>> > there
>> > are suggested cleaning steps between. Anything I should do?
>> >
>> >
>>
>|||when you drop a database through EM it will ask to delete history about
backup and restore.
If you drop database using TSQL you will have to delete history
maually.
Regards
Amish Shah