• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2367
  • Last Modified:

Export MDF file in SQL server Express 2008 r2

I am using SQL server EXPRESS r2 edition. How to take backup as MDF file of the database ?
0
Vikash p
Asked:
Vikash p
1 Solution
 
lcohanDatabase AnalystCommented:
You can issue a manual CHECKPOINT against the database, then Detach it from SQL Server SSMS or use sp_detachdb, then copy the MDF somewhere, then attach it back to the SQL Server using sp_attachdb but frankly....Why not just taking a FULL database backup? and restore it elsewhere or just save the backup?
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now