We have a SQL Server 2005 box running Windows Server 2003 R2 Std 64bit. We have two production databases residing on one partition (which is an iSCSI software target), that partition got apparently got corrupted and the databases are not working properly and pulling all kinds of consistency check errors.
We have created a new iSCSI target and introduced it to the SQL server as a new disk partition. we have good backups that we can use for restoration (Both native SQL backups and symantec Backup Exec backups).
The question is, how to restore these two databases to the new partition and make SQL server aware of the change?