Newbie questions... version 5.6.132

[wdm@duostech.com]

Just some newbie questions:

1) When backing up some sql (ms sql 2k) db's, I get an error indicating"different modify date/time" why? What does this mean? Is the db still getting backed up? No sql agent that I can find. Looks like maybe it is due to transaction logs? Are the db's being backed up? What should I do to correct this issue?

 

Here's the text from the report "..."

11/10/2005 12:03:04 AM: Comparing SQLBackup on Sqldyn

File "\\SQLDYN\SQLBackup\DYNAMICS Nightly backup": different modify date/time (set: 11/8/2005 11:45:08 PM, vol: 11/9/2005 11:45:21 PM)

File "\\SQLDYN\SQLBackup\MTR Nightly backup": different modify date/time (set: 11/7/2005 10:45:21 PM, vol: 11/9/2005 10:45:34 PM)

File "\\SQLDYN\SQLBackup\master Nightly backup": different modify date/time (set: 11/9/2005 12:00:20 AM, vol: 11/10/2005 12:00:29 AM)

File "\\SQLDYN\SQLBackup\msdb Nightly backup": different modify date/time (set: 11/9/2005 12:00:19 AM, vol: 11/10/2005 12:00:30 AM)

File "\\SQLDYN\SQLBackup\PASCO Nightly backup": different modify date/time (set: 11/8/2005 11:00:46 PM, vol: 11/9/2005 11:00:52 PM)

File "\\SQLDYN\SQLBackup\SWC Nightly backup": different modify date/time (set: 11/8/2005 11:30:30 PM, vol: 11/9/2005 11:30:35 PM)

11/10/2005 1:38:13 AM: 6 execution errors

Completed: 141 files, 16.6 GB, with 71% compression

Performance: 155.1 MB/minute (137.6 copy, 177.7 compare)

Duration: 03:38:02 (00:00:05 idle/loading/preparing)

 

Can't export "MainBackupReport.utx", error -1116 (can't access network volume)

 

 

Also,

What is the reference above? " Can't export "MainBackupreport......" Where is this defined? Apparently I need to update the credentials or location?

thank you in advance for any input,

David_M

[wdm@duostech.com]

Ok, I found the report option and changed it.

So, I have already fixed this issue: Can't export "MainBackupReport.utx", error -1116 (can't access network volume)

 

Do, still have questions about the sql backup errors...

thanks,

david_m

[natew]

Hi

 

This is covered briefly in the Retrospect manual.

 

If you look at the log you will see a copy and compare phase in your backups. The errors you are seeing happen on compare. It simply means the files changed a bit from the time they were copied into the backup.

 

At any rate it is best to stop or export your databases for backup.

 

Are you trying to save the backup report on a local disk?

 

Thanks

Nate