We have a database named 'lime' which became corrupt after a data import on Monday.
Path to the files is
I moved the lime_Data.MDF & lime_Data.LDF files to another location before restoring previous copy of the files from the image backup tape made on Friday into E:\MSSQL Server\Data\MSSQL\Data\
Now when use the SQL manager it shows lime(suspect). I tried putting back Modays files but still get the same 'suspect' mark on the database
Obviously moving the files and replacing them with previous ones has caused a problem. How can I get SQL to accept the files from Friday. (or any of the files!!)