MS CRM 2011 recover deleted account

質問する

2012年5月9日 1:02

0

Hi

we are using crm 2011, a user has accidently deleted a account,

what would be the best way to restore this account from a backup, i seen some solutions if you have logging enabled which we dont.

what i have done is restored the backup db imported as a seperated organisation,

logged in and exported the account and contacts.

great but it is missing notes, completed activities. history and data in related entities.

there must be a way to recover a entire account with all data?

please help?

thanks

spafco
- 返信
- 引用

すべての返信

2012年5月9日 1:32

モデレータ

0

For a complete restore - will need the crm database backup and restore it vs. importing the data. This will ensure all the related data are intact to the point of backup.

What's the reason for not just restoring the crm database from backup?

Good CRM Links
My CRM Blog: http://mscrmonline.wordpress.com
- 返信
- 引用
2012年5月9日 1:36

0

hi thank for the reply,

reason is that data is entered by our helpdesk and accounts updated freuquently,

so CRM was not taken offline immediatly and the back up was from the night before.

So what is the best way to import the data from a backup im sure a complete database restore cant be the only option?
spafco
- 返信
- 引用
2012年5月9日 1:45

0
Hi,

When you try to delete an account, you will get a message as attached as screen shot:

So as per above message all the records under account will be deleted. This includes Notes as well. The notes will also have been deleted. From your database restore you will have to restore notes also. There is no easy way to recover the data.

Instead of going for unsupported way and changing the database directly, I suggest go to the restored account and add everything manually (notes and the data in related entities). For the history and competed activitied, just export them from the restored ORG and keep it as a excel file on your network drive or attach as a file to a new note on that restored account.

Also in future always deactivate account, it is easy to activate back again.

I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.

Ashish Mahajan, CRM Developer, CSG (Melbourne)
My Personal Website: http://www.ashishmahajan.com
My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

My Linkedin:

My Twitter: https://twitter.com/#!/ashishmahajan74
- 回答の候補に設定 Ashish Mahajan Australia (Architect) 2012年5月9日 1:45
- 返信
- 引用
2012年5月14日 8:32

0

Hi,

If any of the responses answered your question and you are satisfied, please mark the response as an answer and vote as helpful. This will help others to search on similar problems.

Thanks in advance.
Ashish Mahajan, CRM Developer, CSG (Melbourne)
My Personal Website: http://www.ashishmahajan.com
My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

My Linkedin:

My Twitter: https://twitter.com/#!/ashishmahajan74
- 返信
- 引用