who did that?

  • How can i find who restored the database?

  • Don't think you can later. They might be the owner of the database if they used their account. If they used something like sa, there's no way. Might see an NT login in the security log if they used the console.

  • Hi,

    May be you check the table: msdb..restorehisory. It holds the information like the date of restoration, which login was it done from, destination databases etc.,

    Renuka__

    [font="Verdana"]Renuka__[/font]

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

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