Best way to restore Datas in MSSQL without deleting Stored prozedures

ebertsys
ebertsys used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
cant you just mount the databases? a restore does just that it restores but the originating db doesn't have your stored procedures.
Commented:
i get only the bak file.
is there a way to link the db like in access?

Author

Commented:
i create views with external tables

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial