Forums
>
Users Lounge
>
DNN Creative Articles
Issue 22 *note on Restoringa DB
Last Post 07/13/2007 6:03 AM by
Andrew Davis
. 3 Replies.
Author
Messages
bluesombrero
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
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
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
Andrew Davis
Nuke Newbie
Posts:8
07/13/2007 6:03 AM
Hi
BIG thanks for the tip!
Forums
>
Users Lounge
>
DNN Creative Articles