Backing up your Windows Internal Databases
by Brian on Aug.29, 2008, under Windows Info
When you install Sharepoint, or WSUS, and you have no existing SQL Server online, the installation routines will use the Windows Internal Database. This is not a problem, unless your disks are approaching their fill limits. To backup and shrink the transaction logs for the WID database, you need to install SQL Server Management Studio Express. Then, when using the management studio, the server name you connect to should be:
\.pipemssql$microsoft##sseesqlquery
Then, backup and truncate your transaction logs, and stop wasting all that disk space.
Advertisement
August 29th, 2008 on 7:42 pm
Also, when you manually truncate your logs in this manner, it will be necessary to run a full database backup before you can run a log backup again.