September 19, 2011 at 12:46 am
Database is on Recovery pending mode since yesterday.
When try to set databases online state it throws the error below:-
SQL VERSION SQL2005 ENTERPRISE.
the other
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Databasename.mdf". Operating system error 2: "2(The system cannot find the file specified.)".
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "L:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dcx_BI_Staging_1.ldf". Operating system error 5: "5(Access is denied.)".
File activation failure. The physical file name "L:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Databasename.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 1
Database 'dcx_BI_Staging' 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
ALTER DATABASE statement failed.
September 19, 2011 at 3:01 am
Do those two files exist? Does SQL have full permission to them?
Recovery Pending means SQL can't start the DB due to missing files (or a few other reasons). It's not a state that the DB will come out of by itself.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2011 at 12:01 am
Just do another restore with the "Move file" option. Alternatively you can do a restore from any other DB backup, just to get the database back to a usable state and then do your original restore using the above option.
If all else fail, do a restore from a small backup file (backup of any db), delete the database and do a clean restore from your original backup.
July 11, 2012 at 1:43 pm
Its a permission issue on Drive...
July 12, 2012 at 3:30 am
Cheetah (9/21/2011)
Just do another restore with the "Move file" option. Alternatively you can do a restore from any other DB backup, just to get the database back to a usable state and then do your original restore using the above option.If all else fail, do a restore from a small backup file (backup of any db), delete the database and do a clean restore from your original backup.
Hi this worked thanks to all of you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply