March 9, 2009 at 9:18 am
Hi Everyone
I am looking for a tool to audit my SQL Database, I mean When was the last time it was copied?, where was copied my DB?, Who was the last user to access the database? Who were the last users that access the database?,etc.
Could you help me and tell me waht tool should i use to my needs?
Regards
melvin
March 9, 2009 at 12:22 pm
I'm not sure that there is a tool for SQL Server that would show when a user copied your database. If the SQL Server is running and the database is attached you cannot copy it as it is "in use". You would need to disconnect all the users, detach the database, copy the file(s), and then re-attach the database.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply