从3月18日开始到4月3日是备份失败的
GROUPSIZE 7
OPERATION BACKUP
DATABASE “DBADB”
SQLHOST “yicatong”
NBSERVER “NBUMASTER01”
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE “master”
SQLHOST “yicatong”
NBSERVER “NBUMASTER01”
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE “model”
SQLHOST “yicatong”
NBSERVER “NBUMASTER01”
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE “msdb”
SQLHOST “yicatong”
NBSERVER “NBUMASTER01”
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE “ReportServer”
SQLHOST “yicatong”
NBSERVER “NBUMASTER01”
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE “ReportServerTempDB”
SQLHOST “yicatong”
NBSERVER “NBUMASTER01”
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE “YKTDB”
SQLHOST “yicatong”
NBSERVER “NBUMASTER01”
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
INF – BACKUP STARTED USING
Microsoft SQL Server 2012 – 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Batch = D:\nbu_sql_scripts\sql_full_20180209.bch, Op# = 1
INF – Using backup images yicatong.MSSQL7.YICATONG.db.DBADB.~.7.001of002.20190403090521..C to yicatong.MSSQL7.YICATONG.db.DBADB.~.7.002of002.20190403090521.C
INF – backup database “DBADB” to VIRTUAL_DEVICE=’VNBU0-15244-14384-1554253523′, VIRTUAL_DEVICE=’VNBU1-15244-14384-1554253523′ with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 4
INF – Number of stripes: 2, Number of buffers per stripe 2.
INF – Created VDI object for SQL Server instance <yicatong>. Connection timeout is <300> seconds.
Backup started Wed Apr 03 09:05:23 2019
INF – Thread has been closed for stripe #0
INF – Thread has been closed for stripe #1
INF – OPERATION #1 of batch D:\nbu_sql_scripts\sql_full_20180209.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 52(2) seconds
INF – BACKUP STARTED USING
Microsoft SQL Server 2012 – 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Batch = D:\nbu_sql_scripts\sql_full_20180209.bch, Op# = 2
INF – Using backup images yicatong.MSSQL7.YICATONG.db.master.~.7.001of002.20190403090616..C to yicatong.MSSQL7.YICATONG.db.master.~.7.002of002.20190403090616.C
INF – backup database “master” to VIRTUAL_DEVICE=’VNBU0-15244-13624-1554253577′, VIRTUAL_DEVICE=’VNBU1-15244-13624-1554253577′ with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 4
INF – Number of stripes: 2, Number of buffers per stripe 2.
INF – Created VDI object for SQL Server instance <yicatong>. Connection timeout is <300> seconds.
INF – Thread has been closed for stripe #1
INF – Thread has been closed for stripe #0
INF – OPERATION #2 of batch D:\nbu_sql_scripts\sql_full_20180209.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 18(2) seconds
INF – BACKUP STARTED USING
Microsoft SQL Server 2012 – 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Batch = D:\nbu_sql_scripts\sql_full_20180209.bch, Op# = 3
INF – Using backup images yicatong.MSSQL7.YICATONG.db.model.~.7.001of002.20190403090637..C to yicatong.MSSQL7.YICATONG.db.model.~.7.002of002.20190403090637.C
INF – backup database “model” to VIRTUAL_DEVICE=’VNBU0-15244-11384-1554253598′, VIRTUAL_DEVICE=’VNBU1-15244-11384-1554253598′ with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 4
INF – Number of stripes: 2, Number of buffers per stripe 2.
INF – Created VDI object for SQL Server instance <yicatong>. Connection timeout is <300> seconds.
INF – Thread has been closed for stripe #1
INF – Thread has been closed for stripe #0
INF – OPERATION #3 of batch D:\nbu_sql_scripts\sql_full_20180209.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 17(2) seconds
INF – BACKUP STARTED USING
Microsoft SQL Server 2012 – 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Batch = D:\nbu_sql_scripts\sql_full_20180209.bch, Op# = 4
INF – Using backup images yicatong.MSSQL7.YICATONG.db.msdb.~.7.001of002.20190403090657..C to yicatong.MSSQL7.YICATONG.db.msdb.~.7.002of002.20190403090657.C
INF – backup database “msdb” to VIRTUAL_DEVICE=’VNBU0-15244-8868-1554253618′, VIRTUAL_DEVICE=’VNBU1-15244-8868-1554253618′ with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 4
INF – Number of stripes: 2, Number of buffers per stripe 2.
INF – Created VDI object for SQL Server instance <yicatong>. Connection timeout is <300> seconds.
INF – Thread has been closed for stripe #1
INF – Thread has been closed for stripe #0
INF – OPERATION #4 of batch D:\nbu_sql_scripts\sql_full_20180209.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 23(5) seconds
INF – BACKUP STARTED USING
Microsoft SQL Server 2012 – 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Batch = D:\nbu_sql_scripts\sql_full_20180209.bch, Op# = 5
INF – Using backup images yicatong.MSSQL7.YICATONG.db.ReportServer.~.7.001of002.20190403090722..C to yicatong.MSSQL7.YICATONG.db.ReportServer.~.7.002of002.20190403090722.C
INF – backup database “ReportServer” to VIRTUAL_DEVICE=’VNBU0-15244-11640-1554253643′, VIRTUAL_DEVICE=’VNBU1-15244-11640-1554253644′ with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 4
INF – Number of stripes: 2, Number of buffers per stripe 2.
INF – Created VDI object for SQL Server instance <yicatong>. Connection timeout is <300> seconds.
INF – Thread has been closed for stripe #1
INF – Thread has been closed for stripe #0
INF – OPERATION #5 of batch D:\nbu_sql_scripts\sql_full_20180209.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 24(2) seconds
INF – BACKUP STARTED USING
Microsoft SQL Server 2012 – 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Batch = D:\nbu_sql_scripts\sql_full_20180209.bch, Op# = 6
INF – Using backup images yicatong.MSSQL7.YICATONG.db.ReportServerTempDB.~.7.001of002.20190403090748..C to yicatong.MSSQL7.YICATONG.db.ReportServerTempDB.~.7.002of002.20190403090748.C
INF – backup database “ReportServerTempDB” to VIRTUAL_DEVICE=’VNBU0-15244-5356-1554253669′, VIRTUAL_DEVICE=’VNBU1-15244-5356-1554253670′ with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 4
INF – Number of stripes: 2, Number of buffers per stripe 2.
INF – Created VDI object for SQL Server instance <yicatong>. Connection timeout is <300> seconds.
INF – Thread has been closed for stripe #1
INF – Thread has been closed for stripe #0
INF – OPERATION #6 of batch D:\nbu_sql_scripts\sql_full_20180209.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 18(2) seconds
INF – BACKUP STARTED USING
Microsoft SQL Server 2012 – 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Batch = D:\nbu_sql_scripts\sql_full_20180209.bch, Op# = 7
INF – Using backup images yicatong.MSSQL7.YICATONG.db.YKTDB.~.7.001of002.20190403090808..C to yicatong.MSSQL7.YICATONG.db.YKTDB.~.7.002of002.20190403090808.C
INF – backup database “YKTDB” to VIRTUAL_DEVICE=’VNBU0-15244-12528-1554253689′, VIRTUAL_DEVICE=’VNBU1-15244-12528-1554253689′ with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 4
INF – Number of stripes: 2, Number of buffers per stripe 2.
INF – Created VDI object for SQL Server instance <yicatong>. Connection timeout is <300> seconds.
INF – ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Server Native Client 11.0][SQL Server]已处理百分之 10。>.
INF – ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Server Native Client 11.0][SQL Server]已处理百分之 20。>.
INF – ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Server Native Client 11.0][SQL Server]已处理百分之 30。>.
INF – ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Server Native Client 11.0][SQL Server]已处理百分之 40。>.
INF – ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Server Native Client 11.0][SQL Server]已处理百分之 50。>.
INF – ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Server Native Client 11.0][SQL Server]已处理百分之 60。>.
INF – ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Server Native Client 11.0][SQL Server]已处理百分之 70。>.
INF – ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Server Native Client 11.0][SQL Server]已处理百分之 80。>.
INF – ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Server Native Client 11.0][SQL Server]已处理百分之 90。>.
INF – Thread has been closed for stripe #0
INF – Thread has been closed for stripe #1
INF – OPERATION #7 of batch D:\nbu_sql_scripts\sql_full_20180209.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 326(279) seconds
INF – Results of executing <D:\nbu_sql_scripts\sql_full_20180209.bch>:
<7> operations succeeded. <0> operations failed.
原因:,因为NBUADMIN帐户过期问题,导致NBU服务无启动
