SQL DB Restore Problem

No,I haven't seen anything specific shown on an SQL, Exchange or other DB backup that shows the specific version number. By this I mean within BE itself.

Are you also trying to restore the SQL 2000 DB onto something newer?

Have you tried to duplicate the SQL DB to disk and then just mount it in SQL?

THanks!

SGMon debugging on the BE server and the remote server will give you the version number which is expected on the target machine.
 

First of all, thanks to both of you for your answers. I forwarded the information and the client just replied with some logfiles which were captured with the SGMon tool on both of the servers.

The only information concerning the SQL version can be found in the DC01-SGMon.log file. Please see the snippet below and the complete logfiles from both servers in the attachment.

Edit: It's easy to misinterpret my post. What I meant to say was I can't find the expected SQL DB in the logfiles. Do you have any hint how to get the information with SGMon?

BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL2_FindDrives - a default SQL Service is installed on DC01.
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL2_FindDrives - the default SQL Service appears to be SQL 2000.
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - IsServiceClusterOk called on DC01
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - Found SOFTWARE\MICROSOFT\MSSQLServer in the registry.
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 VCS cluster keys do not appear to be present in the registry
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 Failed to open VCS cluster ()
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL2_CreateDLE - creating DC01.
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL Version 2000
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - Found SOFTWARE\MICROSOFT\MSSQLSERVER in the registry.
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\ese]           - [FSYS:ESE07]   FindDrives ... This is not an Exchange Server (0)
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [beutil]             - Input Error (       0) for Type: (43)
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\shared]        - FS_BlowOutMachine: entered -->DC01<--
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\shared]        - FS_BlowOutMachine: device already in DLE list
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL2: Attempting attach with username ''
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL2_Connect worked.
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL Agent: Version String { 8.00.760 }
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL 2000 Service Pack 3.
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - Build = 760
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL edition returned: Enterprise Edition
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\shared]        - Attach to DC01
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\shared]        - Detach from DC01
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL DBClose
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL2_CleanUpSnapInfoList called.
BEREMOTE: [04.27.15 14:52:20] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL2: Attempting attach with username ''
BEREMOTE: [04.27.15 14:52:21] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL2_Connect worked.
BEREMOTE: [04.27.15 14:52:21] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL Agent: Version String { 8.00.760 }
BEREMOTE: [04.27.15 14:52:21] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL 2000 Service Pack 3.
BEREMOTE: [04.27.15 14:52:21] [0000]     04/27/15 14:52:18 [fsys\sql2]          - Build = 760
BEREMOTE: [04.27.15 14:52:21] [0000]     04/27/15 14:52:18 [fsys\sql2]          - SQL edition returned: Enterprise Edition

This is the error-

 attempt to restore Version 539 database to Version 4 instance

From BE 2012 onwards, we store version numbers as a single digit whereas older versions of BE used 3-digit version numbers. So if you are using BE 2012, pls ensure the media server and the remote agent are both patched with SP4 and then attempt the restore or, use an older version of BE to run the restore.

Hi VJware, thanks for your post! I got the reply that Backup Exec 2010 R3 is installed. If I read your post correctly, the restore should work with this version, right? Unfortunately, it doesn't work. :(

Do you have any other ideas? Maybe the restore has to be started with the version which was used back in 2006 (I'm guessing some old version of Veritas Backup)?

Edit: The exact version used to create the backup was: VERITAS Backup Exec 10.0.5484

The restore works with this version! Thank you so much VJware, you're a real lifesaver! :)