V-79-57344-34110 - AOFO: Initialization failure

[Eric_Jensen]

Hi All,

I am getting the following error when I try to backup databases on a SQL 2000 server.

V-79-57344-34110 - AOFO: Initialization failure on: "server.domain.local". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS).
SQL Prepare for Freeze failed for snapshot.
The following volumes are dependent on resource: "E:" .

Here is my setup.

Backup Exec for windows server version 11d running on Windows Server 2003 (32bit)

SQL server 2000 (SP4) (32bit) installed on Windows Server 2003 (64bit)

I have licensed the Backup Exec, and SQL agent.
And I have installed the Backup Exec agent and AOFO (64bit) on the SQL server and rebooted after the install.

I would appreciate any help anyone can offer me.

thanks!

[Philip_Pearson]

Check this out, it may be relevant for sql 2000 under 11d also

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

[Eric_Jensen]

Thanks for the link, however the article/change did not solve my problem.

I also see this in the Job Log incase it would be helpful...

Database \Northwind was not found, or could not be accessed.
The item voyager.NEWBEGPEDS.local\Northwind in use - skipped.Message was edited by:
Eric Jensen

[Philip_Pearson]

That sounds like a database selected for backup does not exist, northwind is a sample database you can choose to install on sql setup.

[Eric_Jensen]

Yes, i just chose that database for testing purposes. When you are choosing the selections for the backup job you can see all the databases, just none of them will backup.

Thanks,
Eric

[Philip_Pearson]

Is the backup exec service account a system administrator of SQL, does it have DBO access to all databases (not sure if it needs it but worth a shot), is the remote agent service using the backup exec user account?

[Jodie_Swafford]

I'm seeing a similar error, how ever this is on a Windows 2003 Std Server with SQL 2000 SP4.

Backup- \\SERVER\Utility Partition V-79-57344-34110 - AOFO: Initialization failure on: "SERVER". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS).
SQL Prepare for Freeze failed for snapshot.
Backup- SERVER The item SERVER\master in use - skipped.
The item SERVER\DB1 in use - skipped.
The item SERVER\DB2 in use - skipped.
The item SERVER\DB3 in use - skipped.
The item SERVER\DB4 in use - skipped.
The item SERVER\DB5 in use - skipped.
The item SERVER\DB6 in use - skipped.

Goes on to say "not found or could not be accessed."

[Eric_Jensen]

Yes on both questions.

Also, I am working with support on this issue and we turned on debugging for the remote agent and here is a section of entries I thought looked interesting...

SQL Agent VDI Check.
SQL Agent VDI Check: Could not read ActivePath. Attempting to register.
Attempting to unregister the SQL 2000\Yukon VDI DLL.
Attempting to register the SQL 2000\2005 VDI DLL.
>> SQL Agent: Could not find a SQL VDI to register!
Error calling CoCreateInstance: x80040154
Failed the Virtual Device allocation for backup operation.

[Philip_Pearson]

Find the sqlvdi and register it manually eg:

regsvr32 "C:\Program Files\Microsoft SQL Server\80\COM\sqlvdi.dll"

You should search for the sqlvdi.dll and if you find multiples register the latest.

It is probably not in the default location where the agent is looking for it.

[Eric_Jensen]

Thanks for the info, but it did not fix the problem.

I even tried without the AOFO option selected and I cannot backup any SQL databases. I also made sure the domain admin was added to the SQL\sysadmins group.

Both the VSS services on both server are set to manual so they should be able to start when requested.

Any other thoughts?

[Eric_Jensen]

Just wanted to post that my problem has been solved. Turns out there is a hotfix from Microsoft for the problem we were experiencing.
http://support.microsoft.com/?kbid=913100

Just incase someone else has the same problem now or in the future.

[Sahap_Yuzer]

I am having this exact same issue but the server is not a x64, it's a 32bit server.

Anyone know if there is a fix for the 32bit Windows Server 2003?

Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80040e4d. SQLSTATE: 42000, Native Error: 18456
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.

Message Edited by Sahap Yuzer on 05-04-200703:16 PM