Results 1 to 3 of 3

Thread: Restore DB from transaction log

  1. 12-12-2006, 11:26 PM #1
    tatang
    tatang is offline Registered User
    Join Date
    Dec 2006
    Posts
    1

    Restore DB from transaction log

    Dear All,

    We accidentally overwrite some data in our DB. Bad news is we never back-up our DB. However, the system are set in full-recovery mode. From website and book, i found that it's possible to recover back the data using "Recovery DB to a Point Time" but when we try it, we found that it cannot work without any backup data.

    Anyone know how to resolve this issue?

    Please kindly help.. Thanks alot!!
    Reply With Quote Reply With Quote
  2. 12-13-2006, 10:51 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    buy or download Lumingent Log Explorer.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 12-13-2006, 12:31 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    free download only works on pubs or northwind :-(
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules