Support Analyst’s Talk

last night, PM ask me to check an error message like this “An error has occurred in the **** Application. Error details:

System.Data.SqlClient.SqlException: Database ‘****’ is in restricted mode. Only the database owner and members of the dbcreator and sysadmin roles can access it. ”

So I fired up SQL Managment studio and saw all db under that server was marked as “restrcited to user”(something like that , not exactly I remember). AFter I check with team mate who is located in India, was told he was doing restoring work of one of db on the server. After restoring is done, he will put them back to normal.

Hi XXX, Thank you for giving us the permission to check! From our XXXX prospective, I can confirm that our applications have nothing to do with these DTS packages on  the XXXX server. But for other application outside our support scope, I am afraid we are unable to indentify.  Please don’t be hesitate to let us know if there is anything else we can help you with.

Comment from my manager:

Sounds good. I can see there is some improvement. Keep it up.