scottthompson Posted November 17, 2004 Report Share Posted November 17, 2004 I am getting this error when I back up my SQL databases. If I run a manual backup, it quickly skips over each DB and give this error on each. What am I doing wrong? I am running 6.5.350 on SBS2003. Link to comment Share on other sites More sharing options...
natew Posted November 18, 2004 Report Share Posted November 18, 2004 Hi Have you always had this error or did it start happening all of a sudden? You might want to try unlicensing and relicensing the SQL server in the Retrospect configure->volumes window. Thanks Nate Link to comment Share on other sites More sharing options...
scottthompson Posted November 18, 2004 Author Report Share Posted November 18, 2004 I ran the backup manually once and had success. Once I created an automatic backup with a script it started. Now I cant even run an automatic backup without it happening. Also, I am getting another error in Activity Monitor/Events that reads, "Script Error: no source volumes specified." I checked the script and SQLServer is selected as a source. TIA, Scott Link to comment Share on other sites More sharing options...
natew Posted November 19, 2004 Report Share Posted November 19, 2004 I see.. Try changing the sources of your script to be the individual databases on the SQL server. Not just the SQL server container. Did unlicensing/relicensing the SQL sever in the Retrospect configure->volumes window make a difference? Thanks Nate Link to comment Share on other sites More sharing options...
scottdog129 Posted November 19, 2004 Report Share Posted November 19, 2004 I tried that. Coincidently, I purchased a year of tech support from Dantz and THAT guy couldnt figure it out. I an getting another error in EV when I try to do an automated backup using Enterprise Manager. Do you think they might be related? SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status: Failed - Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not obtain information about Windows NT group/user 'PULIZ04\Administrator'. [sqlSTATE 42000] (Error 8198)). Link to comment Share on other sites More sharing options...
natew Posted December 2, 2004 Report Share Posted December 2, 2004 Hi It could very well be related. It looks like an authentication error to me. If access permissions aren't set up properly Retrospect will definitely have trouble backing up the databases. Are you in a domain environment or is all authentication taking place on the local machine? Thanks Nate Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.