Solved

Best way to restore Datas in MSSQL without deleting Stored prozedures

Posted on 2014-03-02
3
163 Views
Last Modified: 2014-04-05
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?
0
Comment
Question by:ebertsys
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 82

Expert Comment

by:David Johnson, CD, MVP
ID: 39902112
cant you just mount the databases? a restore does just that it restores but the originating db doesn't have your stored procedures.
0
 

Accepted Solution

by:
ebertsys earned 0 total points
ID: 39902518
i get only the bak file.
is there a way to link the db like in access?
0
 

Author Closing Comment

by:ebertsys
ID: 39979834
i create views with external tables
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are trying to access the server, have you ever encountered "The terminal server has exceeded the maximum number of allowed connection" error?  or "The user is attempting to log on to a Terminal Server in Remote Administration mode, but the …
Samba is the de-facto standard program (or, more correctly: suite of programs) that UNIX and Linux systems use to share files with Microsoft Windows (and more recently, Mac OS-X) systems. Currently, there are 2 common versions of Samba available,…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question