Comments
Sort by recent activity
Man, this is disaster waiting to happen. I found another server that was doing this. It doesn't copy the log backups to the network for days, but it's been deleting them locally. No errors indicating there are any problems. Good thing I didn't need those logs for anything. / comments
Man, this is disaster waiting to happen. I found another server that was doing this. It doesn't copy the log backups to the network for days, but it's been deleting them locally. No errors indic...
I'm having the same problem. / comments
I'm having the same problem.
Here's what I did. It's working again.
EXEC MASTER..sqbdata delete from backupfiles_copylist_log'
EXEC MASTER..sqbdata 'delete from backupfiles_copylist' / comments
Here's what I did. It's working again.
EXEC MASTER..sqbdata delete from backupfiles_copylist_log'
EXEC MASTER..sqbdata 'delete from backupfiles_copylist'
priyasinha wrote:
Hi,
Sorry for the inconvenience.
We are gradually adding support for most of the keywords in the UI. For the next release (5.5) we are adding support in the UI for 'Different purge options for the local and network drive'.
We are also in process of planning for the release after next. We are planning to do quite a bit of work around making editing of job easy as well as not loosing any changes when the jobs are edited via the UI.
Both of yours feature request is high priority on our list too so hopefully will make into one of the future releases soon.
Thanks,
Priya
Well, that is good to hear. Thanks for the reply. / comments
priyasinha wrote:
Hi,
Sorry for the inconvenience.
We are gradually adding support for most of the keywords in the UI. For the next release (5.5) we are adding support in the UI for 'Different pu...
I don't mean to sound like an ass but I'm sure it will be taken that way so here goes.
This is not the only option that has to be set by manually editing the job. It really sucks as the GUI is one of the main selling points of this type of software and I can't even look at my jobs in the GUI anymore because of this.
It would take all of about 1 hour of programming time to throw on a checkbox on the form and add the command to the job. Why would you add a feature/function and then not finish it by leaving it out of the GUI? / comments
I don't mean to sound like an ass but I'm sure it will be taken that way so here goes.
This is not the only option that has to be set by manually editing the job. It really sucks as the GUI is one...
Ahhhhhhhhh, drive failure. [image] / comments
Ahhhhhhhhh, drive failure.
Ah, it's not red-gate. I can't restore a backup taken in ssms either. / comments
Ah, it's not red-gate. I can't restore a backup taken in ssms either.
I just noticed this
execute master..sqbdir '\\recovery' gives me a listing
execute master..sqbdir '\\recovery\' does not. / comments
I just noticed this
execute master..sqbdir '\\recovery' gives me a listing
execute master..sqbdir '\\recovery\' does not.
If I do execute master..sqbdir '\\recovery' I get the directory listing at the share level. If I go execute master..sqbdir '\\recovery\sqlbackups' it doesn't return anything and it should. I'm running this from my machine and I'm admin on \\recovery. This used to work until 5.4 / comments
If I do execute master..sqbdir '\\recovery' I get the directory listing at the share level. If I go execute master..sqbdir '\\recovery\sqlbackups' it doesn't return anything and it should. I'm r...
keymoo wrote:
Thanks Jason, when running
sc sdshow "SqlBackupAgent"
I get
D:(A;;CCLCSWRPWPDTLOCRRC;;;SY)(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;BA)(A;;CCLCSWLOCRRC;;;AU)(A;;CCLCSWRPWPDTLOCRRC;;;PU)
To answer your other questions
- There is only one default instance of SQL Server (2000 SP3)
- The SQL Backup Agent is running as a domain account called sa-SQLBackup and is in sysadmin server role in SQL Server. It is a normal account on the server (i.e. not a local admin).
Just make it local admin and that will fix everything. / comments
keymoo wrote:
Thanks Jason, when running
sc sdshow "SqlBackupAgent"
I get
D:(A;;CCLCSWRPWPDTLOCRRC;;;SY)(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;BA)(A;;CCLCSWLOCRRC;;;AU)(A;...