Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql 2005, mdf restoration, w/out ldf, new box Expand / Collapse
Author
Message
Posted Friday, February 8, 2008 11:22 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 2:58 PM
Points: 531, Visits: 965
Here is the situation:
> C drive containing the SQL server 2005 is gone
> D drive for data is available
> E drive for logs is GONE
> no backup of mdf nor the ldf file

current dondition:
> a new sql needs to be rebuilt
> the MDF files need to be restored

All the attach various commands are not the options because the DBs where shutdown ungracefully.
So, here is the Q.
How, to restore an MDF file on the new sql server without the original ldf file.
thx

BY THE WAY
I don't think there is such a command as DBCC REBUILD_LOG in 2005...just to make sure we are on the same page.


JohnE



Cheers,
John Esraelo
Post #453385
Posted Friday, February 8, 2008 4:14 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 9:22 AM
Points: 3,461, Visits: 351
use sp_attach_single_file_db to attach only the mdf file to the database server so that a new ldf file is created once the mdf is attached.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Post #453524
Posted Saturday, February 9, 2008 9:12 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 26, 2012 2:14 PM
Points: 402, Visits: 598
Check this link and see the workaround 2 Step 2 http://sql-articles.com/index.php?page=articles/HA/suspectdb.htm


- Deepak
Post #453588
Posted Saturday, February 9, 2008 2:44 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 2:58 PM
Points: 531, Visits: 965
server A = production
server B = test/development environment

server A was a VM and it was destroyed, therefore the SQL engine was gone.
The databases were on:
>>> drive XXX for data
>>> drive YYY for logs
The two above drives are NAS
YYY got destroyed too... go figure...

Therefore the only thing left to do is to figure out if the MDF files can be restored in the test / development environment.
make sense?

JohnE


Cheers,
John Esraelo
Post #453602
Posted Tuesday, April 9, 2013 12:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 9, 2013 12:51 AM
Points: 1, Visits: 0
Current Condition:

> The MDF files need to be restored

Restore and Recover your Corrupted SQL server MDF file with all original SQL server database and complete objects like: table, triggers, views and primary key etc. With help of SQL recovery tool which is professional tool for SQL server recovery. for more info then read this article: http://www.amazines.com/article_detail.cfm/5591869?articleid=5591869

Thanks & Regards

Rose Marry Marlo
Post #1440176
Posted Tuesday, April 9, 2013 1:35 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 39,977, Visits: 36,339
Please note: 5 year old thread.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1440190
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse