• If memory serves -- and it's been a loooong time -- the detach-attach functionality only arrived with SQL 7.

    So you're stuck with Restore Database.

    First, create an new, empty db.

    I think this is the 6.5 syntax:

    RESTORE DATABASE <newDB>

    FROM DISK="<backup file path>"

    WITH REPLACE