how to restore .ldf files and .mdf files in sql server

Question

how to restore .ldf files and .mdf files in sql server ?? please explain

Kailash Chandra Behera · Answer

There are two ways to restore the .ldf file and .mdf file copy past file in the directry restoring step 1 :copy past first disable the sql service go to the path'Control Panel\All Control Panel Items\Administrative Tools' double click the service, the service wizard window will open fine the sql server service and stop it. Copy the .ldf and .mdf file and past that in the below directory C:\SQL Server\Root\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Betfair.mdf C:\SQL Server\Root\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Betfair.ldf restart the sql service by following the above mentioned path refresh your sql server database connection, than the new database will appear automatically Stip-2 Restor Database open your Microsot SQL Server , ritht click on the database appeared the left side of object explorer witdow and select attach. The new database window will open, set the ldf file and mdf file path than click ok button the newly created database will appear in the object explorer.

how to restore .ldf files and .mdf files in sql server

Answers (1)