Forum

Hi Aderson,

I'm trying to create a copy of a DNN 8 installation on my local machine. 

I would like to maintain the original site (originally installed using nvQuickSite) and upgrade its copy to DNN 9.2

I have tried copying the directory and renaming it, then attaching the database in SQL Server Management Studio, which works but the database set Read Only.

I tried setting the read only option (properties > options > database read only) to false but can't due to a permissioning error.
I tried looking at the permissions for the original database which has owner set to 'MSSQL$SQLEXPRESS' but can't even see that as an option when trying to set the permissions of the copied database file.

So I was thinking there has to be an easier way to do this.
I was thinking to use Robocopy to maintain the permissions but thought I'd check and see if you know a better way before I spend some more hours barking up the wrong tree.

Best Regards,

Steve

Hi Aderson,

Thank you for your reply and suggestion.

I did try a backup and restore but ran into permissioning issues. I eventually realised that the SQL service which is accessing the file needs to have permission to the database files which are not in the default directory for SQL Server Management Studio (SSMS). Looking at the properties for the service I found that this was running as 'NT Service\MSSQL$SQLEXPRESS', I then added that to the 'groups and usernames' section of the folder containing the database files.

I was then able to perform the backup and restore successfully.

I then needed to rename the database as described here:
https://www.mssqltips.com/sqlservertip/4419/renaming-physical-database-file-names-for-a-sql-server-database/
One thing though, I couldn't take the database offline, that option caused the SSMS interface to hang.
So I stopped the SQL Service instead.

It was a bit long winded but I now have a copy of the database with new physical and logical file names correctly changed.

Thank you once again for your suggestion.

Best Regards,

Steve