Rename Content DB when moving Databases from MOSS servers

When we need to copy/move Database from MOSS server to another MOSS, there are times that we need to change the Content DB (WSS_Content) name.

The fastest way to do so is to backup the DataBase on the source server SQL and restore the DataBase to the destination server SQL. On the restore window in SQL we can determine the name of the DataBase that we want to restore. Now we can name the DataBase whatever we want.