Hey all,
I know *.BAK and *.TRN files are backups and logs. But it is ok to delete
them if you are running server backup IE Using Arcserve.
We seem to be constantly running out of space on your drives so I have been
so far moving the BAK and TRN files to different disks but as you can imagine
this cant continue for too long.
We have 20Gb of data on 1 drive, but the BAK and TRM files are another 10gbs
this seems huge to me, as the drive is only 29 Gb.
A friend mentioned that you shouldn't limit the size of the TRN logs as your
only shooting yourself inthe foot should the db go down, but at this Im going
to have to start getting new disks to hold the increasing amounts.
Anyone any ideas of what I can do, is it ok to delete these files or limit
the growth all together, say to a Gb a DB ?
ThanksYes, you have to delete old backup files. Determine a strategy for how long to keep them, and with
this, consider hoe you store these files on tape.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Adrian" <Adrian@.discussions.microsoft.com> wrote in message
news:03BB4744-B688-4190-9220-17993AEB37BB@.microsoft.com...
> Hey all,
> I know *.BAK and *.TRN files are backups and logs. But it is ok to delete
> them if you are running server backup IE Using Arcserve.
> We seem to be constantly running out of space on your drives so I have been
> so far moving the BAK and TRN files to different disks but as you can imagine
> this cant continue for too long.
> We have 20Gb of data on 1 drive, but the BAK and TRM files are another 10gbs
> this seems huge to me, as the drive is only 29 Gb.
> A friend mentioned that you shouldn't limit the size of the TRN logs as your
> only shooting yourself inthe foot should the db go down, but at this Im going
> to have to start getting new disks to hold the increasing amounts.
> Anyone any ideas of what I can do, is it ok to delete these files or limit
> the growth all together, say to a Gb a DB ?
> Thanks
Showing posts with label trn. Show all posts
Showing posts with label trn. Show all posts
Tuesday, March 20, 2012
BAK, TRN files
Hey all,
I know *.BAK and *.TRN files are backups and logs. But it is ok to delete
them if you are running server backup IE Using Arcserve.
We seem to be constantly running out of space on your drives so I have been
so far moving the BAK and TRN files to different disks but as you can imagin
e
this cant continue for too long.
We have 20Gb of data on 1 drive, but the BAK and TRM files are another 10gbs
this seems huge to me, as the drive is only 29 Gb.
A friend mentioned that you shouldn't limit the size of the TRN logs as your
only shooting yourself inthe foot should the db go down, but at this Im goin
g
to have to start getting new disks to hold the increasing amounts.
Anyone any ideas of what I can do, is it ok to delete these files or limit
the growth all together, say to a Gb a DB ?
ThanksYes, you have to delete old backup files. Determine a strategy for how long
to keep them, and with
this, consider hoe you store these files on tape.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Adrian" <Adrian@.discussions.microsoft.com> wrote in message
news:03BB4744-B688-4190-9220-17993AEB37BB@.microsoft.com...
> Hey all,
> I know *.BAK and *.TRN files are backups and logs. But it is ok to delete
> them if you are running server backup IE Using Arcserve.
> We seem to be constantly running out of space on your drives so I have bee
n
> so far moving the BAK and TRN files to different disks but as you can imag
ine
> this cant continue for too long.
> We have 20Gb of data on 1 drive, but the BAK and TRM files are another 10g
bs
> this seems huge to me, as the drive is only 29 Gb.
> A friend mentioned that you shouldn't limit the size of the TRN logs as yo
ur
> only shooting yourself inthe foot should the db go down, but at this Im go
ing
> to have to start getting new disks to hold the increasing amounts.
> Anyone any ideas of what I can do, is it ok to delete these files or limit
> the growth all together, say to a Gb a DB ?
> Thanks
I know *.BAK and *.TRN files are backups and logs. But it is ok to delete
them if you are running server backup IE Using Arcserve.
We seem to be constantly running out of space on your drives so I have been
so far moving the BAK and TRN files to different disks but as you can imagin
e
this cant continue for too long.
We have 20Gb of data on 1 drive, but the BAK and TRM files are another 10gbs
this seems huge to me, as the drive is only 29 Gb.
A friend mentioned that you shouldn't limit the size of the TRN logs as your
only shooting yourself inthe foot should the db go down, but at this Im goin
g
to have to start getting new disks to hold the increasing amounts.
Anyone any ideas of what I can do, is it ok to delete these files or limit
the growth all together, say to a Gb a DB ?
ThanksYes, you have to delete old backup files. Determine a strategy for how long
to keep them, and with
this, consider hoe you store these files on tape.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Adrian" <Adrian@.discussions.microsoft.com> wrote in message
news:03BB4744-B688-4190-9220-17993AEB37BB@.microsoft.com...
> Hey all,
> I know *.BAK and *.TRN files are backups and logs. But it is ok to delete
> them if you are running server backup IE Using Arcserve.
> We seem to be constantly running out of space on your drives so I have bee
n
> so far moving the BAK and TRN files to different disks but as you can imag
ine
> this cant continue for too long.
> We have 20Gb of data on 1 drive, but the BAK and TRM files are another 10g
bs
> this seems huge to me, as the drive is only 29 Gb.
> A friend mentioned that you shouldn't limit the size of the TRN logs as yo
ur
> only shooting yourself inthe foot should the db go down, but at this Im go
ing
> to have to start getting new disks to hold the increasing amounts.
> Anyone any ideas of what I can do, is it ok to delete these files or limit
> the growth all together, say to a Gb a DB ?
> Thanks
Monday, February 13, 2012
backup when trn. is going on
Hi everybody,
Is there any way to back Database when transcations are going on?sql server backups are designed in such a way that they can be run at any time against the database and or the transaction log.
you can perform a database backup from the enterprise manager or from the query analyzer.
Instructions are at the bottom of the following books online topic.
Books Online {Database Backups}
Is there any way to back Database when transcations are going on?sql server backups are designed in such a way that they can be run at any time against the database and or the transaction log.
you can perform a database backup from the enterprise manager or from the query analyzer.
Instructions are at the bottom of the following books online topic.
Books Online {Database Backups}
Backup TRN file issue
Hi at all, i'm new of this NG :=)
My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
trn but SQL doesn't delete the TRN files "older than x days" while it
deletes the other older file, so it make my disk full in a few days...
There is a patch for this?
I checked the parameters of the job and they are correct...
Any solutions?
Many thanks
Hi
The file is only deleted xx days after you specify, but the same Maintenance
Wizard need to run to do it.
e.g.
Full Backup on 1 January 2005 with setting of delete after 5 days (5x24
hours, no 5 actual days).
The same job only runs again on 7 January 2005. The file will only get
removed on 7 January as that is when the same job runs again.
If the job was run on 5 January, the file would get deleted, and as long as
the job runs at the same time, or slightly later.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Macchianera" <424invalid@.mynewsgate.net> wrote in message
news:20050923094911424@.mynewsgate.net...
> Hi at all, i'm new of this NG :=)
> My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
> trn but SQL doesn't delete the TRN files "older than x days" while it
> deletes the other older file, so it make my disk full in a few days...
> There is a patch for this?
> I checked the parameters of the job and they are correct...
> Any solutions?
> Many thanks
>
My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
trn but SQL doesn't delete the TRN files "older than x days" while it
deletes the other older file, so it make my disk full in a few days...
There is a patch for this?
I checked the parameters of the job and they are correct...
Any solutions?
Many thanks
Hi
The file is only deleted xx days after you specify, but the same Maintenance
Wizard need to run to do it.
e.g.
Full Backup on 1 January 2005 with setting of delete after 5 days (5x24
hours, no 5 actual days).
The same job only runs again on 7 January 2005. The file will only get
removed on 7 January as that is when the same job runs again.
If the job was run on 5 January, the file would get deleted, and as long as
the job runs at the same time, or slightly later.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Macchianera" <424invalid@.mynewsgate.net> wrote in message
news:20050923094911424@.mynewsgate.net...
> Hi at all, i'm new of this NG :=)
> My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
> trn but SQL doesn't delete the TRN files "older than x days" while it
> deletes the other older file, so it make my disk full in a few days...
> There is a patch for this?
> I checked the parameters of the job and they are correct...
> Any solutions?
> Many thanks
>
Sunday, February 12, 2012
Backup TRN file issue
Hi at all, i'm new of this NG :=)
My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
trn but SQL doesn't delete the TRN files "older than x days" while it
deletes the other older file, so it make my disk full in a few days...
There is a patch for this?
I checked the parameters of the job and they are correct...
Any solutions?
Many thanksHi
The file is only deleted xx days after you specify, but the same Maintenance
Wizard need to run to do it.
e.g.
Full Backup on 1 January 2005 with setting of delete after 5 days (5x24
hours, no 5 actual days).
The same job only runs again on 7 January 2005. The file will only get
removed on 7 January as that is when the same job runs again.
If the job was run on 5 January, the file would get deleted, and as long as
the job runs at the same time, or slightly later.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Macchianera" <424invalid@.mynewsgate.net> wrote in message
news:20050923094911424@.mynewsgate.net...
> Hi at all, i'm new of this NG :=)
> My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
> trn but SQL doesn't delete the TRN files "older than x days" while it
> deletes the other older file, so it make my disk full in a few days...
> There is a patch for this?
> I checked the parameters of the job and they are correct...
> Any solutions?
> Many thanks
>
My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
trn but SQL doesn't delete the TRN files "older than x days" while it
deletes the other older file, so it make my disk full in a few days...
There is a patch for this?
I checked the parameters of the job and they are correct...
Any solutions?
Many thanksHi
The file is only deleted xx days after you specify, but the same Maintenance
Wizard need to run to do it.
e.g.
Full Backup on 1 January 2005 with setting of delete after 5 days (5x24
hours, no 5 actual days).
The same job only runs again on 7 January 2005. The file will only get
removed on 7 January as that is when the same job runs again.
If the job was run on 5 January, the file would get deleted, and as long as
the job runs at the same time, or slightly later.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Macchianera" <424invalid@.mynewsgate.net> wrote in message
news:20050923094911424@.mynewsgate.net...
> Hi at all, i'm new of this NG :=)
> My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
> trn but SQL doesn't delete the TRN files "older than x days" while it
> deletes the other older file, so it make my disk full in a few days...
> There is a patch for this?
> I checked the parameters of the job and they are correct...
> Any solutions?
> Many thanks
>
Backup TRN file issue
Hi at all, i'm new of this NG :=)
My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
trn but SQL doesn't delete the TRN files "older than x days" while it
deletes the other older file, so it make my disk full in a few days...
There is a patch for this?
I checked the parameters of the job and they are correct...
Any solutions?
Many thanksHi
The file is only deleted xx days after you specify, but the same Maintenance
Wizard need to run to do it.
e.g.
Full Backup on 1 January 2005 with setting of delete after 5 days (5x24
hours, no 5 actual days).
The same job only runs again on 7 January 2005. The file will only get
removed on 7 January as that is when the same job runs again.
If the job was run on 5 January, the file would get deleted, and as long as
the job runs at the same time, or slightly later.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Macchianera" <424invalid@.mynewsgate.net> wrote in message
news:20050923094911424@.mynewsgate.net...
> Hi at all, i'm new of this NG :=)
> My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
> trn but SQL doesn't delete the TRN files "older than x days" while it
> deletes the other older file, so it make my disk full in a few days...
> There is a patch for this?
> I checked the parameters of the job and they are correct...
> Any solutions?
> Many thanks
>
My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
trn but SQL doesn't delete the TRN files "older than x days" while it
deletes the other older file, so it make my disk full in a few days...
There is a patch for this?
I checked the parameters of the job and they are correct...
Any solutions?
Many thanksHi
The file is only deleted xx days after you specify, but the same Maintenance
Wizard need to run to do it.
e.g.
Full Backup on 1 January 2005 with setting of delete after 5 days (5x24
hours, no 5 actual days).
The same job only runs again on 7 January 2005. The file will only get
removed on 7 January as that is when the same job runs again.
If the job was run on 5 January, the file would get deleted, and as long as
the job runs at the same time, or slightly later.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Macchianera" <424invalid@.mynewsgate.net> wrote in message
news:20050923094911424@.mynewsgate.net...
> Hi at all, i'm new of this NG :=)
> My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
> trn but SQL doesn't delete the TRN files "older than x days" while it
> deletes the other older file, so it make my disk full in a few days...
> There is a patch for this?
> I checked the parameters of the job and they are correct...
> Any solutions?
> Many thanks
>
Subscribe to:
Posts (Atom)