Post reply

how to recover stored procedure from log file

  • October 15, 2010 at 6:35 am

    #388013

    I accidently dropped a stored procedure from my database and i have no back up for my database.But there is a logfile with extension .ldf for the database.can anyone please help me to find how the stored procedure can be recovered from the log file ie the .ldf file.thanks in advance

  • October 15, 2010 at 6:57 am

    #1237485

    there is no native SQL facility to do this without a backup. Investigate third party tools that may be able to extract data out of logs. Although as the command would have just 'drop proc' the code of the stored procedure is probably not recoverable.

    Please start taking backups immediately. Do you have a source code repository of any kind?

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply