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

Home Posts Topics Members FAQ

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

1 post views Thread by WKC | last post: by
3 posts views Thread by apple | last post: by
reply views Thread by mike_dba | last post: by
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.