|
Home > Archive > MS SQL Server > December 2006 > FULL and Tran Backup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
FULL and Tran Backup
|
|
| morphius 2006-12-05, 5:16 am |
| The .bak and .trn seem to eat up too much disk space. What are the best
practices? We have to have point -in- time capability so it needs to be in
Full recovery mode. How do you prevent this from crashing the server? Do i
have to buy more disk. Appreciate any advice...
| |
| Tibor Karaszi 2006-12-05, 5:16 am |
| > The .bak and .trn seem to eat up too much disk space. What are the best
> practices?
Delete the old backup files, determined by the number of backup generations you want to have on
disk. If you don't use the maint wizard, make sure that you do overwrite at suitable schedule (see
the INIT and NOINIT options to the backup command).
And, needless to say, make sure you also copy the backup files to other machine, tape and/or
offsite.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"morphius" < morphius@discussions
.microsoft.com> wrote in message
news:EFD903D5-3AD8-44E2-B7AC- 815BD14DBC94@microso
ft.com...
> The .bak and .trn seem to eat up too much disk space. What are the best
> practices? We have to have point -in- time capability so it needs to be in
> Full recovery mode. How do you prevent this from crashing the server? Do i
> have to buy more disk. Appreciate any advice...
| |
| John Bell 2006-12-05, 5:16 am |
| Hi
You don't say how long you keep the backups on disc and when it would be
acceptable to delete them. If they are stored safely elsewhere you can delete
the files but this will be at the expense of increased time needed to
recover. You will need to decide what the cut off is for this and if you
don't have enough disc space to hold that many backups, then you will need to
get more.
HTH
John
"morphius" wrote:
> The .bak and .trn seem to eat up too much disk space. What are the best
> practices? We have to have point -in- time capability so it needs to be in
> Full recovery mode. How do you prevent this from crashing the server? Do i
> have to buy more disk. Appreciate any advice...
|
|
|
|
|