November 11, 2009 at 9:57 am
How can i restore db from .mdf and .ldf files??
thanks in advance.
November 11, 2009 at 10:07 am
Using Attach Database.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 11, 2009 at 10:07 am
Attach them. Look up CREATE DATABASE ... FOR ATTACH in Books Online. It's not always possible to attach the files, especially if the DB was no online or the database wasn't properly detached. Got a backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 11, 2009 at 10:18 am
Agree with that Gail, checking that DB was properly detached .
And also making sure the entire set of the Files are Available in case of multiple Data and Log Files, I have been in such a situation of losing some of the datafiles, would need to know on that.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 12, 2009 at 6:32 am
thanks for your answers.
i was on a hurry so i used this mechanism...
1.- create a database
2.- deattach the DB
3.- attach the DB with de .mdf and .log that i needed.
it worked fine.
It ok to do it like that.?
November 12, 2009 at 8:07 am
Looks fine.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply