Issue 22 - Backup a live Install SQL 2000 --> localhost SQL Express 2005 > DotNetNuke Forum, DNN Creative Magazine, Video Tutorials, Skins, Module Reviews

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

Unanswered Active Topics

Forums Search

Forums > Users Lounge > DNN Creative Articles

Subject: Issue 22 - Backup a live Install SQL 2000 --> localhost SQL Express 2005

Email me when someone replies to this thread.

Prev Next

You are not authorized to post a reply.

Author

Messages

guimu

Nuke Newbie
Posts:8

02 Apr 2008 1:50 AM
Hi I have downloaded issue 22 about live & localhost synchronisation. I have not seen it yet because i wanted to know first if i could use these instructions to backup my live install on a SQL 2000 Server and tranfert it on a localhost installation using SQL 2005 Express. Would it be possible to do? Thanks

Guillaume Mullier Founding Partner at Live Data Security

jncraig

Nuke Master II
Posts:2030

02 Apr 2008 8:21 AM
Yes, you can.

Joe Craig DNN Creative Support Subscribe to the website

guimu

Nuke Newbie
Posts:8

02 Apr 2008 1:15 PM
OK thanks

Guillaume Mullier Founding Partner at Live Data Security

leesykes

Nuke Master II
Posts:2993

07 Apr 2008 3:51 AM
you can go from SQL 2000 to 2005 - but I'm unsure if you will then be able to transfer a localhost 2005 database to to a live SQL 2000 database, I don't think this will be possible. If you wish to transfer between local and live, you can get hold of a developers only license of SQL Server 2000 for a very low cost through places such as amazon.

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

guimu

Nuke Newbie
Posts:8

17 Apr 2008 2:10 PM
Thank you Lee, I want to migrate to SQL Server 2005. I have a new question about this tutorial: almost everything worked fine, but i have a problem with links and images. No image is showing and all the links are broken. Do you have any idea of how i could repair that. What will be the behaviour once i transfer to live instalation again? Thank you. Guillaume

Guillaume Mullier Founding Partner at Live Data Security

leesykes

Nuke Master II
Posts:2993

17 Apr 2008 3:31 PM
Hello, We cover the problems with images and links here: Find and Replace SQL queries for DotNetNuke (To fix problems after transferring a localhost database to a live website and other useful functions)

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

jncraig

Nuke Master II
Posts:2030

17 Apr 2008 7:22 PM
And, to do that search and replace I recommend the F3 module that is free from Engage Software. It simplifies the process greatly and you can do the search and replace without doing any SQL stuff.

Joe Craig DNN Creative Support Subscribe to the website

guimu

Nuke Newbie
Posts:8

19 Apr 2008 10:15 AM
Thank you both for your answers. I used Engage F3 Module which is really a great tool and I have solved the whole problem in 10 minutes!

Guillaume Mullier Founding Partner at Live Data Security

guimu

Nuke Newbie
Posts:8

28 Apr 2008 4:54 AM
I was able to replicate my live website on my localhost installation. Then i wanted to replicate it to a new server, but i went into the following issue: I can't login any more. When in clic the login button, it gives a http 404 error. I tried to install a new DNN Site from the install files, and had the same issue. I guess this is a problem of IIS cnfiguration. Any Sugestion?

Guillaume Mullier Founding Partner at Live Data Security

leesykes

Nuke Master II
Posts:2993

28 Apr 2008 6:30 AM
have you had a look at the tutorials on how to install a fresh installation of DotNetNuke: How to install DotNetNuke to Vista How to install DotNetNuke 4.5 to Windows XP Pro with IIS they may point you in the right direction. - things to check: you are using asp.net 2.0 framework correct security permissions have been set up on the DotNetNuke installation files web.config file has correct settings if this is a new server, for troubleshooting I would first try to get a fresh installation of DotNetNuke working. once you have that working, it will then be easier to transfer a localhost installation to the new server. Thanks,

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

guimu

Nuke Newbie
Posts:8

