Cannot bring db "online" after taking offline

1

So, I took MS SQL Server DB offline. Now I am trying to bring it online and get error:

TITLE: Microsoft.SqlServer.Smo

Set offline failed for Database 'zzz'.

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft_SQL_Server&ProdVer=16.100.46041.41_(SMO-master-A)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Set_offline+Database&LinkId=20476


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

User does not have permission to alter database 'zzz', the database does not exist, or the database is not in a state that allows access checks.
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 5011)

katit2
질문됨 3년 전698회 조회
2개 답변
1

Found. Should run special command, SSMS won't do:

EXEC rdsadmin.dbo.rds_set_database_online <Name of database>

katit2
답변함 3년 전
0

Thanks for posting your fix! worked for me

Luke
답변함 3달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인