Best way to restore Datas in MSSQL without deleting Stored prozedures

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?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

ebertsysConnect With a Mentor Author Commented:
i get only the bak file.
is there a way to link the db like in access?
David Johnson, CD, MVPOwnerCommented:
cant you just mount the databases? a restore does just that it restores but the originating db doesn't have your stored procedures.
ebertsysAuthor Commented:
i create views with external tables
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.