My computer has the following Software involved.
- Microsoft Windows 7
- Microsoft SQL Server 2008 R2
- Microsoft SQL Server Management Studio
Moreover, I have the following Drive partitions:
- C: drive
- D: drive
- E: drive
Therefore, when I created the Database Engine, I specify that the Instance Root Directory within a directory belonging to the D: drive which means that ldf and mdf files are placed the instance root directory within the D: drive.
However, there is a problem with the setup. If I restart my computer, sometimes the Microsoft SQL Server Management Studio will see the Database Engine with the instance root directory within the D: drive but other times it won't see it. I keep restarting my computer to see if Microsoft SQL Server Management Studio sees the aforementioned Database Engine.
Why is it so unstable? Also, please tell me what steps I have to take in order to ensure Microsoft SQL Server Management Studio always sees the aforementioned Database Engine.