Solved

Missing stored prcedures after a database restore using Red Gate software

Posted on 2011-03-10
5
306 Views
Last Modified: 2012-08-13
On our Microsoft SQL 2005 server, we had a database corruption and during a restore process using Red Gate SQL Backup software, the stored procedures of the given database seem to be missing. Is this some funny little switch or something similar that is not restoring the procedures with the backup? If not, is there any way to get these back with the backups that we have. We've tried two separate backup files.
0
Comment
Question by:numb3rs1x
5 Comments
 

Author Comment

by:numb3rs1x
Comment Utility
Slight correction. I guess all but 3 very important SPs were restored. A very strange problem indeed. Any suggestions would be appreciated.
0
 
LVL 15

Accepted Solution

by:
MohammedU earned 500 total points
Comment Utility
It is not the switch. I believe it is either your backup file or restore process.

Have done the full restore? Yes then something wrong with your backup file or backup backup process.

If you are using object level recovery option in the restore process which is supported by some third party backup companies then you are not restored all the objects.

0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
The comment here http:http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26879286.html?#a35108863 answered the question or at the very least led the author to the solution.
0
 
LVL 1

Expert Comment

by:modus_operandi
Comment Utility
Starting auto-close process to implement the recommendations of the participating Expert(s).
 
modus_operandi
EE Admin
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

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

14 Experts available now in Live!

Get 1:1 Help Now