Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I restore a database to SQL server
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00819430
Message ID:
00819540
Views:
7
Hi Wayne,

>It looks like you are trying to restore a sql2k backup to sql7. Can't do that.

You are correct. 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 are 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 runing the SP_ATTACH_DB from query analyzer, I would appreciate it.
Previous
Reply
Map
View

Click here to load this message in the networking platform