RE: Unable to backup a log
From: Kumar Part (Part_at_discussions.microsoft.com)
Date: 10/05/04
- Next message: Kumar Part: "RE: MS SQL Standard Edition Memory."
- Previous message: ddavids_at_idfbins.com: "MS SQL Standard Edition Memory."
- In reply to: Richard Brown: "Unable to backup a log"
- Next in thread: Hari Prasad: "Re: Unable to backup a log"
- Reply: Hari Prasad: "Re: Unable to backup a log"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 5 Oct 2004 16:09:06 -0700
Richard,
When you change the recovery model from simple to full, you need to backup
the entire database first before you attempt to backup the log
-kumar
"Richard Brown" wrote:
> SQL Server 2000. Have a full database backup from a few
> days ago (using "simple" recovery model). Also have a
> large log (76 megs) that hasn't been shrunk. I need to
> restore to a point in time. Enterprise Manager wouldn't
> let me select the "log file backup" option, so I tried
> changing the database to the "full" recovery model, and
> then detached/reattached the database. It then let me
> select the option to backup just the log, but it's not
> backing up the entire log, just a few K of data. Is there
> any way to backup the entire log and then restore and roll
> forward to a point, or am I out of luck? Thanks.
>
- Next message: Kumar Part: "RE: MS SQL Standard Edition Memory."
- Previous message: ddavids_at_idfbins.com: "MS SQL Standard Edition Memory."
- In reply to: Richard Brown: "Unable to backup a log"
- Next in thread: Hari Prasad: "Re: Unable to backup a log"
- Reply: Hari Prasad: "Re: Unable to backup a log"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
