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

Easiest way to get a copy of a SQL Server Express 2012 database

I have a client in the field with a SQL Server Express 2012 database (without management studio). I would like to get a copy of one of their databases... what is the easiest way to have a (non computer literate) user send me a copy of their database? Do they have to load SS Management Studio then do a backup, or detach and send the mdf/ldf... or is there an easier way?
1 Solution
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Curiosity overwhelms me ... If somebody did send you a SQL Server 2012 database, essentially just a backup to .mdf (and any .ldf's), without SSMS what would you do with it?
You do need SS Management studio to get a backup of the db.  I wouldn't have then detach as they may not get it attached again properly and you instructed them to do so, thus shutting down their working db.
KnowledgeWareAuthor Commented:
Thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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