You need to Register for free and Login to post a message in the forum.

Forum

Subject: Why do a live to local to test when you can restore a backup?
Prev Next
You are not authorized to post a reply.

Author Messages
Dathan
Nuke Active Member
Nuke Active Member
Posts:27

17 Aug 2007 4:32 PM  
Issue 22 was an awesome tutorial, the best yet I think, but I want to point out that transferring a live site to local site to test an upgrade, or new modules, etc, is unnecessary if your hosting company provides a service for backing up the database and restoring it. In which case, just make a back up before you do something risky and if something goes wrong then restore the backup.
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325

20 Aug 2007 3:45 AM  
Hello,

I test anything such as upgrading on a localhost installation because it is not worth the risk of the downtime caused by an incorrect upgrade. - the hosting provider can get a backup of the site up and running again, but this does take time.

If you have a really busy site, you would get a lot of frustrated users while you are attempting to upgrade a site. - For instance, when I moved from version 3.x to version 4.x it took several days to get the upgrade working correctly.
How to Upgrade DotNetNuke v3.x to v4.4.1

Thanks,

Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
Dathan
Nuke Active Member
Nuke Active Member
Posts:27

29 Aug 2007 2:59 PM  
Yes, you’re right, I now realize. Sometimes a backup doesn’t restore correctly, so even for sites that get only a few visitors and that can be down for a short time while the backup is restored, they should test their upgrade or potenially dangerous changes first.

I had that problem with my website. Before I tried the upgrade I first tried your method of transferring a live to local to test the upgrade first. But I could not restore the database via Microsoft SQL Server Management Studio Express. I kept getting this error:

“System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL\data\...”

But I admit I was hasty and didn’t want to struggle with that problem so I tested my theory that I could just restore the DNN website if the upgrade failed. So I backed up the DNN database and I copied the entire website via FTP and waited until about 3AM, then I tried the upgrade and it failed. I tried to restore the website but it still didn’t work…

Now the website is down and I’m now waiting on tech support to see if I can restore it to a prior date.

The moral is, listen to Lee, and take many precautions, more so then I did, when attempting an upgrade or potenially dangerous changes.

Thanks Lee!

You are not authorized to post a reply.
Forums > Users Lounge > DNN Creative Articles > Why do a live to local to test when you can restore a backup?



ActiveForums 3.7

Latest Forum Posts

RE: Reversing Limited Access to the Admin Menu by wynnjon
OK-So I've updated the TABS table entries in the database and set the previously modified entries (t...
RE: localhost Install issues by leesykes
If you go to the subscribe page and click on the get free trial button - this takes you to a page wh...
localhost Install issues by cdees
I've set up a local host and want to run DNN for a local development machine.  The host is set up; h...
RE: Reversing Limited Access to the Admin Menu by wynnjon
That is what I thought.  So for my clients that will need to manage user accounts, I can not limit t...
RE: Reversing Limited Access to the Admin Menu by leesykes
I seem to recall it doesn't work
RE: Reversing Limited Access to the Admin Menu by wynnjon
Thanks Lee-  I will give that a try.An additional question- If you place the "User Accounts" page un...
RE: Reversing Limited Access to the Admin Menu by leesykes
all you need to do is reverse the process within the SQL tables.Compare the data to the other rows i...
RE: Module not working when logged off. by leesykes
thanks for the info,
Reversing Limited Access to the Admin Menu by wynnjon
Hi!  I followed the tutorial for limiting the access to the admin menu.  What a great thing!However,...
RE: Trouble installing! Designer trying to be a Developer. by leesykes
glad to hear you found a solution, thanks,
RE: Skim Question by leesykes
You could but you will not be able to have an XHTML compliant page as the SolpartMenu is non-complia...
RE: Include in Menu - Weird Request by leesykes
For your sitemap.xml file - use GSiteCrawlerYou could create the site map before moving the sub menu...
RE: Trouble installing! Designer trying to be a Developer. by awright14
It looks like I had ASP installed in the wrong order.  Copying and pasting this into the Run Command...
RE: Need Help Changing Containers Contentpane's Text Color by leesykes
Hello,Have you tried adding a class to the content area of your container and then styling the p, a,...
RE: Vertical SolpartMenu by leesykes
hello,If you wish to display the admin and host menus within the house menu, you need to enable it i...
RE: Firefox Does Not Display WMV File In Media Module by leesykes
Hello,I have just tested this and I can play a wmv file in Firefox 3.0.3, so it does suggest that it...
RE: advice wanted convert site to DNN while keeping existing asp functionality by leesykes
You could try using the IFrame module in DotNetNuke and then just link the IFrame to the current pag...
RE: Need Help Changing Containers Contentpane's Text Color by CROKeefe
Thanks for the quick update... I know it looks broken right now, but I had the TITLE classes working...
RE: Need Help Changing Containers Contentpane's Text Color by leesykes
The default class for a container is .head so you will find that the .head class will override any s...
RE: Module not working when logged off. by t.ramya85
have to set the cache time to '0' in that module setting.
DotNetNuke Modules
RSS Feeds