name field in sysfiles table

[barbola]

This happened I think from when we copied an existing company into a newly created one. The sysfiles and sysfiles1 table in some of our company databases have a different value in the "name" field. I'm wondering if I can just update these with a sql statement. For example:

name filename
GPSABCCODat.mdf d:\mssql7\DATA\XYZCO.mdf GPSABCCOLog.ldf d:\mssql7\DATA\XYZCO_log.ldf

I don't know how to paste a screen shot in here....but when I look at the properties of the database, on the DataFiles tab, the above values are also showing for filename and location for the mdf files.







Thanks!
Barb E.

 

[winthropdc]

Using SQL Enterprise Manager, you can detach the database and attach it again with the corrected paths. Make sure the correct mdf and ldf files are in the correct locations.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[barbola]

Yes the correct files have been attached, it's just the "name" field that has the incorrect name, and not sure where it comes from, and don't know how to change it.

The few companies that are like this have been this way for years,and work fine. I just wanted to change it.

Thanks!
Barb E.