February 8, 2008 at 11:22 am
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
February 8, 2008 at 4:14 pm
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
February 9, 2008 at 9:12 am
Check this link and see the workaround 2 Step 2 http://sql-articles.com/index.php?page=articles/HA/suspectdb.htm
[font="Verdana"]- Deepak[/font]
February 9, 2008 at 2:44 pm
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
April 9, 2013 at 12:58 am
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[/url] 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
April 9, 2013 at 1:35 am
Please note: 5 year old thread.
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply