Posts Tagged ‘sp_attach_db’

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 »