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?
Best Answer
When you're restoring the database go to the Options and edit the Restore as field.
You can manually enter here where do you want data and log files to be (change the default location it gives you to the new disk partition).
The picture is from SQL express 2008R2 but it's the same for 2005