I am looking for the correct way to rename physical file names for SQL Server 2017 database. In 2008 R2 this was so easy to just detach, rename the mdf/ldf files, then reattach and point SSMS to the 'new' mdf/ldf files. However, in 2017 I cannot figure it out. I've found different postings when Googling, but they all seem to lead me to a dead end or are too complex for me to understand.
I would like, for example, to take a database I have attached as Database_1234 - which has physical file names of Database.mdf and Database.ldf - to be renamed to Database_1234.mdf and Database_1234.ldf.
I need the simplest, easiest, non-advanced DB admin way to do this. Thank you in advance.