>Did you try sp_attach_db system sproc?
The backup file that I received is actually a SQL2k backup. I installed SQL2k and was able to restore it.
However, unlike what I thought, the 2 databases are not actually the same database. The MDF and LOG files is actually another database from a different facility which I also need to get data from. I tried to attach the database in SQL2k and it reports that it is not a valid database. I have no idea which version that these MDF and LOG files came from. It obviously was not SQL2K. I have been trying to attach these in SQL 7 but it does not have an option for attaching a database in Enterprise Manager and I have not been able to figure out how to use the SP_ATTACH_DB stored procedure to attach it. I'm not sure it it would work anyway unless it is a SQL 7 database. I suspect that it may be a SQL 6.5 Database. I'm trying to track down where this database came from. If you have any suggestions or can provide syntax example for running the SP_ATTACH_DB from query analyzer, I would appreciate it.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only