Jump to content
Sign in to follow this  
scottthompson

can't read, error -1004 (Database Backup/Restore error)

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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)).

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×