Backup SQL Server 2000 and 2005

Good morning,
I am with some questions concerning Backup of SQL Server 2000 and 2005.
First, I would like to know whether performing the backup Full, it is done
automatically backup of the Transaction Log? And if it is truncate it?
Or whether it is in fact necessary to perform a backup of the transaction
log specific?
Secondly, I would like to know about the differential backup. If after the
Full on Monday, I made a backup differential on Tuesday and on Wednesday, if
I have a problem on Wednesday to Thursday. It will be necessary to restore
the backup only Full of Monday and differential backup of Wednesday? Or will
it restore the backup of Differential Tuesday to restore the backup
differential of Wednesday?
Thank you,
Sincerely,
Ralph Haddad> First, I would like to know whether performing the backup Full, it is done
> automatically backup of the Transaction Log? And if it is truncate it?
TLOG is also being backuped ,however BACKUP does not truncate it

> Or whether it is in fact necessary to perform a backup of the transaction
> log specific?
You have to read about different RECOVERY models in the BOL to understand it

> Secondly, I would like to know about the differential backup. If after the
> Full on Monday, I made a backup differential on Tuesday and on Wednesday,
> if
> I have a problem on Wednesday to Thursday. It will be necessary to restore
> the backup only Full of Monday and differential backup of Wednesday? Or
> will
> it restore the backup of Differential Tuesday to restore the backup
> differential of Wednesday?
Please read BOL
"Ralph Haddad" <RalphHaddad@.discussions.microsoft.com> wrote in message
news:9FFC41F2-AF47-49D1-8E42-192BBA170A5B@.microsoft.com...
> Good morning,
> I am with some questions concerning Backup of SQL Server 2000 and 2005.
> First, I would like to know whether performing the backup Full, it is done
> automatically backup of the Transaction Log? And if it is truncate it?
> Or whether it is in fact necessary to perform a backup of the transaction
> log specific?
> Secondly, I would like to know about the differential backup. If after the
> Full on Monday, I made a backup differential on Tuesday and on Wednesday,
> if
> I have a problem on Wednesday to Thursday. It will be necessary to restore
> the backup only Full of Monday and differential backup of Wednesday? Or
> will
> it restore the backup of Differential Tuesday to restore the backup
> differential of Wednesday?
> Thank you,
> Sincerely,
> Ralph Haddad
>|||Answers are below:
Ekrem ?nsoy
"Ralph Haddad" <RalphHaddad@.discussions.microsoft.com> wrote in message
news:9FFC41F2-AF47-49D1-8E42-192BBA170A5B@.microsoft.com...
> Good morning,
> I am with some questions concerning Backup of SQL Server 2000 and 2005.
> First, I would like to know whether performing the backup Full, it is done
> automatically backup of the Transaction Log? And if it is truncate it?
> Or whether it is in fact necessary to perform a backup of the transaction
> log specific?
BACKUP DATABASE would not truncate T-Log. You need to perform a BACKUP LOG
to truncate T-Log. And to reduce your T-Log' s size you'll need to use
Shrinking. (don't use this unless necessary)

> Secondly, I would like to know about the differential backup. If after the
> Full on Monday, I made a backup differential on Tuesday and on Wednesday,
> if
> I have a problem on Wednesday to Thursday. It will be necessary to restore
> the backup only Full of Monday and differential backup of Wednesday? Or
> will
> it restore the backup of Differential Tuesday to restore the backup
> differential of Wednesday?
Restore the full backup you take on Monday and restore the lastest
differential backup only.

> Thank you,
> Sincerely,
> Ralph Haddad
>