rperry
July 19th, 2006, 12:36 AM
Our directory structure for our SQL 2000 database is as follows:
E:\SQL\%DatabaseName%\%DatabaseName%.mdf and
E:\SQL\%DatabaseName%\%DatabaseName%.ldf
We have several databases using this kind of structure. Should I exclude each .mdf and .ldf file explicitly, should I exclude E:\SQL and all subfolders/files, or can I exclude all .mdf and .ldf files in E:\SQL and subdirectories? If option 3 is possible, would you please provide the syntax used to accomplish this?
My question also applies to Exchange as I need to exclude a plethora of files, and I am not certain if I need to exclude these one at a time, exclude subdirectories, or if I can/should globally exclude file types based on extension.
Thanks in advance!
E:\SQL\%DatabaseName%\%DatabaseName%.mdf and
E:\SQL\%DatabaseName%\%DatabaseName%.ldf
We have several databases using this kind of structure. Should I exclude each .mdf and .ldf file explicitly, should I exclude E:\SQL and all subfolders/files, or can I exclude all .mdf and .ldf files in E:\SQL and subdirectories? If option 3 is possible, would you please provide the syntax used to accomplish this?
My question also applies to Exchange as I need to exclude a plethora of files, and I am not certain if I need to exclude these one at a time, exclude subdirectories, or if I can/should globally exclude file types based on extension.
Thanks in advance!