November 7, 2012 at 1:23 am
My database not accepting any alter command to bring it back online.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
November 7, 2012 at 1:32 am
kapfundestanley (11/7/2012)
My database not accepting any alter command to bring it back online.
What is the error it shows?
For bring the DB online. use the online option in a alter statement.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 7, 2012 at 1:35 am
What is the state of the database? (state_desc in sys.databases)
What happened to cause this?
What errors are there in the error log?
Do you have backups?
Do not detach the DB. Do not restart SQL.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply