Backup Log

[martin_mmj]

Hi all.

We have got VaultServer2008 instaled on WindowsServer2003(from SBS) with full SQL2005Server. I started CMD backup script Connectivity.ADMSConsole.exe with parameter -L"c:\Log.txt" for detail logging of backup process.

In this log I see :
21.7.2008 9:42:55 Replication could not replicate resource id: 21256 version id: 21257. Replication has tried all available sites.
21.7.2008 9:42:55 Replication continuing because orphans were allowed for this call.
21.7.2008 9:42:55 Replication could not replicate resource id: 21256 version id: 21353. Replication has tried all available sites.
21.7.2008 9:42:55 Replication continuing because orphans were allowed for this call.
.
.
Is any way how to locate this issues? How to determine filename for "id: 21256" etc.? Any ideas?

Thanks Martin

[Anonymous]

Hi Martin,

What you are seeing is that Vault 2008 validates the files in the filestore
as part of backup. If the file does not exist or the checksum does not
match, the information is logged. Unfortunately, in 2008 the messaging was
not ideal as you notice [this was improved in 2009]. However, the filenames
in question can be obtained if you don't mind getting your hands dirty. [In
this case, the issue is with two versions of the same file].

Here are some steps to get the information [from the command prompt on the
server machine].

Run:
OSQL -E -S .\AUTODESKVAULT

You should see a 1) prompt. Type in the following lines [hitting enter after
each]:

USE Vault
SELECT FileName FROM FileIteration WHERE FileIterationId IN (21257, 21353)
GO

[Note that in the first line, replace 'Vault' with your actual vault name if
different]

You should see a list of 2 file names [they may be the same since they are
versions of the same file]. This should help you identify the versions at
issue. If they are earlier versions, the simplest solution might be to purge
the files. You may also want to run ScanDisk on your hard drive to ensure
that there are no disk issues popping up that may have caused this problem.

Sorry this process is so involved. If you have any questions, please let me
know.

Paul Gunn

[martin_mmj]

Hi Paul,

big big big thanks. I run SELECT command in SQL Server Management Studio. I appreciate your help. Thank you again.

Martin