Backup Planning SQL2000

Hi i have implemented this backup strategy :
1 - 00:00 AM Backup FULL "myDB"
2 - 06:00 AM Backup T-LOG Overwrite and "NO" to Remove inactive entries
from Transaction Log
3 - 12:00 PM Backup T-LOG Overwrite and "NO" to Remove inactive entries
from Transaction Log
4- 18:00 PM Backup T-LOG Overwrite and "Yes" to Remove inactive entries
from Transaction Log
Shrink T-LOG
My Rocovery model for "MyDB"is "Full"
If my DB crash at 14:00 PM may i restore a FULL Backup of my DB (at 00:00
time) and restore a backup of T-LOg (at 12:00) and recover all information
from 00:00 AM to 12:00 PM ?!'!
In to Job 4 is corrected that i backup my T-LOG with "Remove inactive
entries from Transaction Log" enable and in the same job (after backup) i
shrink t-log ro recover a space ?
Thanks in advance.I would go for the following option
00:00 Full backup
06:00 Log backup - The log is backed up from the last successfully
executed log backup or full backup to the current end of the log. Once the
log is backed up the space may be truncated when no longer required by a
transaction or replication.
12:00 Log backup
If @. 14:00 the system crashes I will restore the full backup followed by
6:00 and 12:00 logs. (This way the transaction log remais small and do not
have to shrink)
Other option could be
00:00 Full backup
06:00 Differential
12:00 Differential
If @. 14:00 the system crashes, I would restore Full backup and 12:00 copies.
I am not sure as to why you would like to specifically want to keep inactive
transactions.
HTH.
Bhanu.
.
<io.com> wrote in message news:#x3hNATtEHA.2516@.TK2MSFTNGP11.phx.gbl...
> Hi i have implemented this backup strategy :
> 1 - 00:00 AM Backup FULL "myDB"
> 2 - 06:00 AM Backup T-LOG Overwrite and "NO" to Remove inactive entries
> from Transaction Log
> 3 - 12:00 PM Backup T-LOG Overwrite and "NO" to Remove inactive entries
> from Transaction Log
> 4- 18:00 PM Backup T-LOG Overwrite and "Yes" to Remove inactive entries
> from Transaction Log
> Shrink T-LOG
>
> My Rocovery model for "MyDB"is "Full"
> If my DB crash at 14:00 PM may i restore a FULL Backup of my DB (at 00:00
> time) and restore a backup of T-LOg (at 12:00) and recover all
information
> from 00:00 AM to 12:00 PM ?!'!
> In to Job 4 is corrected that i backup my T-LOG with "Remove inactive
> entries from Transaction Log" enable and in the same job (after backup) i
> shrink t-log ro recover a space ?
> Thanks in advance.
>|||Thanks for your reply !
Sorry i have a last question :
If i backup only a datafile and the db crash may i restore a db backup and
restore a copy a .ldf file (no backup of logfile but only .ldf file) !'!?
Thanks.
"Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
news:eAdlBGUtEHA.3216@.TK2MSFTNGP15.phx.gbl...
> I would go for the following option
> 00:00 Full backup
> 06:00 Log backup - The log is backed up from the last successfully
> executed log backup or full backup to the current end of the log. Once
the
> log is backed up the space may be truncated when no longer required by a
> transaction or replication.
> 12:00 Log backup
>
> If @. 14:00 the system crashes I will restore the full backup followed by
> 6:00 and 12:00 logs. (This way the transaction log remais small and do
not
> have to shrink)
> Other option could be
> 00:00 Full backup
> 06:00 Differential
> 12:00 Differential
> If @. 14:00 the system crashes, I would restore Full backup and 12:00
copies.
>
> I am not sure as to why you would like to specifically want to keep
inactive
> transactions.
> HTH.
> Bhanu.
>
> .
>
> <io.com> wrote in message news:#x3hNATtEHA.2516@.TK2MSFTNGP11.phx.gbl...
entries[vbcol=seagreen]
00:00[vbcol=seagreen]
> information
i[vbcol=seagreen]
>|||No. Make certain you do frequent enough transaction log backups. If the data
base crashes, what you
do, if possible, is to do a *backup* of the log after the database crash. Re
ad about the NO_TRUNCATE
option to the BACKUP LOG command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<io.com> wrote in message news:e71Ua$UtEHA.904@.TK2MSFTNGP11.phx.gbl...
> Thanks for your reply !
> Sorry i have a last question :
> If i backup only a datafile and the db crash may i restore a db backup and
> restore a copy a .ldf file (no backup of logfile but only .ldf file) !'!?
> Thanks.
> "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> news:eAdlBGUtEHA.3216@.TK2MSFTNGP15.phx.gbl...
> the
> not
> copies.
> inactive
> entries
> 00:00
> i
>|||<io.com> wrote in message news:%23x3hNATtEHA.2516@.TK2MSFTNGP11.phx.gbl...
> Hi i have implemented this backup strategy :
> 1 - 00:00 AM Backup FULL "myDB"
> 2 - 06:00 AM Backup T-LOG Overwrite and "NO" to Remove inactive entries
> from Transaction Log
> 3 - 12:00 PM Backup T-LOG Overwrite and "NO" to Remove inactive entries
> from Transaction Log
> 4- 18:00 PM Backup T-LOG Overwrite and "Yes" to Remove inactive entries
> from Transaction Log
> Shrink T-LOG
Besides other comments, I'd skip the "Shrink T-LOG" step. Only thing it
really can do is lead to fragmentation of the disk.

>
> My Rocovery model for "MyDB"is "Full"
> If my DB crash at 14:00 PM may i restore a FULL Backup of my DB (at 00:00
> time) and restore a backup of T-LOg (at 12:00) and recover all
information
> from 00:00 AM to 12:00 PM ?!'!
> In to Job 4 is corrected that i backup my T-LOG with "Remove inactive
> entries from Transaction Log" enable and in the same job (after backup) i
> shrink t-log ro recover a space ?
> Thanks in advance.
>