Environment
Netbackup Server = 7.1
Netbackup Client = 7.1
Product = SQL-Server 2005 with SP2(Backup which is restoring on SQL Server 2008 R2)
Product = SQL Server 2008R2 (Destination Server where the backup is being Restored)
I have a backup of SQL Server2005 with SP2 on Veritas Netbackup Server 7.1 Tape Library. I am tryiny to restore this sql 2005 sp2 backup on a SQL Server R2 which is being failed. I have got an TN which I dont feel it will help. But i tried it and wait for the result.
http://www.symantec.com/business/support/index?page=content&id=TECH88059
( As per the TN i replaced the 2 value to 1 of NUMBUFS )
Activity Monitor
6/24/2011 10:31:05 AM - begin Restore
6/24/2011 10:31:06 AM - Info dbclient(pid=11044) INF - RESTORE STARTED USING
6/24/2011 10:31:06 AM - Info dbclient(pid=11044) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
6/24/2011 10:31:06 AM - Info dbclient(pid=11044) Apr 2 2010 15:48:46
6/24/2011 10:31:06 AM - Info dbclient(pid=11044) Copyright (c) Microsoft Corporation
6/24/2011 10:31:06 AM - Info dbclient(pid=11044) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
6/24/2011 10:31:06 AM - Info dbclient(pid=11044) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\YearEnd_31-12-2010.bch, Op# = 1.
6/24/2011 10:31:06 AM - Info dbclient(pid=11044) INF - Using backup image sqlserver-2.MSSQL7.SQL-CLUSTER.db.MisDotNet.~.7.001of001.20101231180859..C
6/24/2011 10:31:06 AM - Info dbclient(pid=11044) INF - restore database "MisDotNet" from VIRTUAL_DEVICE='VNBU0-11044-9616-1308893466' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Bul' to 'B:\SQL2008R2-DATA\MisDotNet_Bul.NDF', move 'GTH' to 'H:\SQL2008R2-DATA\MisDotNet_MIS_History.NDF', move 'G_Live' to 'G:\SQL2008R2-DATA\MisDotNet_Gud_Live.NDF', move 'Mis-I_Data' to 'R:\SQL2008R2-DATA\MisDotNet.mdf', move 'Mis-I_Log' to 'T:\SQL2008R2-DATA\MisDotNet_log.ldf', replace
6/24/2011 10:31:07 AM - Info dbclient(pid=11044) INF - Number of stripes: 1, Number of buffers per stripe 2.
6/24/2011 10:31:07 AM - Info dbclient(pid=11044) INF - Created VDI object for SQL Server instance <DB-Secondary>. Connection timeout is <300> seconds.
6/24/2011 10:59:19 AM - Info dbclient(pid=11044) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]10 percent processed.>.
6/24/2011 11:26:52 AM - Info dbclient(pid=11044) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]20 percent processed.>.
6/24/2011 11:54:11 AM - Info dbclient(pid=11044) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]30 percent processed.>.
6/24/2011 12:21:20 PM - Info dbclient(pid=11044) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]40 percent processed.>.
6/24/2011 12:49:25 PM - Info dbclient(pid=11044) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]50 percent processed.>.
6/24/2011 1:14:58 PM - Info dbclient(pid=11044) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]60 percent processed.>.
6/24/2011 1:39:42 PM - Info dbclient(pid=11044) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]70 percent processed.>.
6/24/2011 2:02:44 PM - Info dbclient(pid=11044) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]80 percent processed.>.
6/24/2011 2:25:51 PM - Info dbclient(pid=11044) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]90 percent processed.>.
6/24/2011 2:49:37 PM - Info dbclient(pid=11044) DBMS MSG - ODBC return code <-1>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]100 percent processed.>.
6/24/2011 2:49:37 PM - Info dbclient(pid=11044) DBMS MSG - SQL Message <3241><[Microsoft][ODBC SQL Server Driver][SQL Server]The media family on device 'VNBU0-11044-9616-1308893466' is incorrectly formed. SQL Server cannot process this media family.>
6/24/2011 2:49:38 PM - Info dbclient(pid=11044) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.>
6/24/2011 2:49:38 PM - Info dbclient(pid=11044) ERR - Error found executing <restore database "MisDotNet" from VIRTUAL_DEVICE='VNBU0-11044-9616-1308893466' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Bul' to 'B:\SQL2008R2-DATA\MisDotNet_Bul.NDF', move 'GTH' to 'H:\SQL2008R2-DATA\MisDotNet_MIS_History.NDF', move 'G_Live' to 'G:\SQL2008R2-DATA\MisDotNet_Gud_Live.NDF', move 'Mis-I_Data' to 'R:\SQL2008R2-DATA\MisDotNet.mdf', move 'Mis-I_Log' to 'T:\SQL2008R2-DATA\MisDotNet_log.ldf', replace>.
6/24/2011 2:49:38 PM - Info dbclient(pid=11044) ERR - Error in VDS->Close: 0x80770004.
6/24/2011 2:49:38 PM - Info dbclient(pid=11044) CONTINUATION: - An abort request is preventing anything except termination actions.
6/24/2011 2:49:38 PM - Info dbclient(pid=11044) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\YearEnd_31-12-2010.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 15512(15512) seconds.
6/24/2011 2:49:39 PM - Info dbclient(pid=11044) ERR - Error in GetCommand: 0x80770004.
6/24/2011 2:49:39 PM - Info dbclient(pid=11044) CONTINUATION: - An abort request is preventing anything except termination actions.
6/24/2011 2:49:40 PM - Info dbclient(pid=11044) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\YearEnd_31-12-2010.bch>:
6/24/2011 2:49:40 PM - Info dbclient(pid=11044) <0> operations succeeded. <1> operations failed.
