Backup MS SQL server
-
I just installed Brightstor ARCserve Backup Version 9 Agent for Microsoft SQL for Windows Upgrade and when I try to backup my MSSQL7 database I get, "Error 8601." When you click on Microsoft SQL Server it wants a password. This was never an issue before. Does anyone know how I can change that so it's automatic.
This is what the help file says.........
8601 Failed to connect agent. (AGENT=agent name, EC=error message/code)
-
Sorry, haven't used that version.
BTW, I think you'll find the consensus on this site from most experienced DBAs is not to use an agent.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com -
Just echoing Steve's comments. Save yourself a possible nightmare down the road.
In a previous job, we had Arcserve 6 SQL Agent. After working flawlessly for about 8 months it decided to go haywire one weekend and put us offline for 2 days. Since then I always do file backups
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
-
hi
please check if at the securuty u delete the domain \administrator
the reson that the arc could'nt connect to the sql server is the sql gives permissions to the domain admin
-
Make sure that you enter the information into the agent configuration utility on the sql server.
It's not the best way to back up, however when you don't have the disk space to do backups it can be the only way to go.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply