Topic: Recorder 6 backup
We are trying to reinstall a Recorder 6 database (standalone) from a backup file but have been have been without success so far on a laptop with SQL2014 installed. We have tried various things, mainly changing location of the .bak file as per other forum post suggestions from Mike W but have had the following error messages:
The backup operation cannot compete because the backup device location cannot be opened up.
Unknown backup error 3268
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\nbndata_data_log.LDF" failed with the operating system error 2(The system cannot find the file specified.).
The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\nbndata_data_log.LDF'.
File "NBNData_Log" cannot be restored over the existing "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\nbndata_data_log.LDF". Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files, or WITH MOVE to identify an alternate location.
We initially just copied over an updated .bak file but after this didnt work we then also copied the nbndata_data_log.LDF and NBNData_Log.MDF files. We are wondering if we have been using the correct folder for them and if SQL2014 is set up differently and requires us to put them in a different folder?
Thanks in advance