General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
How to rename MDF and LDF files
Environment versions
SQL Server:
SQL Server 2005
I would like to rename my MDF and LDF files. Example ECPVGH.MDF and ECPVGH.LDF to ECPVCH.MDF and ECPVCH.LDR. In enterprise manage, if I rename the database, this only renames the logical name, but the MDF and LDF files remain with the old name. Same goes for using sp_renamedb.
Any ideas?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only