by kad1r
30. January 2010 09:58
My database take offline itself and I can't change its situation. I restart sql server and sql service but still not working. Then I found a easy and short way. Write this code for take it online. After it goes online immediately take a backup ;)
sp_dboption 'your_db_name','offline','false'
False means it's online, true means it's offline.