Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-03-08 : 17:50:21
|
| We have several users who has the access to backup the database on the instance and want to know who took it.How to find who has taken the backup on investigation?is there any methodology to find the program / person.Thanks All. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-08 : 18:30:57
|
| select * from msdb.dbo.backupset where database_name='myDatabase'There's a column in there for user_name, and some others that might help. |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-03-08 : 23:12:58
|
| Thanks for that, however, I have done with this query but wanted specific user who has done and deleted that backup file.Any Clues. Many thanks again. |
|
|
|
Yeoh Ray Mond
Starting Member
49 Posts |
Posted - 2011-03-08 : 23:47:13
|
| The backup history tables in msdb only store details of the backup e.g. type of backup, when it was made, who did it, backup file names etc. It won't store details on who deleted your backup files.Ray MondRESTORE VERIFYONLY - don't bet your job on it! Learn why here.TLogInfo - the only FREE tool to analyse your transaction logs. Download here..SQLBakReader - the only FREE tool to inspect your SQL Server backup files without using SQL Server. Download here.. |
|
|
|
|
|
|
Backup Date find