sql server moved database files now it says recovery pending
Posted on 2012-12-29
I moved my database files from my C drive to my J drive, then ran this code to move the database locations. It appeared to work, but my databases all say "Recovery Pending". If I try to open one, I get an error that says The database HOD200301 is not accessible. (ObjectExplorer).
How can I fix this?
ALTER DATABASE HOD200203 MODIFY FILE (NAME = HOD200203 , FILENAME = 'J:\OptionDB\HOD200203.mdf ');
ALTER DATABASE HOD200203 MODIFY FILE (NAME = HOD200203_log , FILENAME = 'J:\OptionDB\HOD200203_log.ldf ');