Rename database files both physical and logical, MS SQL SERVER 2005
Steps involved in renaming the database:
Rename the logical files
Detach the database
Rename the physical files
Attach the database as the new database, using the renamed files
Steps to rename the logical files:
a. Open the database properties, and select the “Files” tab from left:
b. Place the cursor in the cell, under the column “Logical [...]
Read the rest of this entry »