Re: Unable to backup a log

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 10/06/04 

Date: Tue, 5 Oct 2004 21:00:27 -0500

Hi,

To rebuild the backup chain, after the recovery model change from SIMPLE to
FULL recovery model you need to do a full database backup followed with
transaction log backup.

Thanks
Hari
MCDBA

"Kumar Part" <Kumar Part@discussions.microsoft.com> wrote in message
news:4CFF20CC-1DEC-460D-849B-804492E237F9@microsoft.com...
> 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.
>>

Relevant Pages

  • Re: ReportIoError when performing backup - what can be done?
    ... > On 2 previous occasions, and the last weekend, the transaction log on the ... > perform a full database backup after each change of recovery mode. ... did you shrink the transaction log after truncate? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Shrink issue
    ... I'm running a full database backup nightly, and my recover mode is full as ... well in SQL. ... I'm using Symantec Backup exec 11D to do the backup's. ... Logs grow until you make a database backup. ...
    (microsoft.public.sqlserver.tools)
  • Re: General Question - May Be Silly.
    ... You need to use a database backup first (i.e. using SQL ... Server tools maybe) to a hard disk on the server. ... WSS FAQ at http://wss.collutions.com ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Detaching and Attaching a Databases
    ... redo and undo phases and you will need to run another FULL backup before you can start the log backups. ... to continue restore the transaction log files made on SQL2008? ... I made a full database backup. ... I made transaction log backups every hour. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL restore table / rollback / undo table drop without backups?
    ... If you never did a database backup, then your chances are very slim, because you don't have anything to "hang" your current log backup on. ... If you ever did a database backup, then you can perform a log backup now, then restore your database backup and all subsequent log backups, but stop before this accident. ...
    (microsoft.public.sqlserver.programming)