Restoring from msdb with only .mdf and .ldf files

I am working on an issue with an undocumented application, and the info is/was on a SS7 database, that was not maintained properly.
How can I restore jobs from msdb when all I have is either a backup of it (but don't want to restore it to another server's msdb) or no backup - just the .mdf and .ldf files?

Edgewood Solutions

I am working on an issue with an undocumented application, and the info is/was on a SS7 database, that was not maintained properly.

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

How can I restore jobs from msdb when all I have is either a backup of it (but don't want to restore it to another server's msdb) or no backup - just the .mdf and .ldf files?

You can restore this database to another server and just give the database a different name when you do the restore. From there, you could retrieve the job that you need and move that job to your other server.

This was last published in March 2007

Dig Deeper on SQL Server Backup and Recovery

All
News
Get Started
Evaluate
Manage
Problem Solve

Related Q&A from Greg Robidoux

Synchronize databases on two separate active servers

Synchronize databases on separate servers without using SANs. Learn options for server failover in SQL Server including log shipping, database ... Continue Reading

SQL Server error message: "Server out of memory"

Avoid restoring your SQL Server database to solve the SQL Server error message "server out of memory." The problem could be the memory settings. Continue Reading

Restoring a SQL Server database with a corrupt data file

Find out how to restore data from a corrupt database. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Data-driven strategy grooms dog care franchise for growth

Camp Bow Wow is growing its day care and boarding business for dogs with the help of a data-driven approach that's powered by a ...

Tableau acquisition of MIT AI startup aims at smarter BI software

Tableau acquires AI startup Empirical Systems in a plan to provide users with automated data modeling capabilities and enable ...

Choosing the right data discovery platform for the enterprise

Obviously, cost and scalability factor into data discovery platform buying decisions, but other features, like visualizations and...

SearchDataCenter

Why data centers need log management tools

Log files contain rich and useful management data. With the right software tools and a few navigation tips, you can maximize and ...

HPE gives its memory-driven computing initiative another try

HPE has brought its memory-driven computing architecture back into the spotlight, this time with a little help from its friends ...

HPE edge strategy reroutes data, apps around the cloud

HPE's upgraded converged infrastructure systems aim to help enterprises process and manage data outside their data centers and ...

SearchDataManagement

Hortonworks cloud options grow via Google, Microsoft, IBM

Hortonworks now supports Google Cloud Storage and has also broadened cloud deals with Microsoft and IBM, aiming to increase cloud...

Evolving data integration strategies target new analytics needs

Most companies don't have a shortage of data, but it's often stored in siloed systems or inconsistent formats -- problems that ...

What goes into a customer analytics data integration framework

Customer data integration is a minefield for IT teams to navigate. But incorporating a set of core technical functions into an ...

SearchAWS

Use service-linked IAM roles to simplify user permissions

While AWS IAM enables control over a cloud environment, it can become a management nightmare. Automate part of this process via ...

Don't overestimate the benefits of serverless computing

It's natural to be curious about new technologies, but the hype around serverless computing far outweighs its practical ...

AWS low-code strategy hones in on back-end services

AWS has yet to unveil a native and general-purpose low-code platform, but some of its services, such as Lex and Sumerian, seem to...

SearchOracle

AI-for-IT-operations tools map Vegas systems to Oracle ERP

Mapping IoT activity and other IT data to Oracle ERP is the task Las Vegas set for FixStream's AIOps platform in an effort to ...

Oracle 18c features give DBAs incremental database capabilities

Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but ...

Cloud workloads see gradual uptake, but miles to go for databases

A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying ...

SearchContentManagement

SharePoint hub sites raises migration questions among users

In the newest rev of SharePoint Online, what used to be sub-sites are now new freestanding sites. This change and others may ...

Cloud DAM platforms vs. on premises for digital asset management

Learn about digital asset management and how cloud DAM democratizes media management and delivery across the enterprise while ...

Box workflow gets upgrade with Progressly purchase

Box is hoping to upgrade its workflow capabilities by adding the startup Progressly to its team, while also still partnering with...

SearchWindowsServer

How to tackle an email archive migration for Exchange Online

A move from on-premises Exchange to Office 365 also entails determining the best way to transfer legacy archives. This tutorial ...

How to build a Packer image for Azure

Packer is an open source tool that automates the Windows Server image building process to give administrators a consistent ...

Thorough Exchange Server testing regimen eliminates doubt

Don't assume your Exchange 2016 implementation will work because you bought the right gear. Follow these pointers to execute a ...

Related Resources

Dig Deeper on SQL Server Backup and Recovery

Related Q&A from Greg Robidoux

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.