cancel
Showing results for 
Search instead for 
Did you mean: 

failed to backup sql server

O-a
Level 4

Hello

 

I'm having a problem to backup 1 sql server(from 20 sql servers in the same policy) in the last 3 days.

I'm using Netbackup 6.5.6.

the two servers are in the same lan without fireawll between them.

i get status code 2 and in the Dbclient i get this error for every DB .

13:29:39.500 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:39.500 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:39.671 [3572.4888] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2371 TO 192.168.1.82.13724
13:29:40.062 [3572.4888] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
13:29:40.062 [3572.4888] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
13:29:40.062 [3572.4888] <4> getServerName: Read server name from nb_master_config: bakupserver
13:29:40.062 [3572.4888] <4> CDBIniParms::CDBIniParms: INF - NT User is administrator
13:29:40.078 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_1>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:40.187 [3572.4888] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <DBclient\> has been made using standard security with DSN <NBMSSQL_3572_4888_1>
13:29:40.187 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:40.187 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_1>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:40.203 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:40.203 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_1>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:40.250 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:40.250 [3572.4888] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <DBclient> on server <DBclient>.
13:29:40.265 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:40.265 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:40.437 [3572.4888] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2373 TO 192.168.1.82.13724
13:29:40.843 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:40.843 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:41.000 [3572.4888] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2374 TO 192.168.1.82.13724
13:29:41.375 [3572.4888] <4> CDBbackmain::OperationsAreGroupable: INF - The batch file is not groupable because a standard policy type has been selected for backup.
13:29:41.406 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_2>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:41.421 [3572.4888] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <DBclient\> has been made using standard security with DSN <NBMSSQL_3572_4888_2>
13:29:41.421 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:41.437 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_2>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:41.453 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:41.453 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_2>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:41.468 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:41.468 [3572.4888] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <DBclient> on server <DBclient>.
13:29:41.484 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:41.484 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:41.640 [3572.4888] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2376 TO 192.168.1.82.13724
13:29:42.140 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:42.140 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:42.296 [3572.4888] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2377 TO 192.168.1.82.13724
13:29:42.796 [3572.4888] <4> CDBbackrec::CDBbackrec: INF - Use standard backup method with policy <1>.
13:29:43.906 [3572.5424] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_2>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:43.921 [3572.5424] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:43.921 [3572.5424] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_2>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:43.953 [3572.5424] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:43.953 [3572.5424] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_2>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:44.000 [3572.5424] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:44.000 [3572.5424] <4> Dbbackrec::PerformNBOperation: INF - BACKUP STARTED USING

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup.bch, Op# = 1
13:29:44.000 [3572.5424] <4> InitPipeInfo: INF - Using backup image DBclient.MSSQL7.DBclient.db.db1.~.7.001of001.20110216132942..C
13:29:44.000 [3572.5424] <4> Dbbackrec::CreateSQLcmdSyntax: INF - backup database "db1" to VIRTUAL_DEVICE='VNBU0-3572-5424-1297855784' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
13:29:44.000 [3572.5424] <4> Dbbackrec::CreateSQLcmdSyntax: INF - Number of stripes: 1, Number of buffers per stripe 2.
13:29:44.000 [3572.5424] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_2>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:44.015 [3572.2188] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:44.015 [3572.2188] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:44.031 [3572.5424] <4> CDBbackrec::InitDeviceSet(): INF - Created VDI object for SQL Server instance <DBclient>. Connection timeout is <300> seconds.
13:29:44.031 [3572.5424] <4> getServerName: Read server name from nb_master_config: bakupserver
13:29:44.156 [3572.2188] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2378 TO 192.168.1.82.13724
13:29:44.453 [3572.5424] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:44.453 [3572.5424] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:44.703 [3572.5424] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2379 TO 192.168.1.82.13724
13:29:45.203 [3572.5424] <16> CDBbackrec::InitDeviceSet_Part2(): ERR - Error in GetConfiguration: 0x80770004.
13:29:45.203 [3572.5424] <1> CDBbackrec::InitDeviceSet_Part2():     CONTINUATION: - An abort request is preventing anything except termination actions.
13:29:45.203 [3572.5424] <4> KillAllThreads: INF - Killing group #0
13:29:45.203 [3572.5424] <4> KillAllThreads: INF - Issuing SignalAbort to MS SQL Server VDI
13:29:45.203 [3572.3684] <4> KillAllThreads: INF - Killing group #0
13:29:45.218 [3572.2188] <4> KillAllThreads: INF - Killing group #0
13:29:45.218 [3572.1736] <4> KillAllThreads: INF - Killing group #0
13:29:45.218 [3572.5424] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <18210><[Microsoft][SQL Native Client][SQL Server]BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'VNBU0-3572-5424-1297855784'. Operating system error 0x8007000e(error not found).>.
13:29:45.218 [3572.5424] <16> CODBCaccess::LogODBCerr: DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]BACKUP DATABASE is terminating abnormally.>
13:29:45.218 [3572.5424] <16> Dbbackrec::PerformNBOperation: ERR - Error found executing <backup database "db1" to VIRTUAL_DEVICE='VNBU0-3572-5424-1297855784' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
13:29:45.218 [3572.5424] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:45.218 [3572.5424] <4> getServerName: Read server name from nb_master_config: bakupserver
13:29:45.234 [3572.5424] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:45.234 [3572.5424] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:45.375 [3572.5424] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2380 TO 192.168.1.82.13724
13:29:45.640 [3572.5424] <16> CDBbackrec::FreeDeviceSet(): ERR - Error in VDS->Close: 0x80770004.
13:29:45.640 [3572.5424] <1> CDBbackrec::FreeDeviceSet():     CONTINUATION: - An abort request is preventing anything except termination actions.
13:29:45.640 [3572.5424] <4> Dbbackrec::Perform: INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 3(0) seconds.
13:29:47.640 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_3>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:47.671 [3572.4888] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <DBclient\> has been made using standard security with DSN <NBMSSQL_3572_4888_3>
13:29:47.671 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:47.671 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_3>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:47.687 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:47.687 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_3>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:47.703 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:47.703 [3572.4888] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <DBclient> on server <DBclient>.
13:29:47.718 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:47.718 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:47.984 [3572.4888] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2381 TO 192.168.1.82.13724
13:29:48.375 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:48.375 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:48.640 [3572.4888] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2382 TO 192.168.1.82.13724
13:29:49.140 [3572.4888] <4> CDBbackrec::CDBbackrec: INF - Use standard backup method with policy <1>.
13:29:50.250 [3572.292] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_3>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:50.265 [3572.292] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:50.265 [3572.292] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_3>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:50.281 [3572.292] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:50.296 [3572.292] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_3>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:50.328 [3572.292] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:50.328 [3572.292] <4> Dbbackrec::PerformNBOperation: INF - BACKUP STARTED USING

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup.bch, Op# = 2
13:29:50.328 [3572.292] <4> InitPipeInfo: INF - Using backup image DBclient.MSSQL7.DBclient.db.db2.~.7.001of001.20110216132949..C
13:29:50.328 [3572.292] <4> Dbbackrec::CreateSQLcmdSyntax: INF - backup database "db2" to VIRTUAL_DEVICE='VNBU0-3572-292-1297855790' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
13:29:50.328 [3572.292] <4> Dbbackrec::CreateSQLcmdSyntax: INF - Number of stripes: 1, Number of buffers per stripe 2.
13:29:50.328 [3572.292] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_3>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:50.343 [3572.6052] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:50.343 [3572.6052] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:50.343 [3572.292] <4> CDBbackrec::InitDeviceSet(): INF - Created VDI object for SQL Server instance <DBclient>. Connection timeout is <300> seconds.
13:29:50.343 [3572.292] <16> CDBbackrec::InitDeviceSet_Part2(): ERR - Error in GetConfiguration: 0x80770004.
13:29:50.343 [3572.292] <1> CDBbackrec::InitDeviceSet_Part2():     CONTINUATION: - An abort request is preventing anything except termination actions.
13:29:50.343 [3572.292] <4> KillAllThreads: INF - Killing group #0
13:29:50.359 [3572.292] <4> KillAllThreads: INF - Issuing SignalAbort to MS SQL Server VDI
13:29:50.359 [3572.5496] <4> KillAllThreads: INF - Killing group #0
13:29:50.359 [3572.2064] <4> KillAllThreads: INF - Killing group #0
13:29:50.390 [3572.6052] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2383 TO 192.168.1.82.13724
13:29:50.812 [3572.6052] <4> KillAllThreads: INF - Killing group #0
13:29:50.812 [3572.292] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <18210><[Microsoft][SQL Native Client][SQL Server]BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'VNBU0-3572-292-1297855790'. Operating system error 0x8007000e(error not found).>.
13:29:50.812 [3572.292] <16> CODBCaccess::LogODBCerr: DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]BACKUP DATABASE is terminating abnormally.>
13:29:50.812 [3572.292] <16> Dbbackrec::PerformNBOperation: ERR - Error found executing <backup database "db2" to VIRTUAL_DEVICE='VNBU0-3572-292-1297855790' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
13:29:50.812 [3572.292] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:50.812 [3572.292] <4> getServerName: Read server name from nb_master_config: bakupserver
13:29:50.828 [3572.292] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:50.828 [3572.292] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:51.156 [3572.292] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2385 TO 192.168.1.82.13724
13:29:51.671 [3572.292] <16> CDBbackrec::FreeDeviceSet(): ERR - Error in VDS->Close: 0x80770004.
13:29:51.671 [3572.292] <1> CDBbackrec::FreeDeviceSet():     CONTINUATION: - An abort request is preventing anything except termination actions.
13:29:51.671 [3572.292] <4> Dbbackrec::Perform: INF - OPERATION #2 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 2(0) seconds.
13:29:53.687 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_4>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:53.750 [3572.4888] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <DBclient\> has been made using standard security with DSN <NBMSSQL_3572_4888_4>
13:29:53.750 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:53.765 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_4>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:53.781 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:53.781 [3572.4888] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_4>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:53.796 [3572.4888] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:53.796 [3572.4888] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <DBclient> on server <DBclient>.
13:29:53.812 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:53.812 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:53.890 [3572.4888] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2386 TO 192.168.1.82.13724
13:29:54.406 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:29:54.406 [3572.4888] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:29:54.656 [3572.4888] <2> logconnections: BPRD CONNECT FROM 192.168.1.8.2387 TO 192.168.1.82.13724
13:29:55.156 [3572.4888] <4> CDBbackrec::CDBbackrec: INF - Use standard backup method with policy <1>.
13:29:56.265 [3572.5064] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_4>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:56.281 [3572.5064] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:56.281 [3572.5064] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_4>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:56.296 [3572.5064] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:56.296 [3572.5064] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_3572_4888_4>, SQL userid <doamin\administrator> handle <0x011b1a20>.
13:29:56.328 [3572.5064] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x011b1a20>
13:29:56.343 [3572.5064] <4> Dbbackrec::PerformNBOperation: INF - BACKUP STARTED USING

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

 

 

 

