SQL Agent, Backup SQL2000 with BES12.5

[Wanhermann]

Dear all,
i want to backup a SQL2000 Server (OS: Windos 2000 Server) with my BES 12.5 (OS: W2003Server)
We installed the last BES Agent on the SQL Server, in the selection on the BES i see the Databases,
if i want to backup it, i got the following message:

 

###
Completed status: Completed with exceptions

###

following message

###
Backup- server.domain

Database \p2pdatsf was not found, or could not be accessed.
###

last message

###

Backup- server.domain

The item server.domain\p2pdatsf in use - skipped.
###

The permissions are not the problem, any other idea?
cu

 

[Hemant_Jain]

Is this the only instance of SQL 2000 or you have other instances on the Windows 2000 server, that you are having trouble with backup. Does the Backup Exec logon account have administrative rights on SQL database and the instance?

Thanks

[Wanhermann]

both are YES
- yes, we have different instances, all with the same problem
- yes, first we try backup admin permissions, following from admin permissions

[Hemant_Jain]

Do you see any events in the SQL server event viewer, when the backup is initiated? What else does the job log show, apart from the message that you have displayed, it must have some other details.

Thanks

[Wanhermann]

Windows SQL Server Eventlog

Info

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date:  10/19/2009
Time:  3:59:12 PM
User:  GLOBAL\backupadmin
Computer: VIE-EU-SQL-01
Description:
8957 :
DBCC CHECKDB (Melin, noindex) executed by GLOBAL\backupadmin found 0 errors and repaired 0 errors.  Elapsed time: 0 hours 0 minutes 5 seconds.
 

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: fd 22 00 00 0a 00 00 00   ý"......
0008: 0e 00 00 00 56 00 49 00   ....V.I.
0010: 45 00 2d 00 45 00 55 00   E.-.E.U.
0018: 2d 00 53 00 51 00 4c 00   -.S.Q.L.
0020: 2d 00 30 00 31 00 00 00   -.0.1...
0028: 06 00 00 00 4d 00 65 00   ....M.e.
0030: 6c 00 69 00 6e 00 00 00   l.i.n...


Error

Event Type: Error
Event Source: Backup Exec
Event Category: None
Event ID: 57859
Date:  10/19/2009
Time:  3:59:07 PM
User:  N/A
Computer: VIE-EU-SQL-01
Description:
An error occurred while executing the following query: "DBCC CHECKDB([Integrity],NOINDEX)".
 On server: "VIE-EU-SQL-01".
 SQL error number: "03AE".
 SQL error message: "".
 
 For more information, click the following link:
http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
Data:
0000: ae 03 00 00 00 00 00 00   ®.......
0008: 00 00 00 00 00 00 00 00   ........




BES Details from the Log

+++
Set type               : Backup
Set status             : Completed
Set description        : 

Resource name          : \\Server\Microsoft SQL Server
Logon account          : global\backupadmin
Encryption used        : None

Error                  : e0008443 - One or more SQL Database consistency checks have failed.

Agent used                     : Yes
Advanced Open File Option used : No

Byte count             : 0 bytes
Rate                   : 0.00 MB/Min

Files                  : 0
Directories            : 0
Skipped files          : 10
Corrupt files          : 0
Files in use           : 0

Start time             : Monday, October 19, 2009 3:58:27 PM
End time               : Monday, October 19, 2009 3:59:30 PM

Media used             : 000119L4
File was skipped       : Server\db1_AT
File was skipped       : Server\db2_CH
File was skipped       : Server\db3_DE
File was skipped       : Server\db4
File was skipped       : Server\db5
File was skipped       : Server\db6
File was skipped       : Server\Integrity
File was skipped       : Server\Inventorydatabase
File was skipped       : Server\db7
File was skipped       : Server\db8

[Hemant_Jain]

As a test, i would like you to do this:
Go to the backup job properties, "Microsoft SQL" tab and set "consistency check before backup" to None. Run the backup job and check the results. It seems some of your databases have issues with consistency check. Please note that consistency check would help us determine any issues with the databases before starting the backup, it is recommended to perform them. If it is not working, something in the database needs to be checked.

Thanks

[Wanhermann]

exactly the same problem:

