why backup sql 2005 detect 0 Kb in each database

[riztyo]

hi....i need help
i have installed symantec backup exec 11d to backup process in seperate server.
i have database server which use sql 2005.
i confused why the databases detect 0 Kb for the size. only one database detected more than 0 Kb and another all detect 0 kb.
in fact all databases contain the data.
so.. my backup process just backuping the database which detect more than 0 Kb.
i already use user name that the priviladge is administrator in database server and database application.

thanks...

[SRodriguez]

Hi,

Are you getting an error? Or is just that is not backing then up at all?

Regards,

Sandra Rodriguez
Advanced Technical Support Engineer

[riztyo]

there is no error
because the size detect 0 kb when i select which database that i want to backup, so it can't backup.

[Kevin_Mikalsen]

Did you install the Agent for SQL Server license?

[riztyo]

yes, i have already installed SQL agent.
if i have not installed yet, the database was not  viewed in selection list when setting backup process, isn't it ?
in this case, the database are show, but i can't backup it.
i have so try, using advance open file (AOFO) for backup the database file from disk drive directory in SQL server.
i had installed open file agent to,but it same result, i can't backup it.

[SRodriguez]

Please, enable debug on the Media server and the Remote server, then browse a few times for the SQL 2005 files databases.  Then collect the logs using TN 285911 and send me the .cab file using PM. On the message, please include a link to this thread.

http://support.veritas.com/docs/275639

How to Enable Debug Logs using BEUtility feature of Backup Exec 10.x and 11.d for Windows Servers

http://support.veritas.com/docs/254212

How to enable or disable "debug logging" in Backup Exec for Windows Servers

http://support.veritas.com/docs/285911

How to collect Backup Exec 11d for Windows Servers log file information that is needed by Symantec Technical Support for troubleshooting purposes.

Regards,

Sandra Rodriguez
Advanced Technical Support Engineer

[riztyo]

i had sent u PM

[SRodriguez]

I got the file.  Let me review it.

Regards,

Sandra Rodriguez
Advanced Technical Support Engineer

[riztyo]

any update about this ?

[SRodriguez]

Hi,

It appear that the issue is with the VDI.  Please apply the HF for this VDI problems on SQL 2005

http://support.microsoft.com/kb/934396

Event Type: Error
Event Source: Backup Exec
Event Category: None
Event ID: 57859
Date:  7/12/2007
Time:  2:54:13 PM
User:  N/A
Computer: BMJKT-000048
Description:
An error occurred while executing the following query: "BACKUP DATABASE [cable_7] TO virtual_device = 'cable_7_00__dd1b2a2e_12a8_43a2_a768_9c2bc7aec9a2_'".
 On server: "BMJKT-000048".
 SQL error number: "0000".
 SQL error message: "Connection failure
".

 For more information, click the following link:
http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
Data:
0000: 00 00 00 00 00 00 00 00   ........
0008: 00 00 00 00 00 00 00 00   ........

Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date:  7/12/2007
Time:  2:54:13 PM
User:  N/A
Computer: BMJKT-000048
Description:
SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0). Process=4340. Thread=2564. Client. Instance=. VD=Global\cable_1_00__05aa697f_d17c_4686_9933_f61bea36ec7e__SQLVDIMemoryName_0.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Regards,

Sandra Rodriguez
Advanced Technical Support Enginee

[riztyo]

ok, i will try your suggestion.
i hope it will solve my problem,

thanks..

[Kai_Man]

Hello,

I have this errors which appear to come from Backup Exec 11d also.

I have tried the microsoft hot fix before, but no use.

Then I try to disable the AOFO function in the SQL Server 2005 Backup Job, it can be backup successfully.

any idea?

Best Regards,

Issac

[riztyo]

do you already get the new hotfix ?
because i read in microsoft website, the hotfix must be purchase for now or wait until newer service pack  released.

[David_Bond]

You dont need to buy the hotfix from microsoft, just call or email them and they will email it to you.

[Kai_Man]

Yes, you just need to ask microsoft. But it stated that:

WARNING: This fix is not publicly available through the Microsoft website as it has not gone through full Microsoft regression testing.  If you would like confirmation that this fix is designed to address your specific problem, or if you would like to confirm whether there are any special compatibility or installation issues associated with this fix, you are encouraged to speak to a Support Professional in Product Support Services.

Anyway, it still can not fix the problems.