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,