July 20, 2012 at 12:15 pm
Hi,
A DoD STIG audit was run on our databases. The audit stated that our .mdf and .ldf files should be separated from each other. For example, each .mdf file should have its own folder. Likewise, each .ldf file. Everything must be separated. So I shut down the SQL Server, moved every .mdf file to its own folder, and moved each .ldf to its own folder. Then I attempted to restart the SQL Server -- it did not work! So I started playing around with the DefaultData and DefaultLog Server parameters. I noticed that SQL Server does not have a separate setting for each database (all the .mdf files have to be located in the DefaultData directory and all the .ldf files have to be located in the DefaultLog directory). So my question is, is there a way to separate the .mdf and .ldf files so that each file has its own folder?
July 20, 2012 at 12:42 pm
This thread should help. http://www.sqlservercentral.com/Forums/Topic1013558-146-1.aspx#bm1013569
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 20, 2012 at 3:09 pm
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply