Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL restore from DAT files
- Thread starter dante18
- Start date
tlbroadbent
MIS
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:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Thread starter
- #3
tlbroadbent
MIS
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:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
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.
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.
tlbroadbent
MIS
EM1107,
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:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
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:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Status
Similar threads
- Locked
- Question
