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

Forum

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:2368


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:2368


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

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...
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...
Best DNN portal ever! by derpir
I have been a subscriber since august 2008, and DNNCreative.com is simply the best DNN Portal, their...
RE: skinning trouble by derpir
Hello Yes could you be so kind and take a look att the htm-file and css-file.I would be very gratef...
Search function is not working by kishorpawar
I am using Seach module in my project but not working, i have set   host setting alsoHost --> Schedu...
RE: backend is changing from sql2005 to sql2008 by leesykes
hello,There should not be any code changes needed, but you'll need to make sure that SQL 2008 upgrad...
RE: skinning trouble by leesykes
Hello,I would need to see your code to help you with this one, you can zip up your files and attach ...
RE: Installing DotNetNuke 4.9.00 on VWD 2005 w/ SQL server 2008 by leesykes
I have run a test with SQL Server 2008 express and DotNetNuke installed in exactly the the same way ...
RE: Issue 39 Interview by leesykes
thanks Bill, glad it was useful, we will have a think about the best way to approach this,Thanks,
RE: Issue 39 Authentication by leesykes
yes I have a live site in 4.9.0 at it seems stable as well.
backend is changing from sql2005 to sql2008 by meenu
hi all advance thanks. in my DNN0408 website am using sql2005 as backend.now planning to remove sq...
About catalook error by kishorpawar
 I am  using dnn 4.8.4 version in my project, this  site is in 2 language,whenver i click on the BYN...
RE: Menu Keeps Verticaly by ruimacdonald
Tnx for your help. It's done. Rui
RE: Menu Keeps Verticaly by jncraig
The configuration of the MENU skin object is defined in the skin.xml file. You'll need to modify th...
DotNetNuke Modules
RSS Feeds