Hey All - I have a SQL server in our remote office that I am trying to restore a Database too from our Main office. Its not a differential just a full backup. It has always worked fine but the last few weeks its failing with the error below.
Credential are fine. I am doing Microsoft SQL Redirection, checking server and typing the SQL server name. Under settings-General I have restore over existing files. Under Settings-Microsoft SQL, I am selecting Leave the database in read only mode. Not selecting anything else. The job runs and gets to 10,603 bytes and just sits there until it finally fails with the error below about 10 hours later. Any help would be greatly appreciated.
Restore- ArchiveBK V-79-57344-33938 -
An error occurred on a query to database Archive.
V-79-57344-33938 - File 'Archive_Data_Secondary2' cannot be restored over the existing 'H:\SQLDATA\Archive_Data_Secondary2.ndf'. Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files.
Credential are fine. I am doing Microsoft SQL Redirection, checking server and typing the SQL server name. Under settings-General I have restore over existing files. Under Settings-Microsoft SQL, I am selecting Leave the database in read only mode. Not selecting anything else. The job runs and gets to 10,603 bytes and just sits there until it finally fails with the error below about 10 hours later. Any help would be greatly appreciated.
Restore- ArchiveBK V-79-57344-33938 -
An error occurred on a query to database Archive.
V-79-57344-33938 - File 'Archive_Data_Secondary2' cannot be restored over the existing 'H:\SQLDATA\Archive_Data_Secondary2.ndf'. Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files.