Activity overview
Latest activity by acorcoran
We just installed the servers so I haven't tried running a normal backup yet, was simply trying to get the RedGate software installed. Let me try to run just a normal backup database to see if that works ...
Here is the error I'm getting with the RedGate product, after install (when I try to register the server).
"Failed to initialize local data store: Access to the database file is not allowed. [File=<path>\data.sdf]"
Which that file does not exists, so I'd imagine it would be an ACL issue.
Bah disregard, once i gave permission to the service account to that particular folder, it worked fine. I gave it to the "C:\Documents and Settings\All Users\Application Data " as shown in previous messages. Sorry about that.[/img] / comments
We just installed the servers so I haven't tried running a normal backup yet, was simply trying to get the RedGate software installed. Let me try to run just a normal backup database to see if tha...
I am having similar issues when installing 5.1 on our server. I haven't experienced these in the past with the other servers I've installed Red Gate Backup on. Just for background information, this is on a clustered server, but simply trying to install it on the active node locally for testing.
I manually added the service account that SQL Backup Agent is running under to have modify permissions on the following folder:
C:\Documents and Settings\All Users\Application Data
Once I install the software the service fails to start automatically (which right here is a flag for me). I can start it manually without any issue.
I see no Red Gate related folders installed in C:\Documents and Settings\All Users\Application Data either, which leads me to believe that something isn't secured correctly on my end. / comments
I am having similar issues when installing 5.1 on our server. I haven't experienced these in the past with the other servers I've installed Red Gate Backup on. Just for background information, th...
Great,
Thanks for the prompt responses and clarification.
Aaron / comments
Great,
Thanks for the prompt responses and clarification.
Aaron
So just to make sure I am understanding clearly, if we used the maintenance plan wizard in the past for optimization, integrity, we'll have to continue using the SQL Agent to run these? I know SQL Backup Agent will handle the backups of both database and transaction logs, but wasn't sure if it would also handle running the various maintenance tools inherent in enterprise manager?
Thanks,
Aaron / comments
So just to make sure I am understanding clearly, if we used the maintenance plan wizard in the past for optimization, integrity, we'll have to continue using the SQL Agent to run these? I know SQL...
SQL Agent Necessary?
This is probably a novice question, however, I was unsure once SQL Backup was installed and the Backup Agent is successfully running, is there still a need to have SQL Agent running at all?