locked
LRestore CRM RRS feed

  • Question

  • I am running Windows 2003 SP2 with SQL 2005 Pro and CRM 4.0 update 3.  I would like to perform a complete restore of the datbase and log files through my Backup Exec SQL Backup/Restore.  Does SQL provide a way for me to create another SQL Instance on the same server to test restore my CRM. I dont have another server to restore to for testing.

    Thanks in Advance
    Len
    Monday, May 4, 2009 7:45 PM

Answers

  • Hi Len,

    yes, you just have to install SQL Server again with a named instance.

    But you can also restore a backup under a different database name, so you don't have to install a second instance.

    The concept with SQL Server is a little different to Oracle. I estimate you know it because of the kind of your question.

    Best regards,
    Jürgen
    Jürgen Beck

    Dipl. Kfm./Wirtschaftsinformatik
    MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified CRM Developer
    Microsoft Certified Trainer

    ComBeck IT Services & Business Solutions
    Microsoft Gold Certified Partner
    Microsoft Small Business Specialist

    Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors

    http://www.combeck.de
    Monday, May 4, 2009 9:07 PM
    Moderator