[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Full DB backup

Prince

3/28/2007 6:32:00 AM

Hi,
Does full DB backup in SQL 2005 includes trans log backup too? if yes does
the trans logs are truncated @ server?

thanks and regards
prince
4 Answers

Uri Dimant

3/28/2007 6:55:00 AM

0

prince

FULL db backup does not truncate LOG file





"prince" <prince@discussions.microsoft.com> wrote in message
news:2AA89C76-39B0-4093-B78D-E945739F54D6@microsoft.com...
> Hi,
> Does full DB backup in SQL 2005 includes trans log backup too? if yes does
> the trans logs are truncated @ server?
>
> thanks and regards
> prince


Alejandro Mesa

3/28/2007 1:48:00 PM

0

prince,

Yes, It include transaction log backup but it does not truncate the log. You
need to backup the transaction log in order to truncate it (reuse inactive
part).


AMB


"prince" wrote:

> Hi,
> Does full DB backup in SQL 2005 includes trans log backup too? if yes does
> the trans logs are truncated @ server?
>
> thanks and regards
> prince

Steen Schlüter Persson (DK)

3/28/2007 8:09:00 PM

0

Alejandro Mesa wrote:
> prince,
>
> Yes, It include transaction log backup but it does not truncate the log. You
> need to backup the transaction log in order to truncate it (reuse inactive
> part).
>
>

I think it's a matter of interpretation to say that a FULL backup also
include a Transaction Log backup..:-). The only part of the transaction
log that's being backed up during a FULL database backup, is that part
needed in order to recreate the log file during a restore and then the
changes that has been done in the database between the start and end of
the full backup.
In general, I think it's more correct to say that a FULL backup doesn't
backup the TLog.

--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

mesaalejandro

3/29/2007 12:15:00 AM

0

Steen Schlüter Persson (DK),

You are right that it could lead to misinterpretation, so I am posting the
link to the BOL. I want to remark this part:

*****
You can re-create a whole database in one step by restoring the database
from a full database backup to any location. Enough of the transaction log
is included in the backup to let you recover the database to the time when
the backup finished. When the database is recovered, uncommitted
transactions are rolled back. The restored database matches the state of the
original database when the restored backup finished, minus any uncommitted
transactions.
*****

Full Database Backups
http://msdn2.microsoft.com/en-us/library/ms1...


Thanks for your comment,

AMB


""Steen Schlüter Persson (DK)"" <steen@REMOVE_THIS_asavaenget.dk> wrote in
message news:eThesTXcHHA.648@TK2MSFTNGP04.phx.gbl...
> Alejandro Mesa wrote:
>> prince,
>>
>> Yes, It include transaction log backup but it does not truncate the log.
>> You need to backup the transaction log in order to truncate it (reuse
>> inactive part).
>>
>>
>
> I think it's a matter of interpretation to say that a FULL backup also
> include a Transaction Log backup..:-). The only part of the transaction
> log that's being backed up during a FULL database backup, is that part
> needed in order to recreate the log file during a restore and then the
> changes that has been done in the database between the start and end of
> the full backup.
> In general, I think it's more correct to say that a FULL backup doesn't
> backup the TLog.
>
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator