By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,311 Online
Bytes IT Community

Home Questions Articles Browse Topics Latest Top Members FAQ

home > topics > microsoft sql server > questions > how to recover database from mdf?
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

How to recover database from MDF?

P: 4
One of our biggest database is on Suspect Mode. We searched the net for steps to recover and it is now on Emergency Mode. During transfer of data from old database to new database, we encounter errors.

We checked the MDF file and it is intact. My question is how do we recover the database from the MDF?

Help please.
Feb 9 '09 #1
Share this Question
Share on Google+
1 Reply
OuTCasT
100+
P: 374
Expand|Select|Wrap|Line Numbers
  1. Restore database <DBNAME> From disk = <Location>
Feb 12 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Question stats

  • viewed: 1664
  • replies: 1
  • date asked: Feb 9 '09
BYTES.COM © 2019 About Bytes | Advertise on Bytes | Privacy Policy | Manage Cookies
Sitemap | Microsoft SQL Server Answers Sitemap | Microsoft SQL Server Insights Sitemap

Follow us to get the Latest Bytes Updates