Backing up your Windows Internal Databases

by 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.

:

1 Comment for this entry

  • Brian

    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.


Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

CryptedNets is proudly powered by

Entries (RSS) and Comments (RSS)
Register - Login

Visit our friends!

A few highly recommended friends...