Restore LDF File

From: Chadha (Anuj_Chadha_at_hotmail.com)
Date: 05/06/04 

Date: 6 May 2004 10:43:11 -0700

Hi,

I am new to SQL Server and am trying to restore my database.

I have a an MDF file and a "backup" of the LDF file, created by
Backing up transaction logs.

>From what i understand I can attach my database from an MDF file,
however it also requires a valid LDF file, however I have the backup
of the LDF file. Is there anyway to restore the LDF file to its normal
format and then attach the database.

Am I on the right path?

Thanks.

Anuj.

Relevant Pages

  • Re: What is LOP_SHRINK_NOOP
    ... The ldf file is about 100Mb after months and never grows large. ... I add nightly backup to the system using DBCC backup. ... you need to have every transaction log backup since the last FULL Backup in order to successfully recover the database. ...
    (comp.databases.ms-sqlserver)
  • Flat File Backup Failed *suddenly*
    ... DB: SQL Server 2000 SP3a ... I have a database maintenanec plan set up to do full database backup (i.e. ... I have a DB which has a 3.8GB LDF file which backup with no problems!) ...
    (microsoft.public.sqlserver.server)
  • Flat File Backup Failed *suddenly*
    ... DB: SQL Server 2000 SP3a ... I have a database maintenanec plan set up to do full database backup (i.e. ... I have a DB which has a 3.8GB LDF file which backup with no problems!) ...
    (microsoft.public.sqlserver.server)
  • Re: POINT IN TIME RESTORE
    ... I have a perfefctly good database with a .mdf and a .ldf file. ... recovery model is FULL. ... And I try to restore using the cdoe I have seen here before.. ...
    (microsoft.public.sqlserver.server)
  • Re: .LDF files and SharePoint Portal
    ... So when you take a backup of the database, ... I have some questions about .LDF files and Sharepoint. ... Is it safe to delete the data in the .LDF file or will it cause ...
    (microsoft.public.sharepoint.portalserver)
Loading