• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

Best way to restore Datas in MSSQL without deleting Stored prozedures

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
ebertsys
Asked:
ebertsys
  • 2
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
cant you just mount the databases? a restore does just that it restores but the originating db doesn't have your stored procedures.
0
 
ebertsysAuthor Commented:
i get only the bak file.
is there a way to link the db like in access?
0
 
ebertsysAuthor Commented:
i create views with external tables
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now