- 论坛徽章:
- 0
|
另外数据库备份出现的问题与解决方法在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 \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query.
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:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
sp_detach_db SUSDB
go
sp_attach_db susdb, 'C:\WSUS\UpdateServicesDbFiles\SUSDB.mdf', 'C:\WSUS\UpdateServicesDbFiles\SUSDB_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 编辑 ] |
|