Activity overview
Latest activity by kedwards
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, ...
Restore Job Fails
Hello,
We setup a job to do a nightly refresh of a training database from a SQL Backup v5 file. The first step of the job we disconnect all users then use the restore code like below. After about 2...
Table Restore???
Hello,
Does SQL Backup have the capability to just restore a table from a backup file? I was just wondering because it would be nice to only restore a table instead of an entire large database if d...
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...
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...
SQL 2005 DB restore with Full Text folders
Hello,
I have been restoring some databases that have full text search files with them. I can change the path for the data and log files, but I am having trouble with the full text files. I am usin...