MICROSOFT##SSEE V-79-57344-851 The path for this database is invalid because it contains extra backslash characters

After upgrading to WSUS 3.x we are unable to complete a backup with Symantec Backup Exec 11d of the WSUS / SUS db.  Backup- <server_name>\MICROSOFT##SSEE 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
sspeierAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sspeierAuthor Commented:
Be sure the "MS SQL Server 2005 Configuration Tools are installed

You have connect using "SQL Server Managment Studio Express" to the named pipe:
      \\.\pipe\mssql$microsoft##ssee\sql\query.  
            Select Windows Authentication
Connect to the database
Expand the databases node
Right click on SUSDB
      Select Tasks|Backup
      Select disk
            Click Add and choose an appropriate filename to save a backup of the SUSDB
Right Click on SUSDB
      Select Tasks
            Detach
                  Tick the "Drop Connections" box and then click on OK
Right Click on the databases node and select attach
      Click the Add box
            <location of WSUS DB> <default = D:\WSUS\UpdateServicesDbFiles>
                  You might have to navigate to the folder that you chose to store WSUS data in at installation time.  
            Click on SUSDB.mdf
            Click on OK
Click on OK again

SUSDB now is in its rightful place under the tree and now able to backup without error.  Please refer to this Microsoft technet article for further clarification:

http://technet2.microsoft.com/windowsserver/en/library/b4852133-5ed3-48d7-8a95-e7866e638c181033.mspx?mfr=true
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.