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

Forum

Forums > DotNetNuke® > DotNetNuke® Questions
Subject: Regular restores to local machine
Prev Next
You are not authorized to post a reply.

Author Messages
joannew
DNN Creative Magazine Subscriber
Nuke Ace
Nuke Ace
Posts:58
26 Aug 2008 9:33 AM  

Hi Lee,

I've followed your tutorials and have now restored my live website to local computer. I've noticed the users don't show through the website yet the data is stored in the database, is there something i've missed?

Also, I'd like to regularly restore my backups locally, what is the easiest way to do this?
Do you overwrite your dotnetnuke files, restore the latest backup file and change web config?
I've tried restoring the latest .bak but got the following error...

TITLE: Microsoft SQL Server Management Studio Express

Restore failed for Server 'C2\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: RESTORE cannot process database 'prod' because it is in use by this session. It is recommended that the master database be used when performing this operation. (Microsoft.SqlServer.Express.Smo)


I used to run commands from sqlservercentral.com/../moreintelligentbackupandrestore is this process out of date now?

Thanks alot,
Cheers J,
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3375
27 Aug 2008 4:05 AM  
Hello,

The users should display in your local installation. - perhaps you could try going to the host menu / HostSettings / scroll to the bottom and click on restart application.

For regularly restoring backups, if you are making no file changes, then you can simply restore the latest version of the database into your localhost installation. - regarding that error, if you are overwriting an existing database, make sure that you have not loaded up your DotNetNuke installation - otherwise SQL server may give an error that the database is in use.
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
joannew
DNN Creative Magazine Subscriber
Nuke Ace
Nuke Ace
Posts:58
28 Aug 2008 4:47 AM  
Hello Lee,

Thanks for the info, I tried restarting the application but it had no effect. Is there something else I could be missing?

I've also tried restoring the .bak file over the existing database but still get the same error as above about it being in use. Do you think it could be a permissions issue?

Thanks alot...
joannew
DNN Creative Magazine Subscriber
Nuke Ace
Nuke Ace
Posts:58
28 Aug 2008 8:56 AM  

Just to let you know, restoring the .bak file now works, by changing the default database for the login and also changing sql to mixed mode authentication...

Still trying to find a solution to the missing users though... has anyone come across this before?

Cheers...
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2371
28 Aug 2008 9:22 AM  
You can use SQL Server Management Studio to look into your database to see what is there. Your users are in the aspnet_user, aspnet_membership and users tables. That is, there are parts of the user definitions in all three of the tables.

If I recall correctly, the field that joins the users table to the aspnet tables is the email address or the username.
Joe Craig
DNN Creative Support
Subscribe to the website
joannew
DNN Creative Magazine Subscriber
Nuke Ace
Nuke Ace
Posts:58
28 Aug 2008 9:32 AM  
I've opened the tables and there is lots of data in there but nothing when i navigate to user accounts in dnn and I carn't add a new user in this way either?
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2371
28 Aug 2008 6:49 PM  
I've got more questions than answers ...

Can you login as administrator and/or host?
Can a logged in administrator/host create new users?
Can users register?

What error messages are generated by any of the above?
Joe Craig
DNN Creative Support
Subscribe to the website
joannew
DNN Creative Magazine Subscriber
Nuke Ace
Nuke Ace
Posts:58
29 Aug 2008 3:04 AM  
Thanks for getting back to me, just to let you know everything is working fine now, I can login as admin, create users and users can register... not sure why i couldn't see user accounts initally maybe it was a caching issue. Anyway I'm happy I have a working localhost copy now to attempt an upgrade from 3.3.7 to 4.8.4.
Cheers...
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3375
03 Sep 2008 10:14 AM  
great, good luck,
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
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > Regular restores to local machine


ActiveForums 3.7

Latest Forum Posts

MMLinks module by Absinte
I am using the MMLinks module on a tri-lingual website. When i insert a picture in the HTML text pro...
RE: Change Skin on URL by rdickey
We are looking for something simular. We have some modules that like to display the admin skin when...
Changing "Register" to "Sign up" by evo
HiI recently started using DNN for my programming needs (I have been programming in ASP for the last...
Problem with Andreas_01 skin in IExplorer by mendialb
Hi. i have a problem with Andreas_01 skin in IExplorer; with Firefox it's ok but when open the site ...
RE: [Server Error]This error can be caused by a virtual directory not being configured as an application in IIS. by mnaoj
Error 1 It is an error to use a section registered as allowDefinition='MachineToApplication' beyond ...
RE: skin/container error load by islandman
Hi There newbie for most of the technical stuff. directories etc... I am using skins from ALLDNNS...
search redirect to another portal by sanju_k1421
In my site i got two protals  greek// english    when i click search of english  its redirected to g...
can search work to search in current paonlyge by sanju_k1421
hi  In my site i m using Input Search  module  when i click on search  it search the whole site  and...
Error - The ScriptManager must appear before any controls that need it by SimonTurner
Hi Guys,Ive been having the below problem for a few days now and am really in need of some expert ad...
Restricting DateEditControl till date by coder247
Hi All,   We are using the DateEditControl (for obvious reasons!!) in our application. But we want t...
RE: Email Set UP per Portal by jncraig
I think that the answer depends on how email is configured at your host. You'll probably have to co...
RE: skin/container error load by jncraig
I would suggest checking permissions for directories. Does this occur only when you upload a skin...
RE: Add New Profile Properties by jncraig
Hmmm ... I don't have an answer. Does anyone else?
RE: No Access for me too by ristori
it is ok now. Thanks for this action.
skin/container error load by islandman
Has anyone else run across this error when loading skins or containers from site settings?I am using...
Email Set UP per Portal by islandman
How do I set up a unique email address per domain name off 1 hosting environment. for example...m...
RE: localhost Install issues by cdees
Lee: I wanted to follow up on this for anyone following this thread. I have been unable to solve t...
RE: Add New Profile Properties by WSI
HI Joe, The DNN version is 4.5.5. Thanks, Cliff
Change Skin on URL by vinita
Hi,Can the skin be changed based on the url used to access a portal. Multiple portal aliases may be ...
problem creating child portal by kabamaro
  Hello all i have 4 Aliases for my parent portal , lets call them X,y,Z,WIn all Aliases i can creat...
AppTheory
RSS Feeds