Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

outputting a sql database to an email /to windows Expand / Collapse
Author
Message
Posted Saturday, May 1, 2010 5:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 12, 2010 3:12 PM
Points: 27, Visits: 36
I have imported a microsoft database into sql server but now I want to 'export' it out into a folder in windows explorer in order to email it? has anyone know the easiest wya to do this. Is it making a backup of the database?
Post #914223
Posted Saturday, May 1, 2010 6:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 13,973, Visits: 36,283
craig 84462 (5/1/2010)
I have imported a microsoft database into sql server but now I want to 'export' it out into a folder in windows explorer in order to email it? has anyone know the easiest wya to do this. Is it making a backup of the database?


yes, making a backup, zipping it is the recommended way; but any database with any amount of data is going to exceed most email servers max size limits; you'll most likely need to put the zip of the backup on an ftp site and email the site/ftp_username/ftp_password instead

making a backup is easy: right click on the database name in SSMS, Select Tasks...Backup...
let us know if you need more advice.


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #914225
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse