Great. THank you for the info.

Thank you for the link. I'm not clear if I have to uncluster first or if that was just for sql 7.0.

just the one's that apply to them.

Can you run the dbcc shrinkfile while users are accessing the database?

I ran the transaction log backup and that didn't decrease the size of the log file.

Tracy

Thank you for the article. I'm in and working!! Thank you very much....

Does it matter whether I use tcpip or named pipes to connect? The tcpip worked but here is the second part of my problem.

We have in house applications that...

Thanks...that was easy.