Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
BackUp and Restore database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    i have taken a backup by right clicking organization database abc_MSCRM then tasks then Backup and need to restore the backup of this organization of two months ago due to some data loss ,will it overwrite only the database of that two months ago, i am newbie and have limited knowledge so would have liked to know from you exprienced guys.

    thanks

    Sunday, October 9, 2011 2:13 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    To restore the database right click on the Database and then select Tasks-> Restore -> Database.. and in Restore Database window choose From Device select backup, click on Options tab check option Overwrite the existing database and click ok

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    • Proposed as answer by Jehanzeb.Javeed Sunday, October 9, 2011 7:37 PM
    • Marked as answer by Nasur Monday, October 10, 2011 5:30 AM
    Sunday, October 9, 2011 7:37 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    In the case you will restore the database you will get the database at the moment of backup.

    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Follow Andriy on Twitter
    Sunday, October 9, 2011 3:19 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Andriy already mentioned that you will get database at the moment of backup but make sure to also perform the following steps:

    1. Take latest organization database backup

    2. Stop Microsoft Dynamics Asynchronous Service and other services (i.e. Sandbox processing if using CRM 2011)  (Go to Start Menu -> Administration Tools-> Services, look for Microsoft Dynamics CRM Asynchronous Service (MSCRMAsyncService) right click on it and select Stop)

    3. In SQL Server Restore Database backup, in Options make sure to choose Overwrite the existing database 

    4. After resorting database backup, make sure to start CRM services


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Sunday, October 9, 2011 3:28 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you both of you, that is what i love this forum, sorry one more question when restoring  i will go to abc_MSCRM database then click Restore database then as javeed illustrated beacuse there is other organizations thank you javeed , and i think how i am doing the backup is OK.
    Sunday, October 9, 2011 4:57 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    To restore the database right click on the Database and then select Tasks-> Restore -> Database.. and in Restore Database window choose From Device select backup, click on Options tab check option Overwrite the existing database and click ok

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    • Proposed as answer by Jehanzeb.Javeed Sunday, October 9, 2011 7:37 PM
    • Marked as answer by Nasur Monday, October 10, 2011 5:30 AM
    Sunday, October 9, 2011 7:37 PM