I have SQL Server Standard edition (that was installed
after un-installing the Enterprise evaluation copy using
add/remove programs). On Retore screen, the option "Point
in Time' is grayed out totally. How can I make this option
usable?
Thanks.This is a multi-part message in MIME format.
--=_NextPart_000_0375_01C3B80E.61607470
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Your database must be using the Full recovery model - and you must backup
the database as well as the log. Use the STOPAT option when restoring logs.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Neeru" <anonymous@.discussions.microsoft.com> wrote in message
news:019f01c3b837$a98a48b0$a301280a@.phx.gbl...
I have SQL Server Standard edition (that was installed
after un-installing the Enterprise evaluation copy using
add/remove programs). On Retore screen, the option "Point
in Time' is grayed out totally. How can I make this option
usable?
Thanks.
--=_NextPart_000_0375_01C3B80E.61607470
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Your database must be using the Full =recovery model - and you must backup the database as well as the log. Use =the STOPAT option when restoring logs.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Neeru" wrote in message news:019f01c3b837$a9=8a48b0$a301280a@.phx.gbl...I have SQL Server Standard edition (that was installed after =un-installing the Enterprise evaluation copy using add/remove programs). On Retore =screen, the option "Point in Time' is grayed out totally. How can I make this =option usable? Thanks.
--=_NextPart_000_0375_01C3B80E.61607470--|||Thanks, Tom. I used the Maintenace Wizard to create backup
jobs. Is there an option not to use Full Recovery model?
Neeru
>--Original Message--
>Your database must be using the Full recovery model - and
you must backup
>the database as well as the log. Use the STOPAT option
when restoring logs.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Neeru" <anonymous@.discussions.microsoft.com> wrote in
message
>news:019f01c3b837$a98a48b0$a301280a@.phx.gbl...
>I have SQL Server Standard edition (that was installed
>after un-installing the Enterprise evaluation copy using
>add/remove programs). On Retore screen, the option "Point
>in Time' is grayed out totally. How can I make this option
>usable?
>Thanks.
>|||Neeru:
If you want "Point in Time" be enabled then the option "Recovery Model" of
your database must be set to "Full Recovery". To set this option using
Enterprise Manager--> (1) Right Click your database and then click
"Properties" (2) Then click "Options" set and choose "Full" as Recovery
Model.
By this......">> >Your database must be using the Full recovery model -
and you must backup the database as well as the log. >>" Tom meant to
say the same thing but I think you undertood that you are not seeing
"Point-In-Time" because your database is set to "Full Recovery"
"Neeru" <anonymous@.discussions.microsoft.com> wrote in message
news:a85a01c3b83a$629742c0$a601280a@.phx.gbl...
> Thanks, Tom. I used the Maintenace Wizard to create backup
> jobs. Is there an option not to use Full Recovery model?
> Neeru
> >--Original Message--
> >Your database must be using the Full recovery model - and
> you must backup
> >the database as well as the log. Use the STOPAT option
> when restoring logs.
> >
> >--
> >Tom
> >
> >----
> --
> >Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> >SQL Server MVP
> >Columnist, SQL Server Professional
> >Toronto, ON Canada
> >www.pinnaclepublishing.com/sql
> >
> >
> >"Neeru" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:019f01c3b837$a98a48b0$a301280a@.phx.gbl...
> >I have SQL Server Standard edition (that was installed
> >after un-installing the Enterprise evaluation copy using
> >add/remove programs). On Retore screen, the option "Point
> >in Time' is grayed out totally. How can I make this option
> >usable?
> >Thanks.
> >|||THANKS, DON and Tom.
It worked. Have a nice week.
Neeru
>--Original Message--
>Neeru:
>If you want "Point in Time" be enabled then the
option "Recovery Model" of
>your database must be set to "Full Recovery". To set this
option using
>Enterprise Manager--> (1) Right Click your database and
then click
>"Properties" (2) Then click "Options" set and
choose "Full" as Recovery
>Model.
>By this......">> >Your database must be using the Full
recovery model -
>and you must backup the database as well as the log.
>>" Tom meant to
>say the same thing but I think you undertood that you are
not seeing
>"Point-In-Time" because your database is set to "Full
Recovery"
>
>"Neeru" <anonymous@.discussions.microsoft.com> wrote in
message
>news:a85a01c3b83a$629742c0$a601280a@.phx.gbl...
>> Thanks, Tom. I used the Maintenace Wizard to create
backup
>> jobs. Is there an option not to use Full Recovery model?
>> Neeru
>> >--Original Message--
>> >Your database must be using the Full recovery model -
and
>> you must backup
>> >the database as well as the log. Use the STOPAT option
>> when restoring logs.
>> >
>> >--
>> >Tom
>> >
>> >----
--
>> --
>> >Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> >SQL Server MVP
>> >Columnist, SQL Server Professional
>> >Toronto, ON Canada
>> >www.pinnaclepublishing.com/sql
>> >
>> >
>> >"Neeru" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:019f01c3b837$a98a48b0$a301280a@.phx.gbl...
>> >I have SQL Server Standard edition (that was installed
>> >after un-installing the Enterprise evaluation copy
using
>> >add/remove programs). On Retore screen, the
option "Point
>> >in Time' is grayed out totally. How can I make this
option
>> >usable?
>> >Thanks.
>> >
>
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment