Comments
Sort by recent activity
I am using SQL Backup v6.4.0.56 We are trying to setup SQL service accounts with the least amount of security privleges needed to run. We have given the Red Gate service account sa rights to SQL, but when we try to backup DBs we get the error below. Does SQL agent account also have to be an SA for Red Gate to work properly? If so this totally defeats our least privileges model we are trying to go to.
Error 880: BACKUP DATABASE permission denied in database: (Test)
SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'SQL_Agent' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated,
or you do not have permission.
Thanks,
Keith / comments
I am using SQL Backup v6.4.0.56 We are trying to setup SQL service accounts with the least amount of security privleges needed to run. We have given the Red Gate service account sa rights to SQL, ...
I will probably be doing some more restores this week or next. I will confirm that I am typing in a name and will let you know if I have any more problems.
Thanks,
Keith / comments
I will probably be doing some more restores this week or next. I will confirm that I am typing in a name and will let you know if I have any more problems.
Thanks,
Keith
Hello Brian,
Unfortunately it isn't a rights issue. To confirm I ran the script you posted and it returned <SQBUTILITYRESULT>:1: for the FTDATA directory. Any other ideas of how I can get the GUI to work?
Thanks,
Keith / comments
Hello Brian,
Unfortunately it isn't a rights issue. To confirm I ran the script you posted and it returned <SQBUTILITYRESULT>:1: for the FTDATA directory. Any other ideas of how I can get the GUI t...
Would adding it after the existing WITH statement like below work okay?
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Test] TO DISK = ''W:\Test\<database>\<AUTO>.sqb'' WITH COMPRESSION = 2, THREADCOUNT = 4, COPY_ONLY"'
Thanks,
Keith / comments
Would adding it after the existing WITH statement like below work okay?
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Test] TO DISK = ''W:\Test\<database>\<AUTO>.sqb'' WITH COMPRESSION = 2, TH...