Change filenames and physical_name in sysaltfiles and sys.master_files
Posted on 2007-10-02
This problem goes back to Symantec Backup Exec 11d failing because "The path for this database is invalid because it contains extra backslash characters". The database it was referring to was my WSUS 3 database. I installed SQL Server Management Studio Express on the same box as the WSUS database and it found the database and let me access it. I ran a couple of queries against the database "SELECT * FROM sysaltfiles" and "SELECT * FROM sys.master_files" and both of them point the SUSDB and the SUSDB_log to a path c:\WSUS\\UpdateServicesDBFiles\... (notice the two backslashes together). My question is, how can I change this path in these System Views to see if this fixes my backup problem?