How were the .bak files created? It sounds kind of like you have files that are named .bak, but are actually just the scripted schema of the database, not actual backups. How are you restoring them?
Restoring a backup in a hosted situation is not necessarily the best thing, as usually you are most likely going to have a different database username, and objects that were owned by the database user (not dbo) in your original db will now be owned by a user that user that doesn't exist on the new box. Also, the restore is something that the hosting company would most likely have to do, assuming this is a shared SQL Server. If you have direct access to the database, I would look at DTS for transferring the objects and data...in enterprise manager, right click on your original database, and go to All Tasks/Export Data. -jim On 2/24/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > I am migrating sites from one hosting company to another. I had my MS SQL > '.bak' files restored but it only made the tables. All content is missing. > Repeated the .bak restore and got same results. Two questions: > What am I doing wrong in the .bak restore? > and ... > If the tables are fine, what other method do you advise for migrating the > content into the tables? > > Thank you all, your help is most appreciated. > > Steve > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233416 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
