Still have a problem?
Does this help?

RESTORE DATABASE [TESTD] FROM
DISK = 'C:\MSSQL7\BACKUP\test_backup' WITH FILE = 1,
NOUNLOAD , STATS = 10, RECOVERY , REPLACE ,
MOVE 'testerData' TO 'H:\TESTD.mdf',
MOVE 'tester_log' TO 'H:\TESTD_log.ldf'



-----Original Message-----
From: Chip Smith [mailto:[Email Address Removed] Wednesday, September 10, 2003 10:25 AM
To: LazyDBA.com Discussion
Subject: RE: Error 22274; [SQL-DMO] DB Marked Inaccessible Urgent!!!!


What were the preceding statements? Have you done 'with recovery'?


-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] Wednesday, September 10, 2003 11:21 AM
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

MS Sql Server LazyDBA home page