Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2005
Thanks Tracy, worked like a charm! In the attach dialog it assumed the old names and I had to correct those manually. I then renamed the database using the SQL manager interface, then corrected one instance of the logical name in the database properties.
>You should be able to just detach the database, rename the files, and then attach them again.
>
>
>>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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement