Restoring orphaned Fortress Database files

[Nidonocu]

While upgrading to SQL Server 2008 Express, I suffered a number of problems which resulted in me having to uninstall SQL and reinstall it from scratch. Once this was done though, I'm not sure how to reintegrate my Fortress database back in to the main installation.

My previous install and Fortress database files are safe and sound at: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

The new installation and the new master databases and so on are at: C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA

Since this is express edition, I currently don't have management studio available (its not released yet for express edition). How can I restore the database?

[Beth]

You might want to check out the SQL command line.
With that, you should be able to run a typical restore command such as:

Code: Select all

RESTORE DATABASE sgvault
FROM DISK = 'C:\somepath\sgvault.bak'
WITH MOVE 'sgvault' to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DAT\sgvault.mdf',
     MOVE 'sgvault_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DAT\sgvault_log.ldf'  

You would also need to restore the sgmaster database and sgdragnet databases in the same manner.

[Nidonocu]

Thanks for the help, however, since it was mdf and ldf files I needed to restore from, using the RESTORE command wouldn't work. I was not aware of this command line utility though and further searching allowed me to use the Method One listed here to import my existing database files.

Thanks all the same.

[Beth]

Ohhhh, ok. Then there should be an attach command. Here's a MSDN article that should help: How to: Attach a Database File to SQL Server Express