Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 How To Share a Database

Author  Topic 

BitsAndBytes
Starting Member

10 Posts

Posted - 2014-04-27 : 17:31:29
Hi everybody,

I want to email a copy of my SQL Server 2012 Express database to someone. How do I go about doing this?

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-04-27 : 20:00:19
Take a backup of the database and send the backup file by whatever means, email or anything else. See here on how to take a backup http://technet.microsoft.com/en-us/library/ms187510.aspx
Go to Top of Page

BitsAndBytes
Starting Member

10 Posts

Posted - 2014-05-10 : 10:43:07
Thanks James. A little late, I know. That backup solution worked great.
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2014-05-14 : 01:20:52
Hi Bits,

You can also sent data & log files of database to someone. Receiver can attach the database.

James please clarify!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-14 : 12:10:02
quote:
Originally posted by prett

Hi Bits,

You can also sent data & log files of database to someone. Receiver can attach the database.

James please clarify!




Yes you can, but it is not recommended. Detaching a database requires downtime, backup does not.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2014-05-19 : 02:50:11
quote:
Originally posted by tkizer

quote:
Originally posted by prett

Hi Bits,

You can also sent data & log files of database to someone. Receiver can attach the database.

James please clarify!




Yes you can, but it is not recommended. Detaching a database requires downtime, backup does not.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/



Thanks a lot for clarification!
Go to Top of Page
   

- Advertisement -