Have you been able to find a resolution to cleaning the worm or a way of pinpointing what machines are infected and which aren't?

This has never happened before but it seems to be working properly now. I don't know why this happened or what occured there.

Neil

There was nothing else to say. I ended up restarting the full text indexing service and its working now?! Weird....

I was looking for a more automated process. There are 110 databases on there.

The good news is it looks like a physical memory issue. We replaced RAM...

I would like to know if there is an easy way to move all the user and databases to another SQL server. Is there s big migration tool that...

Anything else that would detect problems and fix corruption?

I have a couple more DB's in suspect states 🙁

Neil

Its not on a domain. The user didn't matter. After a few reboots it started working. Something is really wrong with the install. It has about...

I did our admin user and local system and neither worked!!! There has to be some corruption somewhere in there... 🙁

Neil

I am having real problems with this server. I get this error in my logs when I try to start the agent.

SQLServerAgent could not be started (reason: SQLServerAgent must...

If they are db_ddladmin of their DB then there shouldn't be security implications on other DB's and the entire server, correct?

By giving db_ddladmin are there any security implications?

Thanks,

Neil

I keep getting:

BackupDiskFile::RequestDurableMedia: failure on backup device '\\Neil\D$\SQL\Neil\msdb\msdb_db_200208212022.BAK'. Operating system error 64(The specified network name is no longer available.).

This is a new backup server so it concerns me that...

Which logs should I be looking at?

Thanks,

Neil

I am doing a manual backup and I get the dialog box so I only see the one original error and that is it.

Thanks....

Neil

I believe so. I am backing them up again to give it a shot. I will let you know if I see that error.

Neil