MSDE 2000 on a Domain Controller

Hello everyone, I have searched the forum regarding this topic and have found numerous good threads about installing SQL Express on a DC. My question is, I am assuming that if installing SQL Express on a Domain Controller is not recommended, that installing the MSDE 2000 on a Domain Controller is not recommended either?

Thanks in advance to all replies!

Tim

Yes, it is not recommended.

However, Microsoft Small Business Server does make an exception and install MSDE (previous versions of SBS) or SQL Express on the DC.

The primary reason for the current recommendation is due to traffic. For MSDE, it was for security and traffic.

|||

Thanks Arnie, that is what I thought.

Tim

msdbdata.mdf file is over 5 GB, cannot shrink it

I have problem with my sql server developer edition.

I began reciving alerts regarding disk space, and found out that the msdb files are 5 GB!!! the data file is full, so I cannot shrink it, but the table usage shows only a few MB used by tables.

its not advisable to shrink the system dbs except tempdb,but in your case just check if any user tables are created in msdb if so just delete the same to free diskspace.... then try shrinking msdb but b4 shrinking ensure you have the latest backup of all the dbs....
|||

There are no user tables on this server.

It a local developer version, I use for development and small checks, there is no back up nither.