Solved

Best way to restore Datas in MSSQL without deleting Stored prozedures

Posted on 2014-03-02
3
134 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
  • 2
3 Comments
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
Comment Utility
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
Comment Utility
i get only the bak file.
is there a way to link the db like in access?
0
 

Author Closing Comment

by:ebertsys
Comment Utility
i create views with external tables
0

Featured Post

Do email signature updates give you a headache?

Do you feel like all of your time is spent managing email signatures? Too busy to visit every user’s desk to make updates? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today!

Join & Write a Comment

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,…
Goal:  To set up a secure SSH server for your home computer to make it accessible anywhere AND to use it as a port forwarding proxy. Steps 1.  WinSSHD version 5 is free for personal use.  So download and install it.  You can download it from the…
This video discusses moving either the default database or any database to a new volume.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now