Video Screencast Help

Exceptions for Multiple SQL Servers Advice

Created: 21 Mar 2013 | 3 comments

Currently the company is using multiple SQL servers, 2008 R2.  Basically, all the paths are the same for each server.  (table shown below)  I'm trying to create the best "KISS method centralized exceptions" as possible for the servers.  My idea is to create general SQL exceptions for the paths without the "instance name" and then create specific exceptions for those paths with the "instance name", and then assign the exceptions to a SQL Servers Group.

Any suggestions would be highly appreciated.

 

 

Instance Root Directory: 

drive letter:\Program Files\Microsoft SQL Server

System DBs

drive letter:\Database\MSSQLSERVER\DEFAULT\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

Snap Info

drive letter:\SMSQL_SnapInfo

Default Instance Database Files

drive letter:\Database\MSSQLSERVER\DEFAULT\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

Default Instance Database Log Files

driver letter:\Database\MSSQLSERVER\DEFAULT\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

Snap Info

driver letter:\SMSQL_SnapInfo

Default Instance Database Files

drive letter:\Database\MSSQLSERVER\instance name\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

Default Instance Database Log Files

drive letter:\Database\MSSQLSERVER\ instance name \MSSQL10_50.MSSQLSERVER\MSSQL\DATA

Snap Info

drive letter:\SMSQL_SnapInfo

Default Instance Database Files

drive letter:\Database\MSSQLSERVER\ instance2 name \MSSQL10_50.MSSQLSERVER\MSSQL\DATA

Default Instance Database Log Files

drive letter:\Database\MSSQLSERVER\ instance2 name \MSSQL10_50.MSSQLSERVER\MSSQL\DATA

 

Operating Systems:

Comments 3 CommentsJump to latest comment

.Brian's picture

Moving them into their own group is ideal here. There is also a brief list of some exclusions here

http://www.sqlcoffee.com/Tips0009.htm

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

SMLatCST's picture

As the majority of your exceptions appear to be for the contents of the SQL data directories, I think it'd be easier if you were to add exceptions by file extension instead.

That way, regardless of where the .mdf .ldf .ndf files are, they will be excluded from scanning.

SQL Exclusions ref:

http://support.microsoft.com/kb/309422

anderarmbitt's picture

there are some use ful advice for SQl server and i think people who work on this must take this advice for betterment of there work advice fb quotes