Restoring database from .mdf and .ldf files of SQL Server 2008

by

Yes, it is possible.
The steps are:

  1. First Put the .mdf and .ldf file in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ folder

  2. Then go to sql software , Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box

  3. Click the “Add” button to open and Locate Database Files From C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\folder

  4. Click the “OK” button. SQL Server Management Studio loads the database from the .MDF file.

More Related Contents:

  1. SQL group_concat function in SQL Server [duplicate]
  2. Pivot Dynamic Columns, no Aggregation
  3. varchar(max) everywhere?
  4. T-SQL: Export to new Excel file
  5. Enable ‘xp_cmdshell’ SQL Server
  6. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  7. SQL MERGE statement to update data
  8. How to get the last record per group in SQL
  9. How to convert float to varchar in SQL Server
  10. A transport-level error has occurred when receiving results from the server [closed]
  11. How can I load a large flat file into a database table using SSIS?
  12. How to convert datetime in Persian in SQL Server
  13. storing passwords in SQL Server
  14. How does sql server sort your data?
  15. How to restore to a different database in SQL Server?
  16. Why is SQL Server 2008 Management Studio Intellisense not working?
  17. Reporting Services permissions on SQL Server R2 SSRS
  18. T-SQL substring – separating first and last name
  19. How to implement polymorphic associations in an existing database
  20. How to get week number of the month from the date in sql server 2008
  21. How to deploy SQL Server Compact Edition 4.0?
  22. Optional parameters in SQL Server stored procedure
  23. Entity Framework Database.SetInitializer simply not working
  24. Cannot open backup device. Operating System error 5
  25. What is the default transaction isolation level for SQL Server with ADO.NET?
  26. T-SQL strip all non-alpha and non-numeric characters
  27. Avoiding IF ELSE due to variable been NULL
  28. Where are SQL Server connection attempts logged?
  29. Can I pass variable to select statement as column name in SQL Server [duplicate]
  30. SQL Server 2008 Connection Error “No process is on the other end of the pipe”

Leave a Comment