none
Is it possible to recover data

    Question

  • Hi I was busy doing a merge replication and the job stopef with error no activity has been written in the last 10min. My subscriber database however all the data has been whiped out is it possible to recover that data?

    Regards Ismail

    Wednesday, November 21, 2012 5:00 PM

Answers

  • Not without a backup.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    Wednesday, November 21, 2012 5:13 PM
  • There are some utilites like  RedGate’s SQL Log Rescue and ApexSQL’s ApexSQL Log . Please note i didnot use these tools anytime but these are some tools i got to know through forums & newsletters ...

     

    If you have any perfect backup statergy then it will be quiet easy :

    1.Backup the tail of the transaction log using normal BACKUP LOG syntax, and specifying WITH NORECOVERY. For further detail see Tail-Log Backups on MSDN.
    2.Restore your most recent full backup, making sure to specify NORECOVERY.
    3.Restore the most recent differential backup, also specifying NORECOVERY.
    4.Restore each transaction log backup taken since the last full or differential backup.

    -----------------------------------

    Thanks,Suhas Vallala

    Wednesday, November 21, 2012 6:33 PM

All replies

  • Not without a backup.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    Wednesday, November 21, 2012 5:13 PM
  • what's is you backup plan for these database? You need check your backup plan & schedule to have latest backup for recovery.

    No direct way recovering database.


    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Wednesday, November 21, 2012 6:17 PM
  • There are some most commonly used utilites like  RedGate’s SQL Log Rescue and ApexSQL’s ApexSQL Log . Please note i didnot use these tools anytime but these are some tools ig ot to know through forums ...

    If you have any perfect backup statergy then it will be quiet easy :

    1.Backup the tail of the transaction log using normal BACKUP LOG syntax, and specifying WITH NORECOVERY. For further detail see Tail-Log Backups on MSDN.
    2.Restore your most recent full backup, making sure to specify NORECOVERY.
    3.Restore the most recent differential backup, also specifying NORECOVERY.
    4.Restore each transaction log backup taken since the last full or differential backup.

    -----------------------------------

    Thanks,Suhas Vallala

    Wednesday, November 21, 2012 6:31 PM
  • There are some utilites like  RedGate’s SQL Log Rescue and ApexSQL’s ApexSQL Log . Please note i didnot use these tools anytime but these are some tools i got to know through forums & newsletters ...

     

    If you have any perfect backup statergy then it will be quiet easy :

    1.Backup the tail of the transaction log using normal BACKUP LOG syntax, and specifying WITH NORECOVERY. For further detail see Tail-Log Backups on MSDN.
    2.Restore your most recent full backup, making sure to specify NORECOVERY.
    3.Restore the most recent differential backup, also specifying NORECOVERY.
    4.Restore each transaction log backup taken since the last full or differential backup.

    -----------------------------------

    Thanks,Suhas Vallala

    Wednesday, November 21, 2012 6:33 PM