Posts
Sort by recent activity
SQL Backup without sysadmin
We're trying to get SQL Backup working using an account that is not sysadmin. The account is db_owner in all databases. We added SkipChecks=1 to HKEY_LOCAL MACHINE\Software\Red Gate\SQL Backup\Back...
SQL Clone hangs during image creation
We're having a problem creating an image for one of our databases. The SQL Clone UI provides updates up to "60% Restoring backup" but nothing further after that. We tried upgrading to the latest ve...
Orphaned SQL Clone Images
Today I noticed that there were some "orphaned" SQL Clone images on one of our servers, i.e. the images were still there but they were not listed in the SQL Clone UI. I was able to delete these man...
Create Image from Network Backup
Is it possible to create an image from a Red Gate backup on a network share, or do I need to always copy the backup to the server being used to create the image?
Need to run post-deployment script without schema change
I'm using post-deployment scripts to deploy SQL Agent jobs and other server-level objects, but the post-deployment script will not run unless there is a database schema change. What's the best way ...
How to eliminate: Use of this functionality requires a SQL Toolbelt license
We have developed a devops process using Jenkins and SCA. On our build server we activated the license by running the following powershell script:Register-SqlChangeAutomation <serial #>After doing ...
SQL Source Control does not recognize deletes
We have run into this scenario on a number of occasions.Suppose Developer A and Developer B each have their own development instances of a database linked to source control. Developer A drops an ob...
Jenkins will not build after Git merge
I'm working on a DevOps solution that includes SQL Change Automation, Git, and Jenkins, but I can’t seem to get Git to reliably trigger a Jenkins build when doing a Git merge.
In Git, I
have three...
Unable to upgrade to SQL Backup 10: Access Denied
I am trying to upgrade one of our servers to SQL Backup 10. The "Install or upgrade server components" failed with code 262144 - "The version of the SQL Backup Pro extended stored procedure dynamic...
Need Branching Strategy Advice
We are struggling to come up with a good branching strategy
for our databases. We are using SQL Source Control with Git, Jenkins (for
builds) and Octopus (for deployments to Test and Production). O...