help restoring .bak file from MSDE

J

jodoroberthost

Guppy
Hi, does anyone know if I can restore a .bak file that was created by an application running on MSDE to SQL 2000? I can restore the .bak to the original application but when I try to restore it to SQL 2000 only the system information gets restored, none of the data tables.

Thanks
 
MSDE should restore, are you sure you have the database with the data tables? I have seen some MSDE databases using the actual system databases to store their data, not a very good way to do it but I have seen this in the past.
 
Thanks Stephen,
Thanks for the suggestion, I checked all of the system tables and none of them house the application data. I tried to restore the file again attached is the error that I get.

Thanks.
 
Thanks for your help. About an hour ago, I was able to get a copy of the msde.mdf file. I just attached it to SQL server and it seems to have all of the data that I expected to see.

Robert
 
It sounds like it may be a table ownership or permissions matter if you can see the data there in the raw but not after restored.
 
You must log in or register to reply here.
Back
Top