I have added the db device name without .dat extension on our stand by system. and it is causing problem when I restore backup from the Live system which contain the device name as prod05.dat. So i need to rename the device name to prod05.dat.
How can I do this please?
Please explain your problem in more detail.
Device names should not cause any problems during a database load.
The don't have to be named the same or even be of exact same size.
As long as the overall sizes match what you see from
select * from sysusages where dbid=<yourdbid> order by lstart