I need your help,
i was moving th MDF file to a newly added drive, the steps i follw was:
1. bring DB ofline
2. Copy MDF file to new Drive
3. Bring Db online.
4. RUN (
USE master GO ALTER DATABASE TEST MODIFY FILE (NAME = test, FILENAME = 'F:\SQL data\test.mdf') GO)
5. Restart SQL services.
now after all this step i found my database goes to suspect mode, can anybody tell me the reason/step i missed and the how to resolve.
error from sql log:
The log scan number (856823:4733:134) passed to log scan in database 'UPSInvite' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf).