BE备份SQL数据库出错

Question

昨晚用BE备份一台服务器出错了，错误如附件：
报错说数据库前面多了一个斜杠？？！！我没写过什么斜杠啊，怎么会出现这个问题？

[ 本帖最后由 pet-dtg 于 2009-3-3 11:26 编辑 ]

Answer 1

无牙兄太利害了，我本来就头晕了，看见那么多文字头就更晕了！

Answer 2

太感谢了 。

Answer 3

另外数据库备份出现的问题与解决方法在Symantec的官方里找到了，在这贴出来吧，

Document ID: 312187
http://support.veritas.com/docs/312187 E-Mail this document to a colleague
Backup of the SQL instance "Microsoft##SSEE" fails with the error: V-79-57344-851 - The path for this database is invalid because it contains extra backslash characters. You must remove the extra backslash characters before the database can be backed up.
--------------------------------------------------------------------------------
Exact Error Message
V-79-57344-851 - The path for this database is invalid because it contains extra backslash characters. You must remove the extra backslash characters before the database can be backed up

Details:
"Microsoft##SSEE" is a Windows Internal Database also known as WSUS (Windows Server Update Services). The database views are useful for generating custom reports, get quick information on updates, approvals computers, downstream servers update installation, and computer inventory etc.
Add/Remove Programs show the database with the name "Windows Internal Database."
Resolution:
To correct this error, perform one the following step's:
Step 1 :
Detach and reattach the database using the SQL Management Studio or SQL Enterprise Manager Tools. For more information refer to the following Microsoft KB ID:
http://support.microsoft.com/kb/224071/
However, connecting to the database using "Microsoft##SSEE" as the instance name using SQL Management Studio fails to connect to the database.
Connection to the Windows Internal Database instance can be established by using a named pipe. The default format of the named pipe string for Windows Internal Database is \.pipeMSSQL$MICROSOFT##SSEEsqlquery.
Figure 1
  
Reference:  http://msdn.microsoft.com/en-us/library/bb410149(VS.85).aspx
Once connected, detach and attach the database.

Step 2 :
1 Stop the IIS Admin service and the Update Services service

Click Start, point to Programs, point to Administrative Tools, and then click Services.
Right-click IIS Admin Service, and then click Stop.
Right-click Update Services, and then click Stop.

2 Open the Command Prompt

Click Start, Click Run
Type CMD and click OK
This will open the Command Prompt

3 Type the following commands to Detach and Attach the SUSDB database. Please refer Figure 2
osql -E -S np:\.pipeMSSQL$MICROSOFT##SSEEsqlquery
sp_detach_db SUSDB
go
sp_attach_db susdb, 'C:WSUSUpdateServicesDbFilesSUSDB.mdf', 'C:WSUSUpdateServicesDbFilesSUSDB_log.ldf'
go

Figure 2
  

4 Open Services and then start the IIS Admin service and Update Services service.

Click Start, point to Programs, point to Administrative Tools, and then click Services.
Right-click IIS Admin Service, and then click Start.
Right-click Update Services, and then click Start.

5 Please Open the Backup Exec and Run the Backup Job again

Please Note : The Location of WSUS in the above mentioned example is the default location of WSUS. It may be different in your case. Please confirm the actual location of the WSUS folder on your server before submitting the query.

Related Documents:

294324: Error "V-79-57344-851 - The path for this database is invalid because it contains extra backslash characters. You must remove the extra backslash characters before the database can be backed up" appears while backing up SQL, if the database path has multiple backslashes
http://support.veritas.com/docs/294324

Supplemental Material:

System: Ref.# Description
Error Code: 0xe000353  The path for this database is invalid because it contains extra backslash characters. You must remove the extra backslash characters before the database can be backed up
UMI: V-79-57344-851  The path for this database is invalid because it contains extra backslash characters. You must remove the extra backslash characters before the database can be backed up

Acknowledgements
Microsoft
--------------------------------------------------------------------------------
Products Applied:
Backup Exec for Windows Servers 10d (10.1), 11d (11.0) 6235, 11d (11.0) 7170, 12.0, 12.5

Last Updated: November 19 2008 10:29 PM GMT
Expires on: 11-19-2009
Subscribe to receive critical updates about this document

Subjects:
Backup Exec for Windows Servers
   Agent For Sql: Backup-Restore
Languages:
English (US), French, German
Operating Systems:
Windows Server 2003
DataCenter, DataCenter (IA64), DataCenter (x64), DataCenter SP1, DataCenter SP1(IA64), DataCenter SP1(x64), DataCenter SP2, Datacenter SP2(x64), Enterprise (IA64), Enterprise (x64), Enterprise SP1(IA64), Enterprise SP1(x64), Enterprise SP2, Enterprise SP2(x64), Enterprise Server, Enterprise ServerSP1, R2, Standard Server, Standard Server SP1, Standard Server SP1 (x64), Standard Server SP2, Standard Server SP2 (x64), Standard Server(x64), Storage Server, Storage Server SP1, Storage Server SP2, Web Server, Web Server SP1, Web Server SP2

Windows Small Business Server 2003

Premium Edition, Premium Edition R2, Premium Edition SP1, Standard Edition, Standard Edition R2, Standard Edition SP1, Standard Edition SP2

--------------------------------------------------------------------------------
Symantec World Headquarters:
20330 Stevens Creek Blvd. Cupertino, CA 95014
World Wide Web: http://www.symantec.com,
Tech Support Web: http://entsupport.symantec.com,
E-Mail Support: http://seer.entsupport.symantec.com/email_forms,
FTP: ftp://ftp.entsupport.symantec.com or http://ftp.entsupport.symantec.com
THE INFORMATION PROVIDED IN THE SYMANTEC SOFTWARE KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SYMANTEC SOFTWARE DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SYMANTEC SOFTWARE OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES,EVEN IF SYMANTEC SOFTWARE OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

[ 本帖最后由 pet-dtg 于 2009-3-3 15:00 编辑 ]

Answer 4

shadow copy这项服务默认时手动的，在选择使用AOFO的时候要事先启动这项服务吗？
A:不需要事先启动，BE在用的时候会将其启动，该服务只要不disable就行。

另外对Exchange的备份不要使用AOFO.

如果是对系统全备，最好将exchange的和sql的路径放到exclude list中。

Answer 5

还没人吗？help～！！！

Answer 6

再附上任务的设置情况：

备份作业属性:Test3_DifferenceBackup_Singular

源
________________________________________
选定内容
选择项列表名称(S):        Test3_DifferenceBackup_Singular
选择项列表描述(P):        Test3_DifferenceBackup_Singular
选定内容/资源次序
选定内容
C:*.* /SUBDIR
First Storage Group*.* /SUBDIR
Microsoft SQL Server "BKUPEXEC"*.*
实用程序分区*.* /SUBDIR
阴影拷贝组件*.* /SUBDIR
系统状态*.* /SUBDIR
资源凭证
资源(R)        资源凭证
Test3        domain admin
C:         
First Storage Group         
Microsoft SQL Server "BKUPEXEC"         
实用程序分区         
阴影拷贝组件         
系统状态         
优先级和可用时段
将此备份选择项列表的可用时段限制为以下每日时间窗口(L): 否
作业优先级(P):        中

为此选择项列表启用自动取消(A):否
选择项列表通知
XXXXXX
XXXXXX

包括带通知到email或打印机接收者的作业日志(I): 否

目标
________________________________________
设备和介质
设备(D):        IBM 1
介质集(M):        Test3
当此作业开始时:        附加介质, 如果没有可附加介质则覆盖(P)
作业完成后，弹出介质(E): 否
写奇偶校验到介质: 是
备份前，重绕介质(T): 否
使用一次性写入、多次性读取 (WORM) 介质(U): 否

用于支持多数据流的资源的最大设备数量(X):        1
最小设备数量，如果可用设备低于该数目就终止作业(V):        1

设置
________________________________________
常规
作业名称(J):        Test3_DifferenceBackup_Singular
备份集描述(E):        Test3_DifferenceBackup_Singular
备份文件的方法(K):        差别 - 备份自上次完全备份以来更改过的文件 - 使用归档位 (不重置归档位)
压缩类型(M):        硬件(如果可用，否则为软件)
备份完成后检查(C): 是
高级
设置远程代理的优先级(T):        正常优先级
当不使用 Advanced Open File Option 时，则使用 Open File 备份:        带锁(W)
为NTFS卷启动单个实例备份(L): 否
紧随结合点备份文件和目录(C): 是
在远程存储备份数据(O): 否
网络与安全
加密密钥(Y):        无
允许受控介质服务器使用任意网络接口来访问远程代理(M): 否
Advanced Open File
使用 Advanced Open File Option(U): 是
Open File 配置: 自动选择 Open File 技术(A)
一次处理一个备份的逻辑卷(C): 是
使用Server Free Option(F): 否
Advanced Disk-based Backup
使用脱离主机备份将备份处理从远程计算机转移到介质服务器(U): 否
Microsoft SQL
备份方法(M):        差异备份 - 仅备份那些更改的数据库或文件组
备份前一致性检查(O):        物理检查
备份后一致性检查(C):        无
即使一致性检查失败也继续备份(F): 是
备份时使用奇偶校验(U) (SQL 2005): 否
创建 SQL 备份的盘上副本，放到数据库所在的 SQL 服务器上。(D): 否

Microsoft Exchange
备份方法(M):        差别 - 日志
备份方法(A):        完全 - 备份邮件 - 重置归档位
对邮件附件启用单一实例备份(E): 否
如果使用 Microsoft Volume Shadow Copy 服务 (VSS) 快照提供程序，则在备份前执行一致性检查(P): 是
一致性检查失败时继续备份(C): 是

如果 Exchange 2007 的备份源为 LCR 或 CCR(S):: 请从被动副本进行备份，如果不可用，请尝试从主动副本进行备份 (推荐)
通知
XXXXXXX
XXXXXXX

包括带通知到email或打印机接收者的作业日志(I): 否

频率
________________________________________
计划
按计划运行(A)
启动不早于 0:00:00 并不迟于 2:59:59
使计划在 2009-3-2上生效

计划运行备份
该月如下天数 1, 3, 5, 7, 9, 11, 13, 15, 17, 19, 21, 23, 25, 27, 29, 31
提交暂停的作业(U): 否

Answer 7

另外，在备份Exchange2003的时候，使用AOFO的话一般选择哪种快照技术？我选择“自动选择Open File技术”出错了，导致邮件服务器down了，我那个郁闷啊  ，shadow copy这项服务默认时手动的，在选择使用AOFO的时候要事先启动这项服务吗？
help！！附上日志，各位帮忙分析一下

[ 本帖最后由 pet-dtg 于 2009-3-3 11:35 编辑 ]