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,

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.

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...

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...

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.

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?

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?

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...

great, good luck,