April 23, 2012 at 4:18 am
hi all
my database is crashed suddenly, now i want add my mdf and ldf file using power shell plz help me!!
--------------------------------------------------------
I am Learner -- SQL
April 23, 2012 at 4:49 am
Even if you attach the mdf and ldf file using PowerShell, it will attach the files which actually crashed....right??
Shouldn't you be looking at other options like restoring a backup of the database?...
April 23, 2012 at 5:11 am
Forget powershell. It's irrelevant.
Please define 'crash'. Exactly what happened? Exactly what state are things now?
Do you have a backup?
Do you have the mdf and ldf files?
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
April 23, 2012 at 5:28 am
i have only MDF and LDF files.
--------------------------------------------------------
I am Learner -- SQL
April 23, 2012 at 5:33 am
selvakumar.sms (4/23/2012)
i have only MDF and LDF files.
By avoiding Gail's questions you are making your own questions more difficult to answer. Please reread her post and then provide the requested information.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
April 23, 2012 at 5:38 am
GilaMonster (4/23/2012)
Please define 'crash'. Exactly what happened? Exactly what state are things now?
No backup? Seriously you have no backup? I'm going to assume, since there's no backup, that the DB isn't very important.
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
April 24, 2012 at 2:12 am
April 24, 2012 at 3:03 am
thanks alot
finally i attached mdf and ldf using sp_attach_db procedure.
--------------------------------------------------------
I am Learner -- SQL
April 24, 2012 at 3:09 am
You are magician 😉
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply