Log

I backup the sql data file(log size is 30GB(30GB is used, 0 is unused).) I
think i just the data only, not include log.
Then i get that backup data file to the other sql server machine to restone
once i finish to restore, the log size is also restored to 30GB as well. but
(1G used, 29 unused)
why will have this result?Restore of a full db backup restores all files as they were present at the
time of the backup. If you want to shring log, use DBCC SHRINKFILE command.
Do please llok for the syntax in Books OnLine.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Inamori" <test@.test.com> wrote in message
news:ue9BS5OsEHA.2612@.TK2MSFTNGP10.phx.gbl...
> I backup the sql data file(log size is 30GB(30GB is used, 0 is unused).) I
> think i just the data only, not include log.
> Then i get that backup data file to the other sql server machine to
restone
> once i finish to restore, the log size is also restored to 30GB as well.
but
> (1G used, 29 unused)
> why will have this result?
>
>|||the point is orginial is 30GB(30GB is used, 0 is unused
new restore one is (1G used, 29 unused)
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:#2tasAPsEHA.3564@.tk2msftngp13.phx.gbl...
> Restore of a full db backup restores all files as they were present at the
> time of the backup. If you want to shring log, use DBCC SHRINKFILE
command.
> Do please llok for the syntax in Books OnLine.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Inamori" <test@.test.com> wrote in message
> news:ue9BS5OsEHA.2612@.TK2MSFTNGP10.phx.gbl...
> > I backup the sql data file(log size is 30GB(30GB is used, 0 is unused).)
I
> > think i just the data only, not include log.
> >
> > Then i get that backup data file to the other sql server machine to
> restone
> >
> > once i finish to restore, the log size is also restored to 30GB as well.
> but
> > (1G used, 29 unused)
> >
> > why will have this result?
> >
> >
> >
> >
>|||> the point is orginial is 30GB(30GB is used, 0 is unused
> new restore one is (1G used, 29 unused)
Did you use Enterprise Manager t do the full db backup? If you llok at the
Options tab when using EM backup, you will see by default a checked checkbox
near the "Remove inactive entries from transaction log" option.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||thanks thanks
I got it...
yes it is checked
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eyNTNLPsEHA.2664@.TK2MSFTNGP12.phx.gbl...
> > the point is orginial is 30GB(30GB is used, 0 is unused
> >
> > new restore one is (1G used, 29 unused)
> Did you use Enterprise Manager t do the full db backup? If you llok at the
> Options tab when using EM backup, you will see by default a checked
checkbox
> near the "Remove inactive entries from transaction log" option.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>