All the secondary database files are generated with mdf extensions

[deepak_gajinkar]

Hi,

See I have set up DR Server with SQL database. The problem is that when it creates new database on DR Server, all the secondary files, which are with .ndf extension on primary servers, gets created as .mdf files instead of ndf files.

Can anybody tell me how to solve this problem.

Will it create any problem when the secondary(DR Server) act as Primary server in case of failure.

[clas_hortien]

Hello,

you can easily rename the files by following this procedure (see note 151603 for more details):

- detach the database from the server

- rename the files to the naming convention you like

- attach the database with the new names again

I do not exactly know what you mean with DR Server, but i assume that you mean

Log Shipping or Database Mirroring. Both are not affected from the different filenames as they are using only the internal database name (e.g. PRD).

Regards

Clas