I been restoring database from our Production server every morning from last 3 years. Suddenly database in restoring stage since this morning. I've been try to bring online but there no success. Also I drop the database at destination and try manually restoring DB but still giving me a below error.
I've make sure .BAK file is there on source server or production server.
Any idea what's causing this?
RESTORING BACKUP FILE FROM \h4\E$\Database_Backups\X01\X01_backup_2021_03_01_020001_4627658.bak
Msg 3203, Level 16, State 1, Line 37
Read on "\64\E$\Database_Backups\X01\X01_backup_2021_03_01_020001_4627658.bak" failed: 2(The system cannot find the file specified.)
Msg 3013, Level 16, State 1, Line 37
RESTORE DATABASE is terminating abnormally.
Msg 5052, Level 16, State 1, Line 46
ALTER DATABASE is not permitted while a database is in the Restoring state.
Msg 5069, Level 16, State 1, Line 46
ALTER DATABASE statement failed.