how do I import SQL data files to a new built SQL Server

Dear all:
My web server recently crashed on me. I have all the data file backed up (master file, Portal, etc)

Now my web server is rebuilt... but I can't seem to find a way to restore the old files from my crashed server... Any help? I tried to use the Data Transformation Service but it only has something Server <--> Server... Is there anyway to restore my old files on a new built SQL Server??

Thanks.


MOTO

How do you have your previous files "backed up"? Did you back up the Tablespace .MDF .NDF and .LDF or did you do a "Backup Database" under All Tasks?

If you did a complete backup of your database as in the latter case, you have to do a "restore Database" from the "All Tasks" context menu. Pay close attention to the file locations where the files will be restored and make sure those drives, partitions and folders exist before runnin the restore. If not, the process will fail.

If you have "backed" up the files as in the former case by simply copying the physical files to tape or another means, then you have to create a new database with the same name and attach the files. I've never done a restore or an attach so maybe someone more experienced may be able to help you with that.

Good Luck,

-Umar.

Copy your mdf and ldf files across to your new server.

Use sp_attach_db 'YourDatabaseName','fully qualified path and filename for your MDF file' , 'Fully qualified path and filename for your LDF file'

For example

sp_attach_db 'CoolSite','C:\program files\sqlserver\coolsite.mdf','C:\program files\sqlserver\coolsite_log.ldf'

Of course you will have to remap your database users to the appropriate logins.