November 30, 2005 at 1:03 pm
I recently did a SQL 2000 database conversion and at completion changed the database name to X. I left the names of the mdf and ldf files in their original state. I'm performong a DBCC prior to doing a backup. I've received 0 errors each time.
Wondering:
Does the DBCC run correctly even though the database name is different then the two mdf and ldf file names?
November 30, 2005 at 2:44 pm
Yes. The physical files can be named anything so long as they are compliant with the requirements Windows has for file names. DBCC finds the information in sysdatabases in the master database when you refer by database name, and from there it's able to figure out what it needs in order to do the job.
K. Brian Kelley
@kbriankelley
November 30, 2005 at 2:54 pm
Thanks for the response it's greatly appreciated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply