A Windows Server 2000 SQL server running SQL 2000 experienced a motherboard failure with onboard RAID. The data has been backup up using Backup Exec 10d. This includes all SQL databases, drives, and System State. Luckily the day before they had backup the production database directly from the sqldata folder onto a hard drive which is what I loaded on another Server 2000 box running SQL2000. This loaded just fine by attaching the database. We now need the non production databases that were backed up on TAPE. I tried doing a SQL redirect restore to the temp SQL box, but it keeps failing saying the Agent is not available. It seems to keep looking for the old SQL box. Can I grab the database .ldf and .mdf files which I can easily attach to the running SQL server as I did with the hard drive files? Hopefully simply attaching databases like that is OK?
Your assistance is most appreciated as I am not very good at SQL and BE working together.