Wednesday

SharePoint Content DataBase default locations

SharePoint Content Database default locations:

When new databases are created, SharePoint uses the default SQL Server location. This is typically the “C:\Program Files\MS SQL\Data” folder.

Some organizations may use RAID or SAN storage which may have different locations, e.g. “D:\Database”.
Within SharePoint you don’t have the option of specifying where the data and log files for the databases are created.

There are couple of steps involved in changing this default location for new databases.
For existing database you need to “DETACH” and “ATTACH” the data and log files.