Windows Internal Database (or SQL Server Embedded) can be used by WSS or Windows Software Update Services (WSUS). It is well hidden and annoyingly unmanageable. By default the data files reside in a folder under the root drive in the Windows directory. This can be a bad place to allow a potentially fast growing database to reside… especially if your drives are partitioned for a small “C” drive just to be used by the operating system. I was able to find out how to move these databases pretty easily.
1. Download and install SQL Server Management Studio Express (find it here: http://tiny.cc/msssmse)
2. Turn off any services that might be using the database (SharePoint, WSUS, etc)
3. Connect to \\.\pipe\mssql$microsoft##ssee\sql\query using SSMSE named pipes
4. Detach all databases that you wish to move (check box to kill connections)
5. Move the databases and associated log files (MDF & LDF) to the desired location
6. Reattach databases in there new location
Now the databases will not hog your boot drive.
0 comments:
Post a Comment