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  Other SQL Server Topics (2005)  Recording activity every day

Author  Topic  Rouen Starting Member 2 Posts Posted - 2010-06-03 : 08:25:53 Hi all, I'm brand new to Microsoft SQL Server 2005. I'm administrator of a lot of machines, but I don't have to bother about databases (except volumes, power, etc). Our current "real" SQL admin is so bad that I have to do some basic things for him. I just can't wait for our new SQL admin Well, my question: We need to record SQL activity each day (deleted after one week). Our SQL server is rebooted everyday because of backup (virtual machine). I currently launch SQL Server Profiler manually every morning, and start a new trace. You understand this is not the right way. I don't have a clue about how to do it correctly. I think, but I may be very wrong, I can create a trace with SQL Server Profiler, then save the settings into SQL Server. Then ask SQL Server to run it everytime it is started (with SQL Agent I presume). I searched the web for some examples about this idea, but I only found some fragments. So I'm not even sure this is the right way. Anyone can explain me even a little ?