Which version of SQL Server are you running? Which version of SQL Server is the source of the .DAT files? Usually, .DAT files are SQL Server 6.5 backups. You can't restore 6.5 to later versions of SQL Server. If the files are SQL 6.5 backups, then you can restore to a SQL 6.5 installation using the RETORE command. Terry L. Broadbent - DBA
Computing Links:
If it is a backup of a SQL 7 database, you can use the RESTORE command from SQL Query Analyzer to retstore the database on SQL Server 7 or 2000. You can also restore from Enterprise Manager. These operations are well described in SQL Books Online. Terry L. Broadbent - DBA
Computing Links:
There is many different way to restore a database.
One of them been using the regular restore command in Query script, the other is by using Enterprise Manager, when the database already exist.
The other way you can restore a database when you already have Dat files under SQL 7 and SQL 2000 would be to use the SP_attach_db. What that do is connect the database to your SQL server.
NOTE: you may have to recreate the users in your database in order to assigh the proper security.
If you are using SQL 6.5 what you can do after you have installed the a new version you can create a new database with the same name as the one you add before. Stop your services and replace the dat files with the one you would like to use.
Note: This process would not work under more resent version of SQL server.
You cannot restore a SQL Server database backup using sp_attach_db. Attaching databases only works with database files not SQL backup files. Terry L. Broadbent - DBA
Computing Links:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.