This is from a thread a couple of months ago.

I had a similar issue with a database that I was restoring and found a
reference on MSDN to possible workaround. Try using RESTORE DATABASE
[DatabaseName] WITH RECOVERY. This basically tells SQL Server to override
the LOADING status and complete the recovery process.

For more info, see KB article 272683.
http://support.microsoft.com/default.aspx?scid=kb;en-us;272683

Hope this helps.
Kevin Martin
Database Engineer
Multimedia Games



-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] Wednesday, September 10, 2003 12:21 PM
To: LazyDBA.com Discussion
Subject: Error 22274; [SQL-DMO] DB Marked Inaccessible Urgent!!!!


Hi all,

Please Help

We performed a redirected restore of ADILSQL DB=ABC to
DEF,
now Both the DB shows (Loading)
When we right click and select properties
we are getting the following error in ENT Manager:

error 22274 [SQLDMO] This database has been marked as
inaccessible.

Could not get property information for the database
"ABC"

please help in sovling this its very urgent

TIA

Regards
Adil

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003

MS Sql Server LazyDBA home page