Tara-1044200 (10/15/2009)
1. how do i rename mdf and ldf file names of a database without restoring or creating new database and move the data ?
Take the database OFFLINE. Go and change the MDF & LDF files name in it's locations and the take the DB online.
for db names is there a way we can list out mdf or ldf file names ?
Try
select name, filename from master.dbo.sysdatabases