Issue 22 *note on Restoringa DB
Last Post 07/13/2007 6:03 AM by Andrew Davis. 3 Replies.
Author Messages
bluesombrero
Nuke Newbie
Nuke Newbie
Posts:5


--
07/11/2007 10:43 AM
    This Issue came with perfect timing and I am making good use of the videos.

    One problem I ran into that I would like to share the solution with you is in Video 2, around frame 30/85, when you are setting the destination and source for restoring the database on the local box there is a General tab and an Options tab.  The video shows the process entirely in the general tab.  The Options tab contains additional information for some people.

    When you backup a database it saves the filepath of the original database.  So for example if your production server has the database on Drive D: and your local box only has a Drive C:  You will receive an error message when trying to restore to the local box as SQL will attempt to write to the orginal server's filepath.  You can fix this by simply going to options tab and setting a new, valid filepath for you local box.  All other steps for me were the same as the videos which were very helpful.

    I hope this helps a few out there.
    bluesombrero
    Nuke Newbie
    Nuke Newbie
    Posts:5


    --
    07/11/2007 10:49 AM
    In case it wasnt clear I'm refering to "How to backup a live hosted DotNetNuke website and restore it to a localhost installation" Video 2
    Lee Sykes
    DNN Creative Staff
    Nuke Master VI
    Nuke Master VI
    Posts:4945


    --
    07/11/2007 4:26 PM
    Thanks for sharing the tip, I'm sure many people will find it useful,
    Lee Sykes
    Site Administrator
    Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

    Twitter: www.twitter.com/DNNCreative

    Lee Sykes's Facebook Profile
    Andrew Davis
    Nuke Newbie
    Nuke Newbie
    Posts:8


    --
    07/13/2007 6:03 AM
    Hi
    BIG thanks for the tip!


    ---