when I complete full database backup ,
I want to know this full backup file includes transanction log ?lovexueer@.gmail.com wrote:
> when I complete full database backup ,
> I want to know this full backup file includes transanction log ?
No, the contents of the transaction log is not included in a full
backup. Only the current state (of all data, indexes, as well as the
other objects) is included.
However, when restoring a full backup, the transaction log file is
expanded to the size it was when the backup was taken (so this may make
you think the transaction log was actually restored, when it in fact
was not).
Razvan|||This is a multi-part message in MIME format.
--000301030603010101030205
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
lovexueer@.gmail.com wrote:
> when I complete full database backup ,
> I want to know this full backup file includes transanction log ?
>
Short answer - No.
You'll have to do a seperate log backup in order to get your logfile
backed up - if you need it. If your database is in SIMPLE recovery mode,
you don't need the log backup and SQL server won't let you back it up
either.
When that's said, SQL server do backup a little part of the logfile
during a FULL backup, but it's only so much that it can recreate the
logfile when you restore the backup.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--000301030603010101030205
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:lovexueer@.gmail.com">lovexueer@.gmail.com</a> wrote:
<blockquote
cite="mid1152689474.604519.28620@.m79g2000cwm.googlegroups.com"
type="cite">
<pre wrap="">when I complete full database backup ,
I want to know this full backup file includes transanction log ?
</pre>
</blockquote>
<font size="-1"><font face="Arial">Short answer - No. <br>
You'll have to do a seperate log backup in order to get your logfile
backed up - if you need it. If your database is in SIMPLE recovery
mode, you don't need the log backup and SQL server won't let you back
it up either.<br>
<br>
When that's said, SQL server do backup a little part of the logfile
during a FULL backup, but it's only so much that it can recreate the
logfile when you restore the backup.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
<br>
</font></font>
</body>
</html>
--000301030603010101030205--|||Steen Persson (DK) wrote:
> lovexueer@.gmail.com wrote:
> > when I complete full database backup ,
> >
> > I want to know this full backup file includes transanction log ?
> >
> >
> Short answer - No.
> You'll have to do a seperate log backup in order to get your logfile
> backed up - if you need it. If your database is in SIMPLE recovery mode,
> you don't need the log backup and SQL server won't let you back it up
> either.
> When that's said, SQL server do backup a little part of the logfile
> during a FULL backup, but it's only so much that it can recreate the
> logfile when you restore the backup.
>
> --
> Regards
> Steen Schl=FCter Persson
> Databaseadministrator / Systemadministrator
>
> --000301030603010101030205
> Content-Type: text/html; charset=3DISO-8859-1
> X-Google-AttachSize: 1148
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <meta content=3D"text/html;charset=3DISO-8859-1" http-equiv=3D"Content-=Type">
> </head>
> <body bgcolor=3D"#ffffff" text=3D"#000000">
> <a class=3D"moz-txt-link-abbreviated" href=3D"mailto:lovexueer@.gmail.com"=>lovexueer@.gmail.com</a> wrote:
> <blockquote
> cite=3D"mid1152689474.604519.28620@.m79g2000cwm.googlegroups.com"
> type=3D"cite">
> <pre wrap=3D"">when I complete full database backup ,
> I want to know this full backup file includes transanction log ?
> </pre>
> </blockquote>
> <font size=3D"-1"><font face=3D"Arial">Short answer - No. <br>
> You'll have to do a seperate log backup in order to get your logfile
> backed up - if you need it. If your database is in SIMPLE recovery
> mode, you don't need the log backup and SQL server won't let you back
> it up either.<br>
> <br>
> When that's said, SQL server do backup a little part of the logfile
> during a FULL backup, but it's only so much that it can recreate the
> logfile when you restore the backup.<br>
> <br>
> <br>
> -- <br>
> Regards<br>
> Steen Schlüter Persson<br>
> Databaseadministrator / Systemadministrator<br>
> <br>
> </font></font>
> </body>
> </html>
> --000301030603010101030205--
thank you very much ,
but what is a little part of logfile?|||It records the transactions from the log that occured while the backup was
taking place. This ensures the backup is complete and up to date when it
finishes.
"lovexueer@.gmail.com" wrote:
> Steen Persson (DK) wrote:
> > lovexueer@.gmail.com wrote:
> > > when I complete full database backup ,
> > >
> > > I want to know this full backup file includes transanction log ?
> > >
> > >
> > Short answer - No.
> > You'll have to do a seperate log backup in order to get your logfile
> > backed up - if you need it. If your database is in SIMPLE recovery mode,
> > you don't need the log backup and SQL server won't let you back it up
> > either.
> >
> > When that's said, SQL server do backup a little part of the logfile
> > during a FULL backup, but it's only so much that it can recreate the
> > logfile when you restore the backup.
> >
> >
> > --
> > Regards
> > Steen Schlüter Persson
> > Databaseadministrator / Systemadministrator
> >
> >
> > --000301030603010101030205
> > Content-Type: text/html; charset=ISO-8859-1
> > X-Google-AttachSize: 1148
> >
> > <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> > <html>
> > <head>
> > <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
> > </head>
> > <body bgcolor="#ffffff" text="#000000">
> > <a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:lovexueer@.gmail.com">lovexueer@.gmail.com</a> wrote:
> > <blockquote
> > cite="mid1152689474.604519.28620@.m79g2000cwm.googlegroups.com"
> > type="cite">
> > <pre wrap="">when I complete full database backup ,
> >
> > I want to know this full backup file includes transanction log ?
> >
> > </pre>
> > </blockquote>
> > <font size="-1"><font face="Arial">Short answer - No. <br>
> > You'll have to do a seperate log backup in order to get your logfile
> > backed up - if you need it. If your database is in SIMPLE recovery
> > mode, you don't need the log backup and SQL server won't let you back
> > it up either.<br>
> > <br>
> > When that's said, SQL server do backup a little part of the logfile
> > during a FULL backup, but it's only so much that it can recreate the
> > logfile when you restore the backup.<br>
> > <br>
> > <br>
> > -- <br>
> > Regards<br>
> > Steen Schlüter Persson<br>
> > Databaseadministrator / Systemadministrator<br>
> > <br>
> > </font></font>
> > </body>
> > </html>
> >
> > --000301030603010101030205--
>
> thank you very much ,
> but what is a little part of logfile?
>|||Steen Persson (DK) wrote:
> > When that's said, SQL server do backup a little part of the logfile
> > during a FULL backup, but it's only so much that it can recreate the
> > logfile when you restore the backup.
lovexueer@.gmail.com wrote:
> but what is a little part of logfile?
The part which contains the transactions executed between the start of
the backup process and the end of it (usually this is several seconds
or minutes, depending on the size of the database).
Razvan|||Razvan Socol wrote:
> Steen Persson (DK) wrote:
> > > When that's said, SQL server do backup a little part of the logfile
> > > during a FULL backup, but it's only so much that it can recreate the
> > > logfile when you restore the backup.
> lovexueer@.gmail.com wrote:
> > but what is a little part of logfile?
> The part which contains the transactions executed between the start of
> the backup process and the end of it (usually this is several seconds
> or minutes, depending on the size of the database).
> Razvan
I meant that the part contains transaction log is drity pages?
the dirty pages is uncommited for datafile.|||lovexueer@.gmail.com wrote:
> Razvan Socol wrote:
> > Steen Persson (DK) wrote:
> > > > When that's said, SQL server do backup a little part of the logfile
> > > > during a FULL backup, but it's only so much that it can recreate the
> > > > logfile when you restore the backup.
> >
> > lovexueer@.gmail.com wrote:
> > > but what is a little part of logfile?
> >
> > The part which contains the transactions executed between the start of
> > the backup process and the end of it (usually this is several seconds
> > or minutes, depending on the size of the database).
> >
> > Razvan
>
> I meant that the part contains transaction log is drity pages?
> the dirty pages is uncommited for datafile.
The transaction log pages that are contained in a full backup, may or
may not be committed in the actual backup file. In other words, they
were not committed to the data file when the backup was started, but
they were committed to the data file (or should have been committed,
i.e. they were dirty pages) when the backup was finished. Since it's
not clear if the those data pages were copied in the backup file before
or after they were modified, the log pages are stored in the backup
file too, so when the backup is restored, the database can be recovered
in a consistent state.
Razvan|||Razvan Socol wrote:
> lovexueer@.gmail.com wrote:
> > Razvan Socol wrote:
> > > Steen Persson (DK) wrote:
> > > > > When that's said, SQL server do backup a little part of the logfile
> > > > > during a FULL backup, but it's only so much that it can recreate the
> > > > > logfile when you restore the backup.
> > >
> > > lovexueer@.gmail.com wrote:
> > > > but what is a little part of logfile?
> > >
> > > The part which contains the transactions executed between the start of
> > > the backup process and the end of it (usually this is several seconds
> > > or minutes, depending on the size of the database).
> > >
> > > Razvan
> >
> >
> >
> > I meant that the part contains transaction log is drity pages?
> > the dirty pages is uncommited for datafile.
> The transaction log pages that are contained in a full backup, may or
> may not be committed in the actual backup file. In other words, they
> were not committed to the data file when the backup was started, but
> they were committed to the data file (or should have been committed,
> i.e. they were dirty pages) when the backup was finished. Since it's
> not clear if the those data pages were copied in the backup file before
> or after they were modified, the log pages are stored in the backup
> file too, so when the backup is restored, the database can be recovered
> in a consistent state.
> Razvan
thanks great!
没有评论:
发表评论