Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql script to find which user started restore and stopped while database was restoring in sql server 2008 Expand / Collapse
Author
Message
Posted Friday, March 12, 2010 9:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 1, 2011 3:13 AM
Points: 139, Visits: 282
hi,

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

Thanks in advance
Post #881915
Posted Friday, March 12, 2010 2:21 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 8:36 AM
Points: 822, Visits: 1,205
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.
Post #882142
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse