Change filenames and physical_name in sysaltfiles and sys.master_files

Posted on 2007-10-02
Last Modified: 2008-01-09
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?
Question by:cjohnson300
    LVL 27

    Accepted 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

    Author Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now