Comments
Sort by recent activity
I tried using the stored procedures listed here: http://help.red-gate.com/help/SQLBackup ... Backup.htm
to change the authentication, with no luck. I then removed the ServerCore install and re-installed it entering my domain credentials. However the backups still fire off as NT Authority\NETWORK SERVICE
The SQL Backup Agent is running under Domain\Administrator as well. / comments
I tried using the stored procedures listed here:http://help.red-gate.com/help/SQLBackup ... Backup.htm
to change the authentication, with no luck. I then removed the ServerCore install and re-inst...
Ok doke. I can run the script out of a Query Analyzer logged in with windows authentication.
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [XYZ] TO DISK = ''C:\SQLBACKUP\DAILY\DB\<AUTO>.sqb'' WITH COMPRESSION = 1, ERASEFILES_ATSTART = 5, INIT, MAILTO = ''me@domain.com'', THREADCOUNT = 4, VERIFY"'
That works great, so somewhere.. the script is executing under the wrong permissions from SQLBackupC. / comments
Ok doke. I can run the script out of a Query Analyzer logged in with windows authentication.
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [XYZ] TO DISK = ''C:\SQLBACKUP\DAILY\DB\<AUTO>.sqb'' W...
Nevermind, I got it. [image] / comments
Nevermind, I got it.
petey wrote:
Yes.
Perfect. This morning's backup went flawless and all the older data has been erased. / comments
petey wrote:
Yes.
Perfect. This morning's backup went flawless and all the older data has been erased.
petey wrote:
Sorry, you should use the value 1 i.e. FILEOPTIONS = 1.
The value 2 instructs SQL Backup to only delete files if the file does not have the archive attribute. In cases where you back up the files to tape, this option prevents you from deleting files that have not yet been backed up to tape.
So this will delete both the Primary and COPYTO locations after "X" days (ERASEFILES setting)? / comments
petey wrote:
Sorry, you should use the value 1 i.e. FILEOPTIONS = 1.
The value 2 instructs SQL Backup to only delete files if the file does not have the archive attribute. In cases where you ba...