sql 2008R2 备份
环境：
masterserver: AIX5.3 NBU6.5.5
client: windows 2008R2 + SQL 2008R2
客户端有几十个数据库实例，进行备份的时候，只备份部分实例，脚本使用向导自动生成的，日志也没有报错，各位大大有没有碰到过此类相关问题的
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（9）
这个早试过了，也只有部分能进行备份，NND
INF - BACKUP STARTED USING
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
Batch = D:scriptsbkall.bch, Op# = 1
INF - Using backup image SPS-2010DB01.MSSQL7.SPS-2010DB01.db.Application_Registry_Service_DB_14ea24a8efb444b48ba5e7dc6daf725e.~.7.001of001.20101220133744..C
INF - backup database "Application_Registry_Service_DB_14ea24a8efb444b48ba5e7dc6daf725e" to VIRTUAL_DEVICE='VNBU0-3808-6472-1292823465' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SPS-2010DB01>. Connection timeout is <300> seconds.
Backup started Mon Dec 20 13:37:46 2010
13:37:51 Initiating backup
13:37:57 INF - Starting bpbrm
13:38:01 INF - Data socket = NBUMASTER.IPC:21627;3bcd803ce247963c744cc939b39395be;4;300
13:38:01 INF - Name socket = NBUMASTER.IPC:21628;bdf17ef799da8a929718df438af3a21d;4;300
13:38:01 INF - Job id = 279275
13:38:01 INF - Backup id = SPS-2010DB01_1292823179
13:38:02 INF - Backup time = 1292823179
13:38:02 INF - Policy name = P-W-SPS-2010DB01-SQL
13:38:02 INF - Snapshot = 0
13:38:02 INF - Frozen image = 0
13:38:02 INF - Backup copy = 0
13:38:03 INF - Master server = NBUMASTER
13:38:03 INF - Media server = NBUMASTER
13:38:03 INF - Multiplexing = 0
13:38:03 INF - New data socket = NBUMASTER.IPC:21626;1d6d1569147816bbd8ef37f92259a5e2;4;300
13:38:03 INF - Use shared memory = 0
13:38:04 INF - Compression = 0
13:38:04 INF - Encrypt = 0
13:38:04 INF - Keep logs = 28
13:38:04 INF - Client read timeout = 300
13:38:04 INF - Media mount timeout = 0
13:38:15 INF - Data buffer size = 262144
13:38:16 INF - Waiting for mount of media id 0084L3 on server NBUMASTER for writing
13:38:25 INF - Mounted media id 0084L3
13:38:25 INF - Beginning backup on server NBUMASTER of client SPS-2010DB01
INF - Thread has been closed for stripe #0
13:38:35 INF - Server status = 0
13:38:37 INF - Backup by Veritas on client SPS-2010DB01 using policy P-W-SPS-2010DB01-SQL, sched Default-Application-Backup:the requested operation was successfully completed
INF - OPERATION #1 of batch D:scriptsbkall.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 58(1) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
Batch = D:scriptsbkall.bch, Op# = 2
INF - Using backup image SPS-2010DB01.MSSQL7.SPS-2010DB01.db.Application_Registry_Service_DB_77ff888bb30641b4a207c7892a04a8ba.~.7.001of001.20101220133845..C
INF - backup database "Application_Registry_Service_DB_77ff888bb30641b4a207c7892a04a8ba" to VIRTUAL_DEVICE='VNBU0-3808-6620-1292823526' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SPS-2010DB01>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #2 of batch D:scriptsbkall.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 48(1) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
Batch = D:scriptsbkall.bch, Op# = 3
INF - Using backup image SPS-2010DB01.MSSQL7.SPS-2010DB01.db.Application_Registry_Service_DB_80ebc417e37c4fce921d36fc0373795e.~.7.001of001.20101220133935..C
INF - backup database "Application_Registry_Service_DB_80ebc417e37c4fce921d36fc0373795e" to VIRTUAL_DEVICE='VNBU0-3808-3640-1292823576' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SPS-2010DB01>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #3 of batch D:scriptsbkall.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 48(0) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
Batch = D:scriptsbkall.bch, Op# = 4
INF - Using backup image SPS-2010DB01.MSSQL7.SPS-2010DB01.db.Bdc_Service_DB_8f7a4d759b5647a2af0699fd06f84df8.~.7.001of001.20101220134026..C
INF - backup database "Bdc_Service_DB_8f7a4d759b5647a2af0699fd06f84df8" to VIRTUAL_DEVICE='VNBU0-3808-6456-1292823627' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SPS-2010DB01>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #4 of batch D:scriptsbkall.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 47(1) seconds
INF - Results of executing <D:scriptsbkall.bch>:
<4> operations succeeded. <0> operations failed.
还有个方法，就是别写ALL，而是把所有的实例名都写上去，然后看看可以不，这也许也是个方法，hoho
我做的是全备份，不是差异备份，给800开了个case，
RPWT
呵呵
你是不是备份master库，做的差异备份？
我刚有试过，之前不能备份，单独选择可以正常备份，我就奇怪了，为什么选择all的时候会备份不了
把不能备的单独列出来
备份看看
不行的话，通过SQL自己的备份看看
OPERATION BACKUP
DATABASE $ALL
SQLHOST "2010DB01"
NBSERVER "NBUMASTER"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
脚本贴出来看看呗，是不是脚本没写对呀