I get each morning a backup from a DB (1,5GB) from server 1
In server 2 i have made some stored procedures and create some relationships to handle something.
When i took the restore database -
all my stored-prcedures are deleted and also the relationships i create in server2.
I need to restore the backup without deleting the relationships or the created stored procedures in server2.
What is the best way to get the goal?