I have a
NON-PROD already has a copy of an application PROD database
I have also created new stored procedures on the
NON-PROD application database and made changes to a few old ones
If I were to take a fresh backup of the
PROD application database, and were to restore it on the
NON-PROD server, will this:
remove the new stored procedures which I created on the NON-PROD application database?
remove the changes made to the stored procedures (NON-PROD application database) which have the same name as on PROD application database, and replace them with the original one's from PROD application database?