Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 840
  • Last Modified:

Change filenames and physical_name in sysaltfiles and sys.master_files

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?
1 Solution
In SQL 2005, direct updates to the system tables are not supported. Microsoft has closed the door.

The issue is mentioned in several Symantec hotfixes


cjohnson300Author Commented:
For other people, I detached and then reattached the database to the same location and that cleared the extra backslash problem.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now