Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to rename MDF and LDF files
Message
 
À
08/05/2007 16:47:00
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01223590
Message ID:
01223606
Vues:
15
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
Fil
Voir

Click here to load this message in the networking platform