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

Improve company productivity with a Business Account.Sign Up

x
 
ebertsysConnect With a Mentor Author Commented:
i get only the bak file.
is there a way to link the db like in access?
0
 
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.
0
 
ebertsysAuthor Commented:
i create views with external tables
0
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.