OS: Windows 7 Professional
Database: SQL Server 2008 R2 Standard Edition
Just detected by SpaceMonger that, each of my databases on test instance has three copies of data files (.mdf) and log files (.ldf).
they are located at three folders:
- ..\Microsoft SQL Server\Mssql10_50.test\Mssql\Data
and they have exactly same file size and timestamp.
I confirmed that I have no mirroring setup for any of my databases, neither do I have any special setup to enforce the database to have files splitted.
The only suspicious setting I can find is:
the first two locations are the server level database default location (right click server in the MSSMS -> Properties -> Database Settings -> Database default locations): the first is for Data while the second is for Log,
and the last is each database's file location appearing in the MSSMS (right click a database -> Properties -> Files -> Database Files)
This annoying problem has made my server available disk space very low and forced me to do housekeeping very often.
any idea why does this happen?
any methodology i can follow to find out what has been wrong?
-- EDIT ---
Thank you all for the comments and reply.
We have identified the problem - not related to the sql database setting, but the folders themselves: the three folders have a setup to mirror each other. we have got our network team to investigate why it's so.