28 Apr 2008 3:59 PM
That's exactly what i did when i saw that things were going wrong, I installed a fresh version and had the same problem: I can't go to the loggin page, neither the Register one. The only active page is the Home page. It is a new server W2003 R2 Standard Edition I had some configuration problems, so I suppose that the best way to solve this issue follow will be to start again removing any install app and setting up again. Thank you for your help.

Guillaume Mullier Founding Partner at Live Data Security

guimu

Nuke Newbie
Posts:8

29 Apr 2008 7:09 AM
I just reinstall IIS and then regiisasp.exe and that was it.

Guillaume Mullier Founding Partner at Live Data Security

leesykes

Nuke Master II
Posts:2993

30 Apr 2008 3:46 AM
great, glad to hear you got it sorted,

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

You are not authorized to post a reply.

Forums > Users Lounge > DNN Creative Articles > Issue 22 - Backup a live Install SQL 2000 --> localhost SQL Express 2005

ActiveForums 3.7

Subscribe to the website - Sign up now for just £39/$78 per year!

Best so far for me by mortymoose

This skin is CSS standard compliant. I understand though that the solpart menu causes it not to val...

RE: centering a page in dnn by mortymoose

No I don't think there is any way to fix that. It makes sense though because the scroll bar is actu...

RE: Host and Admin user login not working on remote host by paulrobinson

Yes I can register a user and login as that user. It is just the admin and host users which are not...

RE: New CSS site feedback please! by puuri

Everything, including the Flash elements, seemed to work fine during my viewing. I was trying to fi...

RE: MY FIRST DNN SITE by puuri

I just took a look and made it through just fine. I am very new to DNN and working towards generati...

centering a page in dnn by kawal

I have centered my DNN web pages using {text-align: center;} in the Body element. This works fine, ...

RE: redirecting registered user to a specific page by puuri

I think I found the area that Joe describes by logging in as the Admin user and then from the Admin ...

RE: File Manager Upload (intermittent error) by dnnmq

Per Lee's suggestion, I removed NETWORK SERVICE from the website root then re-added it with Full Con...

RE: Solpartmenu and line breacks by saintX

Hello Lee and thanks for the answer. Obviously the page name can't exceed to more than 50 charcters....

RE: redirecting registered user to a specific page by saintX

Hello and thank you for the answer. May you please kindly explain me more specific where to find the...

RE: App_GlobalResources Runtime Error/Issue With Pre-Compiled Version of 4.08.04 Source Code by jncraig

I think that you'd probably be better served asking question like those over on the DotNetNuke forum...

RE: App_GlobalResources Runtime Error/Issue With Pre-Compiled Version of 4.08.04 Source Code by fletcherdunton

Hi Joe:That makes perfect sense, but I failed to mention that some of the code that I'd added is not...

RE: App_GlobalResources Runtime Error/Issue With Pre-Compiled Version of 4.08.04 Source Code by jncraig

I wouldn't recommend either of those approaches.You don't have to use the source code version of Dot...

App_GlobalResources Runtime Error/Issue With Pre-Compiled Version of 4.08.04 Source Code by fletcherdunton

This thread may be answered somewhere else, so forgive me and point me to the solution. I'm current...

RE: Database error by derpir

Yeees!!! thank so much Lee!!! I will continue this by looking at video nr 3 on how to transfer fro...

RE: Database error by leesykes

go to programs / microsoft sql server 2005 / configuration tools / SQL server configuration manager....

RE: Database error by derpir

nailed it!!! but how do I restart with the configuration tool? regards //newbie

RE: Database error by derpir

You put me on the right track there. Turns out that I had server authentication set to 'Windows Au...

RE: Issue 22 - Login failed for user xxxx by leesykes

I just checked and it does have it: Right click on the SQL server node - this is the node with th...

RE: Database error by leesykes

I just checked and it does have it:Right click on the SQL server node - this is the node with the gr...

Forum

Latest Forum Posts

Friends

Menu