Forum Discussion

Eric_Jensen's avatar
Eric_Jensen
Level 3
18 years ago

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

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!
11.x and Earlier
Backup and Recovery
Backup Exec

11 Replies

Sort By
  • Eric_Jensen's avatar
    Eric_Jensen
    Level 3
    18 years ago
    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.
  • Philip_Pearson's avatar
    Philip_Pearson
    Level 6
    18 years ago
    Check this out, it may be relevant for sql 2000 under 11d also

    http://support.veritas.com/docs/254554
  • Eric_Jensen's avatar
    Eric_Jensen
    Level 3
    18 years ago
    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's avatar
    Philip_Pearson
    Level 6
    18 years ago
    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's avatar
    Eric_Jensen
    Level 3
    18 years ago
    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's avatar
    Philip_Pearson
    Level 6
    18 years ago
    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's avatar
    Jodie_Swafford
    18 years ago
    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's avatar
    Eric_Jensen
    Level 3
    18 years ago
    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's avatar
    Philip_Pearson
    Level 6
    18 years ago
    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's avatar
    Eric_Jensen
    Level 3
    18 years ago
    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?