Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    1

    Unanswered: Help needed to restore SQL Database

    Hi Gurus,

    Can anyone assist?

    How to recover the database if I have only the current transaction log and a older version of .mdf & .ldf files. No backup had being performed via Enterprise Manager.

    I have installed MSSQL2000 on Windows 2003 Server. Created a new database 'sample' and inserted some data into the 'sample' db. Afterwhich, I offline the 'sample' db and copied the .mdf & .ldf to another backup directory.

    Restart the database by bring it online again and continue to insert more data ... (approx 100,000 rows of data).

    Afterwhich, I tried to damage the running database .mdf file and the database went into offline / suspect mode.

    How can I recovered to the point in time of failure based on just current transactional log & older version of .mdf & .ldf files?

    Can any gurus out there advises?

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    If you have not been making backups, you will not be able to recover to a point in time. Recovering to a point in time requires that the database be in the 'Full' recovery model and that you make periodic full backups combined with transaction log backups. The best that you *might* be able to do in this scenario is to perform a single file attach (see sp_attachdb).

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •