I resolved the error.It was symantec. Their antivirus application was causing the problem. Once I disabled, everything worked fine. I had to uninstall the antivirus, reinstall and apply some patches.

Space is not the issue as I have terrabytes of data available on my SAN. Anything else?

It was my own bad; I got cocky and rushed through it by stopping and starting SQL Server prior to attaching the database! I am still kicking myself 🙂

Thanks! Let me know if I can ever be of help to you'll.

Anyone know what the minimum bare bones rights are if you are scrutinizing security to make SQL Server hum!!

yes this will work. First, run sp_dropserver 'server name' then run

sp_addserver 'server name' , local.

Stop and restart Mssql service and sql agen service.

Run Select @@servername and this will display your...