Bring SQL Server database online
sql-server, sql-server-2008-r2
Solution
I think you're going to need to login with the SA account, or some other account with sysadmin privileges, and then run your code to put it back online. While you're in there, add sysadmin to your account, too. If you don't own the database, you may need to talk to someone else to get the SA password, or ask them to do it for you. Unless you don't have the SA password or it's been dumbed down for security reasons.
Problem
I executed the task `Take offline` of a SQL Server 2008 R2 database. I cant bring it online! I tried with ``` USE master; GO ALTER DATABASE [DBNAME] SET ONLINE ``` I get an error. User does not have permission to alter database 'DBNAME', the database does not exist, or the database is not in a state that allows access checks. I also tried using the task `Bring online` and I get the exact same error. Can anyone help me asap?