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.
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!