Home Forums SQL Server 2005 Administering Rename mdf and ldf files ? RE: Rename mdf and ldf files ?
Joy Smith San
SSC-Insane
Points: 24877
More actions
October 15, 2009 at 11:04 pm
#1066681
make sure you use alter database modify file command between offline and online so SQL knows the new name of the file. Otherwise database won't come back online.
Sorry !...Missed this step.
Thanks for correcting.