Solved

Best way to restore Datas in MSSQL without deleting Stored prozedures

Posted on 2014-03-02
3
149 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 81

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Introduction People like FTP.  It's a solid, stable, robust protocol for quickly transferring files between two hosts using TCP/IP.  In most cases it's much faster than SMB or CIFS, and certainly much easier to set up between organizations.  This…
Preface There are many applications where some computing systems need have their system clocks running synchronized within a small margin and eventually need to be in sync with the global time. There are different solutions for this, i.e. the W3…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

752 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