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?

Greg Robidoux

Edgewood Solutions
Published: 30 Mar 2007

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?

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.

Dig Deeper on SQL Server Backup and Recovery

All
News
Get Started
Evaluate
Manage
Problem Solve

Related Q&A from Greg Robidoux

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

Restore SQL Server 2000 backups in SQL Server 2005

Restore backups in SQL Server 2000 and SQL Server 2005 with this command. Continue Reading

Back up tables from SQL Server 2005 database to a file

Back up tables from a SQL Server database to a file with these commands. 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

Oracle BI platform on the comeback trail

Time had seemingly left Oracle's business intelligence tools behind -- until the vendor responded by consolidating its BI ...

BI for mobile remains a challenge for vendors

While some BI vendors have developed effective mobile apps that provide concise insights, those that have attempted to recreate ...

Magento BI update a benefit to vendor's e-commerce customers

Magento rolled out the Magento Business Intelligence Summer 2019 Release, updating its BI platform with enhanced scheduling ...

SearchDataCenter

Can next-gen SIEM help cybersecurity initiatives?

More organizations are using SIEM, AI and cloud technology to minimize security breaches. Though despite interest, this ...

IBM z15 mainframe secures data across multi-cloud environments

IBM unveiled the latest in its line of mainframes capable of processing 1 trillion web transactions a day. The IBM z15 ...

Data center management as a service launches DCIM to the cloud

DMaaS is an option for organizations that want to use cloud-based management. Though these offerings hold a lot of promise, there...

SearchDataManagement

How big tech breakup would affect the tech industry

Breaking up the tech giants would be difficult and might create initial chaos in market, help smaller competitors and potentially...

Amazon Quantum Ledger Database brings immutable transactions

Based on technology built internally at Amazon, the tech giant's newest database provides a centralized approach for enabling a ...

Stibo Systems advances multidomain MDM system

The new Stibo Systems 9.2 update expands the MDM platform's features with Sisense business intelligence integration and machine ...

SearchAWS

Set AWS security automation in motion with these practices

Enterprises need to continuously improve their cloud security posture. Catch up on the latest expert advice on AWS security tools...

New details emerge about AWS Outposts as launch nears

AWS Outposts will ship later this year. In advance of that launch, AWS has given customers a sense of what they can expect from ...

Prepare for cloud security and shared responsibility

Organizations that move to the cloud must prepare to adapt their security playbooks. Learn how AWS' shared responsibility model ...

SearchOracle

The roots of Oracle's cloud evolution: A 20-year review

Oracle, like other prominent on-premises software vendors, has traced a long path into the cloud. These 10 events over the past ...

Oracle cloud ambitions follow decades of transition

The Oracle cloud strategy continues to evolve, with fresh emphasis placed on how its flagship database can help customers in the ...

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle ...

SearchContentManagement

Cohesion is latest Acquia acquisition

While Acquia would not provide specifics of the deal, the decision behind the acquisition of Cohesion was the chance to bring ...

3 things to learn before considering blockchain integration

Paul Swider, CTO at RealActivity LLC, discusses how to use blockchain technology to increase the security and usefulness of ...

Microsoft PowerApps pricing proposal puts users on edge

Microsoft's PowerApps pricing changes, expected to take effect in October, could make them too expensive for some users who ...

SearchWindowsServer

Lessons learned from PowerShell Summit 2019

Want to refine your automation abilities? Learn about some of the insights gleaned from the advanced sessions held at the ...

September Patch Tuesday addresses 2 Windows zero-days

Microsoft issues fixes for 79 unique vulnerabilities, including three public disclosures, as part of its monthly security updates.

Are you ready for the Exchange 2010 end of life?

Whether you want to stay on premises with a newer version of Exchange Server or lift that workload into Microsoft's cloud version...

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.