File Name change on data files and transaction log 1

[Aeros]

We had a developer who developed two databases that were identical but each for its own site. They created the first one and duplicated for the second site.

When he did this for DB2 he gave it a different database name and datafile that it points to. Now when I look under the DB2 properties in the 'Data Files' and 'Transaction Log' tabs the 'File Name' still says DB1 where it should be DB2. The actual location points to the new DB2.mdf and DB2.log files so thats fine.

I just dont know if the same 'File Name' for 2 different DB's will cause a problem or not...or is it possible to change the second one (preferable)

Thanks

 

[mrdenny]

The name of the file won't case any problems. However it's easy enough to change.

alter database DB2
modify file (name=db1_data, newname=db2_data)
go
alter database DB2
modify file (name=db1_log, newname=db2_log)
go

That's all there is to it.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Aeros]

Perfect...thanks!