I had this problem on a VPS with SQL 2014 Express. There was not enough security permission to a do a restore from the default backup directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup (although backups worked fine)
The error was: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.
Actually, you can follow these steps to change the authority:Log in to SSMS using Windows Authentication Navigate to Security->Logins Either double Click, or Right Click and select Properties on the user you're interested in . In the "Select a page" box, select "Server Roles" Make sure that the "sysadmin" role is selected Press Ok to save the change and close the dialog Exit SSMS Reopen SSMS and login as the User you wanted, and you should now have sufficient Privileges
One simple way is backup by using T-SQL
Create a Full Database Backup using Transact- SQL or T-SQL to restore the database from .BAK file
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
Hi,
Kindly make sure change the DB to an offline or single user to restore properly some time if it's in use the backup will not restore.
I have had no problem doing a db restore to a production SQL server by simply stopping the IIS service first. I also make sure the option to overwrite (replace) is set as part of the restore. Hope this helps.
If doing a restore to a different SQL Server (not the one backed up) e.g., restoring a staging SQL Server db to production SQL Server db or the other way the Login and dbUser GUIDs will not match. To correct that you will need to sync the user with the login by running the script:
USE [database] GO EXEC sp_change_users_login 'update_one', '[loginname]', '[username]' GO
Generally the loginname and username will be the same.
Hope this helps
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.