Monday, March 19, 2012

How to change a data file name

Hi All,
Is anyone can help me to change a existing data file into a new new name?
Thanks.The logical name of the file, or the actual path and filename of the .NDF file?|||Logical name.|||Alter database DB modify file (name = 'old_name_of_file', newname = 'new_name_of_file')|||It worked good.
Thank you MCrowley, it's very helpful.

No comments:

Post a Comment