Can someone help me with this problem.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Level 6
Partner    VIP    Accredited Certified

Have a look at this :
http://www.red-gate.com/supportcenter/Content?c=knowledgebase\SQL_Backup\KB200708000117.htm&p=SQL%20Backup

Extract:
Database backups may fail if the SQL Server memory is inadequate or severely fragmented. The free memory space of your SQL Server process may be severely fragmented. SQL Server reserves a set amount of memory for SQL Backup to use as buffer space,commonly known as the SQL Server MemToLeave area.

When a backup fails due to the lack of a large enough contiguous block of free memory, SQL Backup automatically retries the backup using smaller MAXTRANSFERSIZE values, until it hits the value of 65536 bytes.

View solution in original post

2 REPLIES 2

Marianne
Level 6
Partner    VIP    Accredited Certified

Have a look at this :
http://www.red-gate.com/supportcenter/Content?c=knowledgebase\SQL_Backup\KB200708000117.htm&p=SQL%20Backup

Extract:
Database backups may fail if the SQL Server memory is inadequate or severely fragmented. The free memory space of your SQL Server process may be severely fragmented. SQL Server reserves a set amount of memory for SQL Backup to use as buffer space,commonly known as the SQL Server MemToLeave area.

When a backup fails due to the lack of a large enough contiguous block of free memory, SQL Backup automatically retries the backup using smaller MAXTRANSFERSIZE values, until it hits the value of 65536 bytes.

O-a
Level 4

I increased the max memory on the sql server and it solved the problem.

 

thanks for the help