I am recovering some suspect databases, and I ran into an interesting problem. I basically can't recover the suspect databases by using sp_resetstatus (it doesn't help). I am trying to detach the databases, then attach them using sp_attach_single_file_db. This works for databases that only have an .mdf and a .ldf (the log file is created when the command is run). My problem is, how do you do this procedure if you have multi-file databases (a .mdf file, one or more .ndf files, and an .ldf file)? There should be something like "attach data files only" in addition to sp_attach_single_file_db.
The problems we are experiencing occured byfore last night's backups, so I will have to roll to Monday Night's backups, losing all of yesterdays work unless I can attach these databases without log files. Any help would be greatly appreciated.