Performing a database restore along with export and import.

Scenario:
Multiple parent portals (separate domains); one DNN install, one database instance

The need to restore; one client's portal ..major discrepancies on edits and whatever other bad thing that can happen from the day before

No problem, database is in Full mode with full database, differential and transaction log backups hourly.

However, a restore to a point in time yesterday will also rollback previous edits of other clients (portals) which would result in an administrative nightmare for those clients not to mention some fancy dancing by me. Not a real good option for all.

Would this be possible :
Export all portals (except the portal of issue)
Perform restore to point of good for the one portal
Import back all portals

Would this work in theory ?

barry

Richard's suggestion will be the best.  Get a copy of the whole db, restore it to the last known good point, export that template then import with replace on.  Extra pages may be present when youre done if they were added after the roll back time.

---

Philip Beadle - Employee

It wont help you now but the www.evotive.com solution I've been told handles separate portals for backup and restore.  Im trying to verify that now.

---

Philip Beadle - Employee