We backed up our sql 7 database on Win NT4 to tape using CA Brightstore & SQL Agent, and also backed up the database to another file server using the backup within sql.
We upgraded the os on the sql server to Server 2000 leaving the original data on the original drives. We renames the data folders to xxxold and reinstalled sql7. we tried to import the database from tape which failed with a tape error and then tried to restore from the backup made to the file server which also failed.
We still have all the origional files in a folder xxxold. Can we restore or import the databases and dts to the new installation of sql