Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Database Recovery

    Hi,

    Is there a way to Revover a Sql Server 2000 database in the absence of the backup file(the backup file got overwritten). Does Sql Server do any automatic Transaction logging?

    Thanks for any input

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    The short answer...you need a dump..

    Abd yes sql server is constantly creating transactions for every event (even if they're not fully logged)

    What's the problem?

    database fall down and go boom?

    Check this out:

    http://www.sqlteam.com/item.asp?ItemID=11672
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Mar 2004
    Posts
    2
    The database was overwritten with some old data and by the time this was realised the backup got overwritten with this old data. There are no transactions logs either. Only a full Database backup taken every day.

    Is there any hope of recovering at all?

    Thanks

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's your recovery model set to?

    Look at this site

    http://www.lumigent.com/
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    Lumigent LOG EXPLORER!!!!

    Probably the best third party product available for SQL Server 2000
    it has single-handedly discontinued the STOPAT clause from the BACKUP statement.

Posting Permissions

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