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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Backup Date find

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.
Go to Top of Page

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.
Go to Top of Page

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 Mond

RESTORE 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..
Go to Top of Page
   

- Advertisement -