Activity overview
Latest activity by SirRandall
SQL Backup - Authentication error copying file to fileshare
We've recently patched our Flashblade storage, which contains a share that holds x days of SQL log files once they are backed up. (SQL Backup is backing up logs to a local disk, and then copying t...
I figured it out. The gmsa account didn't have Server Administrator access. Everything cleared up after that. Issue resolved. Hoping this lengthy ramble helps someone else down the road. / comments
I figured it out.The gmsa account didn't have Server Administrator access. Everything cleared up after that.Issue resolved. Hoping this lengthy ramble helps someone else down the road.
Is it perhaps that the gmsa running the service likely doesn't have any access to the SQL instance hosting the SQLBackup repository database (it's on a different instance the the one I'm trying to backup).? I'll bet that's it, and it's what I'm working on now. I'd appreciate any other suggestions. --update-- Ignore this. There is no SQLBackup repository. I was getting it confused with the SQL Monitor repository. / comments
Is it perhaps that the gmsa running the service likely doesn't have any access to the SQL instance hosting the SQLBackup repository database (it's on a different instance the the one I'm trying to...
Warning 445 error using SQL Backup 10 with a gMSA
Environment:
SQL Backup 10.1.18.2060 installed on a fresh Windows Server 2019 | SQL Server 2019 Ent instance.
The SQL Backup service is configured to login as a group-managed-service account (gmsa)...
The problem was indeed the SQL Backup license on that server...just like the error message said. Thanks RedGate for the support. / comments
The problem was indeed the SQL Backup license on that server...just like the error message said.Thanks RedGate for the support.
Attempting to create new image, error message "Invalid SQL Backup header. Trial has expired"
I just applied an updated trial license to extend our SQL Clone demo for two more weeks.Now that I've applied it, I can no longer create an image.I'm trying to create a new SQL Clone image, based o...
This is still a mystery. Perhaps I missed something in the original config. Regardless, using the GUI I have revised all of my backups to be encrypted and it appears to be working as I expected. Chalk this one up to user error I guess. / comments
This is still a mystery. Perhaps I missed something in the original config.Regardless, using the GUI I have revised all of my backups to be encrypted and it appears to be working as I expected.Chal...
Thanks Petey2. It's late. I'll get back to you Monday. Thanks for the help. / comments
Thanks Petey2. It's late. I'll get back to you Monday. Thanks for the help.
Sorry. Had trouble finding it. Then I recalled that it's set up as FULL COPY ONLY, so it's not in the log. / comments
Sorry. Had trouble finding it. Then I recalled that it's set up as FULL COPY ONLY, so it's not in the log.
When I run this query against the instance where I attempted the restore (that failed), I get zero results. Did you intend to have me run this against the instance that created the backup? / comments
When I run this query against the instance where I attempted the restore (that failed), I get zero results.Did you intend to have me run this against the instance that created the backup?