Restore Part of a database?

  • Is there any way to restore part of a MSDE database? I am running Windows 2000 server with MSDE. I had some problems moving a web site and had to rebuild the database from scratch. Lucky for me that the database was not that large. However, there are some items that I would like to restore from the backup. Has any one had any experience with this? Any help would be greatly appreciated.

  • You cannot restore part of a backup. However, you can create a new database to retore to (using the WITH MOVE option in RESTORE LOG process) and move the missing parts into the old database.

  • Also you could script the objects that you want to move and then imports the data of those objects.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply