May 6, 2011 at 1:09 pm
Hello Guys,
I was trying to find the log file location which has the configuration change information for SQL Server.
Example: this would have information for the server level changes which include creating/deleting Databases, creating/deleting Login, Changing Max degree of parallelism settings and so on.
Can anyone help me with this information.
Thanks,
Nikhil
May 6, 2011 at 3:00 pm
creating\dropping objects will be in the default trace.
some server configuration changes will be in the errorlog but not exactly sure which will or won't be.
If this is SQL2008 you could set up auditing.
---------------------------------------------------------------------
May 7, 2011 at 3:21 am
Just right click on the Instance and then generate the SCHEMA CHANGES Report as shown in the figures
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 7, 2011 at 4:34 pm
I don't believe that configuration changes are in the schema changes report.You want the Configurations Changes History report.
May 9, 2011 at 12:39 am
yes this report also available at the same process which one i have mentioned in the previous answer
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 9, 2011 at 5:54 am
without auditing I do not belive there is any one place you can pull this information from. The trouble with the built in reports is that they are not available if the instance is not running, so if you wanted this information because your server had died you'd be out of luck.
I'd probably set some server triggers to write to a table or a flat file with the events you wanted. I'm sure there's various ways to approach this.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply