I have database with mdf and ldf file residing on external drive. There was a long powercut and the database restarted. Now the database has gone for recovery pending. The database is around 600 gb.
I have tried the following commands
ALTER DATABASE ‘DATBASE NAME’ SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE ‘DATBASE NAME’ SET ONLINE WITH ROLLBACK IMMEDIATE
but i am getting the following error
Msg 5120, Level 16, State 101, Line 4 Unable to open the physical file "G:\SQL_DATA\TEST_NEW.mdf". Operating system error 5: "5(Access is denied.)". File activation failure. The physical file name "G:\SQL_DATA\TEST_NEW_log.ldf" may be incorrect. Msg 5181, Level 16, State 5, Line 4 Could not restart database "TEST_NEW". Reverting to the previous status. Msg 5069, Level 16, State 1, Line 4 ALTER DATABASE statement failed.
I have tried all options.
Do any body has a working solution. Please share it will save my day.