Sunday, February 12, 2012

Can I manually delete .bak files?

I'm running a SQL 2000 server and have a maintenance plan that does complete
backups daily, with a 10 day retention on files.
For some reason, I have .bak files that go back as far as January on several
databases, which is an issue in and of itself.
My question is, are all of the .bak files independent of each other and can
I safely delete older ones without affecting the more recent backups?
Thanks you,
Larry
Are we talking about database or log backups?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C86E6A38-8449-4ADB-8F5D-0559B676AB16@.microsoft.com...
> I'm running a SQL 2000 server and have a maintenance plan that does complete
> backups daily, with a 10 day retention on files.
> For some reason, I have .bak files that go back as far as January on several
> databases, which is an issue in and of itself.
> My question is, are all of the .bak files independent of each other and can
> I safely delete older ones without affecting the more recent backups?
> Thanks you,
> Larry
|||Database, not transaction.
"Tibor Karaszi" wrote:

> Are we talking about database or log backups?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Larry" <Larry@.discussions.microsoft.com> wrote in message
> news:C86E6A38-8449-4ADB-8F5D-0559B676AB16@.microsoft.com...
>
|||A more recent db backup is not dependent on an earlier db backup. However if you need to do point in
time restore to some point between the earlier and the more recent db backup and you also have log
backups covering that period, then you want to save the earlier db backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:D06E7454-66E6-4153-8EFA-3B7A0FF7C62E@.microsoft.com...[vbcol=seagreen]
> Database, not transaction.
> "Tibor Karaszi" wrote:

No comments:

Post a Comment