Post reply

sql script to find which user started restore and stopped while database was restoring in sql server 2008

  • March 12, 2010 at 9:28 am

    #219862

    hi,

    I need sql script to find which user started restore and stopped while database was restoring in sql server 2008.

    Thanks in advance

  • March 12, 2010 at 2:21 pm

    #1133014

    This one had me curious so I did some digging and unfortunatley cam up empty handed. You can get the spid from the SQL SERVER log if you look at the part of the log where the database cam back on line but I can not find a user id anywhere.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

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

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