Hiya,
Are there any conditions under which a database administrator is not able to
bring a database back online when it is (Suspect\offline)? The System Admin
istrator had no problem bringing it back online but the usual dba got a perm
issions error.
Thanks!I have had that occur a few times for no apparent reason. I think it is rela
ted to the reason that it went offline in the first place.|||Just verify that this dba has the necessary perimissions to this database.
If this dba is the dbo of the database or is a member of the sysadmin role
there should be no problem.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Showing posts with label hiya. Show all posts
Showing posts with label hiya. Show all posts
Thursday, February 16, 2012
bring online - any restrictions?
Labels:
administrator,
back,
conditions,
database,
hiya,
microsoft,
mysql,
offline,
online,
oracle,
restrictions,
server,
sql,
suspect
Subscribe to:
Posts (Atom)