Post reply

Need to Work out How much of my BACKUP Has been restored

  • December 17, 2008 at 7:17 am

    #125097

    i'm doing a restore using the TSQL RESTORE command but forgot to add the STATS command to the SQL. The Restore is chugging a long fine but i would like to know where i can find out OR if its possible to find out how much of the restore has been done

  • December 17, 2008 at 7:38 am

    #913828

    Hi,

    Please find out the process id for which your restore is running and run the dbcc outputbuffer

    example

    say spid is 55

    dbcc outputbuffer(55)

    the output will be scrambled you have organise it and read it. ( see the text part of every line end)

  • December 17, 2008 at 9:03 am

    #913927

    thank you ...

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

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