santhosh (6/8/2009)

---

One of my databases is in Recovery pending state. I tried to run an Alter command on the database to set it in Online state but it throws the following error.

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "G:\Data\MSSQL\Database.mdf". Operating system error 3: "3(The system cannot find the path specified.)".

File activation failure. The physical file name "G:\Data\MSSQL\Data\Database_log.ldf" may be incorrect.

Msg 945, Level 14, State 2, Line 1

Database 'Database' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

Msg 5069, Level 16, State 1, Line 1

Thanx in advance for any help !