Unable to backup WSUS 3.0 Database due to extra backslash characte Claus H. 6/6/2007 1:21:00 PM After installing WSUS 3.0 on a new Win2003R2 server I am unable to backup the MICROSOFT##SSEE\SUSDB database. Backup Exec 11d tells me that the reason is that it contains extra backslash characters. I have tried to detach the database using the sql admin tool, but are not able to connect to the database, I think it is locked by design. Has anyone experienced this problem and have a solution on how to detach the database so I can change the double backslash problem ?

Re: Unable to backup WSUS 3.0 Database due to extra backslash characte "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 6/7/2007 1:14:19 AM "Claus H." <Claus H.[ at ]discussions.microsoft.com> wrote in message news:20524D1C-2EB8-41AE-AFF6-865EA9F28B4F[ at ]microsoft.com... [Quoted Text] > After installing WSUS 3.0 on a new Win2003R2 server I am unable to backup > the > MICROSOFT##SSEE\SUSDB database. > Backup Exec 11d tells me that the reason is that it contains extra > backslash > characters. First, I would confirm with Symantec that BackupExec 11d supports the Microsoft SQL Server 2005 Embedded Edition database server. > I have tried to detach the database using the sql admin tool, Why would you do that? > but are not able to connect to the database, I think it is locked by > design. Actually, it only operates on Named Pipes =and= the SSMS tool must be installed on the WSUS server. > Has anyone experienced this problem and have a solution on how to detach > the > database so I can change the double backslash problem ? Why would you want to detach the databse, and change an alleged double backslash problem, when you don't even have documentation on the database, and have no knowledge of whether what you're doing will break your WSUS server or not? HINT: Use NTBACKUP as documented in the WSUS 3 Deployment Guide! -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com ..... >

Re: Unable to backup WSUS 3.0 Database due to extra backslash characte pl4tinum[ at ]gmail.com 6/18/2007 12:48:36 PM I have the same problem. I have Symantec Backup Exec on that machine locally, I don't want to use NTBackup. It's saying there are consecutive backslashes in the database path. Is there any way to change that and have WSUS still work? What I'm doing so far is running a scheduled task that uses NTBackup to back it up to a backup file and then I back that file up... but I'd rather not have to do that. Any ideas anyone? Thank you. Chris

Re: Unable to backup WSUS 3.0 Database due to extra backslash characte dwortmann[ at ]gmail.com 6/19/2007 1:30:25 PM I have the same issue. I had this issue with another vendors database and was able to edit a table in the master database and remove the extra backslash. Does anyone know how to access the WSUS 3.0 database to edit it?

Re: Unable to backup WSUS 3.0 Database due to extra backslash characte "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 6/21/2007 12:18:31 AM <dwortmann[ at ]gmail.com> wrote in message news:1182259825.111266.180240[ at ]o61g2000hsh.googlegroups.com... [Quoted Text] >I have the same issue. I had this issue with another vendors database > and was able to edit a table in the master database and remove the > extra backslash. Does anyone know how to access the WSUS 3.0 database > to edit it? The same way you would access any other database. Install the client tools, register the server, and voila. The only complication is that using the Windows Internal Database, you must install the SQL Client Tools on the WSUS server, and use Named Pipes for the connetion. -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....