Viewing 8 posts - 1 through 9 (of 9 total)
Ok, I got a DB to restore and the log shipping scripts to run without giving an error! Thanks Sue!!
The DB in the second server shows as restoring,...
November 21, 2017 at 11:31 am
That is true, I did. The issue is that when I try to initialize again, it fails with the error of not having access to load the .bak file. When...
November 21, 2017 at 9:17 am
That worked! Now I'm getting the 'Database is not in recovery or standby mode' error. I selected not to need this when I setup the log shipping, not sure how...
November 20, 2017 at 4:46 pm
Ok, I was able to add a new user that cleared the login error. Now I am getting this error:
Message
2017-11-20 17:03:09.95 *** Error: Could not retrieve copy settings...
November 20, 2017 at 4:05 pm
Ok after completely rebuilding the backup directory and setting the permissions, I have the primary server script working.
The second server (after I did the same thing) is giving...
November 20, 2017 at 3:27 pm
The permissions are set to 'Full control' for the 'logshipping' user. The E:\Backup\...ect directory is on both servers. The job is failing on both servers. The primary server is the...
November 20, 2017 at 3:02 pm
On both servers I have created a windows user called 'logshipping' and they both have admin rights. In both of the backup folders they are added under 'backup properties-security' and...
November 20, 2017 at 1:55 pm
Hey Sue,
I'm getting the same error, even when the location the primary server is storing is its local drive.
I have both SQL server agents set...
November 20, 2017 at 1:30 pm
Viewing 8 posts - 1 through 9 (of 9 total)