471,873 Members | 1,661 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

home > topics > microsoft sql server > questions > how to recover database from mdf?

Join Bytes to post your question to a community of 471,873 software developers and data experts.

How to recover database from MDF?

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
1 1841
OuTCasT
374 256MB
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.

Similar topics
Recover a corrupted LDF file
1 post views Thread by WKC | last post: by
Recover Using INCREMENTAL AUTOMATIC
3 posts views Thread by apple | last post: by
Help withDB2 Recover Command
reply views Thread by mike_dba | last post: by
Markdown-ImageLocalize
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2023
About Bytes
Advertise
Terms Of Use
Privacy Policy
Contact Us
Sitemap

Follow us! Get the Latest Bytes Updates