Job Settings:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Source
--------------------------------------------------------------------------------
Selections
Selection list name: server
Selection list description:  SQL Server Selection
Selections/Resource Order
Selections
server
Microsoft SQL Server\*.*
Microsoft SQL Server\PAMexchangeDB /EXCLUDE
Microsoft SQL Server\PAMFileDB /EXCLUDE
Microsoft SQL Server\PAMHSMDB /EXCLUDE
Microsoft SQL Server\PAMIndexDB /EXCLUDE
Microsoft SQL Server\msdb /EXCLUDE
Microsoft SQL Server\model /EXCLUDE
Microsoft SQL Server\master /EXCLUDE
Microsoft SQL Server\InventoryDB /EXCLUDE
C:\*.* /SUBDIR
System State\*.* /SUBDIR
Resource Credentials
Resources Resource Credentials
server global\backupadmin
Microsoft SQL Server global\backupadmin
C:  
System State  
Priority and Availability
Limit availability of this selection list for backup to the following daily time window: No
Job priority:  Medium
Enable automatic cancellation for this selection list: No
Selection List Notification
Include job log with a notification to an e-mail or printer recipient: No
Backup template: DailyBackup
Destination
--------------------------------------------------------------------------------
Device and Media
Device: Tape Drives VIE-EU-TAPE-02
Media set: DailyBackupPool Tape
Family name: Media created 19.10.2009 16:35:54
When this job begins:  Append to media, overwrite if no appendable media is available
Eject media after job completes: No
Write checksums to media: Yes
Retension media before backup: No
Password protect media: No
Use Write once, read many (WORM) media: No
Maximum number of devices to use for resources that support multiple data streams:  1
Minimum number of devices, terminate job if fewer devices are available:  1
Settings
--------------------------------------------------------------------------------
General
Template name: DailyBackup
Backup set description:  
Backup method for files: Incremental - Back up changed files since last full or incremental - Using archive bit (reset archive bit)
Compression type: Hardware [if available, otherwise none]
Verify after backup completes: Yes
Collect additional information for synthetic backup and for true image restore: No
Advanced
Set Remote Agent priority: Normal Priority
Open file backup when Advanced Open File Option is not used:  With a lock
Enable single instance backup for NTFS volumes: No
Back up files and directories by following junction points: Yes
Back up data in Remote Storage: No
Advanced Open File
Use Advanced Open File Option: No
Advanced Disk-based Backup
Use offhost backup to move backup processing from remote computer to media server: No
Microsoft SQL
Backup method: Full - Back up entire database or filegroup
Consistency check before backup: None
Consistency check after backup: None
Use checksum on backups (SQL 2005 or later): No
Create on-disk copies of SQL backups: No
Network and Security
Network interface:  Use any available network interface
Protocol:  Use any available protocol
Allow use of any available network interface, subnet, or protocol for remote agents not bound to the above network interface, subnet, or protocol: No
Encryption Type:  None
Encryption key:  None
Run backup immediately when Symantec ThreatCon reaches: No
Notification
Include job log with a notification to an e-mail or printer recipient: No
Frequency
--------------------------------------------------------------------------------
Schedule
Run according to schedule and run according to rules for this template
Start no earlier than 01:00:00 and no later than 06:00:00
Make the schedule go into effect on 17.09.2009
Schedule backup to run
On Tuesday, Wednesday, Thursday, Friday, Saturday of the first week
On Tuesday, Wednesday, Thursday, Friday, Saturday of the second week
On Tuesday, Wednesday, Thursday, Friday, Saturday of the third week
On Tuesday, Wednesday, Thursday, Friday, Saturday of the fourth week
On Tuesday, Wednesday, Thursday, Friday, Saturday of the last week
Submit job on hold: No
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

The Result

Set type               : Backup
Set status             : Completed
Set description        : 

Resource name          : \\Serrver\Microsoft SQL Server
Logon account          : global\backupadmin
Encryption used        : None

Agent used                     : Yes
Advanced Open File Option used : No

Byte count             : 0 bytes
Rate                   : 0,00 MB/Min

Files                  : 0
Directories            : 0
Skipped files          : 10
Corrupt files          : 0
Files in use           : 0

Start time             : Montag, 19. Oktober 2009 16:33:53
End time               : Montag, 19. Oktober 2009 16:34:13

Media used             : 000119L4
File was skipped       : Server\db_AT
File was skipped       : Server\db_CH
File was skipped       : Server\db_DE
File was skipped       : Server\db_EMEA
File was skipped       : Server\db_G4
File was skipped       : Server\db1
File was skipped       : Server\Integrity
File was skipped       : Server\Inventorydatabase
File was skipped       : Server\db2
File was skipped       : Server\db3

[Hemant_Jain]

Please go to the SQL server and set "create debug log" value in following registry key:
HKey_Local_Machine\Software\Symantec\Backup Exec for Windows\Backup Exec\Engine\Logging
to 1.
Restart "Remote Agent.... " service on the SQL server. Run the backup job again. Once, backup job completes, browse to c:\program files\symantec\backup exec\RAWS\logs folder and check "beremote... .log" file. There must be some more detailed error message in this file.

Thanks

[Wanhermann]

[3540] 10/19/09 17:34:12 Returning DB_CH
[3540] 10/19/09 17:34:12 Using the Virtual Device mechanism for the backup operation.
[3540] 10/19/09 17:34:12 VDI Open Timeout set to INFINITE
[3540] 10/19/09 17:34:12 VDI Buffer Timeout set to INFINITE
[3540] 10/19/09 17:34:12 SQL Agent VDI Check.
[3540] 10/19/09 17:34:12 SQL Agent VDI Check: Could not read ActivePath. Attempting to register.
[3540] 10/19/09 17:34:12 Attempting to unregister the SQL 2000\Yukon VDI DLL.
[3540] 10/19/09 17:34:12 Attempting to register the SQL 2000\2005 VDI DLL.
[3540] 10/19/09 17:34:12  >> SQL Agent: Could not find a SQL VDI to register!
[3540] 10/19/09 17:34:12 Error calling CoCreateInstance: x80040154
[3540] 10/19/09 17:34:12 Failed the Virtual Device allocation for backup operation.
[3540] 10/19/09 17:34:12 Destroying VirtualDeviceSet
[3540] 10/19/09 17:34:12 Informational, no operation thread handle to close.
[3540] 10/19/09 17:34:12 Informational - cannot deallocate Virtual Device object.
[3540] 10/19/09 17:34:12 LP_ENV::MsgError: error 0xe00084af processing object \DB_CH

[Wanhermann]

With the Info from the debug Log i found an existing Artikel

http://seer.entsupport.symantec.com/docs/300841.htm

???

[Hemant_Jain]

This is SQL VDI issue, is this a 64 bit OS? You might need an updated VDI, if it is.
Also, check the server for presence of sqlvdi.dll. If it is there, check permissions on that file. You may try giving "everyone" full rights if it does exist.

Thanks