Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Restore deleted Marketing List RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    Is it possible to restore a deleted Marketing List?

    I checked the database, then see in table ListBase, the record is marked with DeletionStateCode=2. I restore it to 0 the I got the Marketing List back, but the members won't show up.

    I also checked on table ListMemberBase, I search records with ListId just like deleted marketing list's ListId but it returned 0 record (while if checked with active  marketing list's ListId, query returned records).

    Is there any way to restore data that's related to the marketing list (member, quick campaign, etc). Thanks for any help.

    Regards,
    Astri K

    Friday, November 20, 2009 5:33 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, Astri.

    This can be done if you have organization's database backup before you'd deleted marketing list.
    If yes - restore this backup to new database and using SQL script move data from restored DB to existing - but remember that this is unsupported !!!
    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Friday, November 20, 2009 7:15 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, Astri.

    This can be done if you have organization's database backup before you'd deleted marketing list.
    If yes - restore this backup to new database and using SQL script move data from restored DB to existing - but remember that this is unsupported !!!
    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Friday, November 20, 2009 7:15 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Andriy,

    Thanks for your reply and pointing it right! Fortunately I have the database back up just before the accident happen. Why didn't I think of it before.. by restoring this back up to the new database. (but the database file size really amazed me.. I think I should find a way to clean it)

    Many thanks for your suggestion :)
    Monday, November 23, 2009 6:27 AM