• another newbie (10/23/2014)


    I managed to get it working by following the suggestion about backing up the db and then restoring it - you get the option to rename the mdf/ldf during the restore and can also rename the logical names after the restore via db properties... 🙂

    Not the best way to do it, totally unnecessary use of resources.

    To rename the files use ALTER DATABASE ... MODIFY FILE ...

    Once you have sent the alter commands to the database take it offline, again using ALTER DATABASE ... SET OFFLINE

    Rename the OS files to match the command you sent to the database, then bring the database online using ALTER DATABASE ... SET ONLINE

    Works flawlessly 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