if you are creating a new SQL server and you are going to not use the 5 instances then the easist way to move DB's would be to dettach them from...

The best thing I found for this problem is to set up a mainatain plan that runs every night. make sure you optimise the database. tick the 'Remove unused space...

thanks for your help. seems to be coming up now, and have checked the machine to ensure that the disk is not corrupt

Yes I had it turn on, but as you pointed out there is no way of fixing them if they happen apart from restoring from back up. Lost a whole...

I rebooted the server. thought that might help, but even though it didn't have suspect in brackets next to the database, it kept giving me a error 927.  "database thought...

You might need to consider if your log file /recovery plan is correct. do you need it on full, you might find it easier to have it on bulked log...

yes ran the sp_resetstatus, but the database is still not letting me attach to it through query anaylsis. saying that 'database status marked are suspect by recovery' (it doesn't say...