<div>
cant you just mount the databases? a restore does just that it restores but the originating db doesn't have your stored procedures.
</div>


cant you just mount the databases? a restore does just that it restores but the originating db doesn't have your stored procedures.

<div>
i create views with external tables
</div>


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


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?

Best way to restore Datas in MSSQL without deleting Stored prozedures

A server is a computer program or a machine that waits for requests from other machines or software (clients) and responds to them. This architecture is called the client–server model. The clients may run on the same computer or may connect to the server over a network. The purpose of a server is to share data or hardware and software resources among clients. Typical computing servers are database servers, file servers, mail servers, print servers, web servers, game servers, and application servers.

Server Software

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.