send backup to email address

Question

send backup to email address

shashianireddy 30786

Old Hand

Points: 348
More actions
December 20, 2013 at 4:35 am

#280609

how to send daily sql backup to email adress...
how to create job.......

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

a backup will almost always be larger than the maximum allowed attachment size for most mail servers; of the two mail servers i use, one has a limit of 4 meg, and the other 10 meg.

forget trying to attach a backup as an email attachment.

you probably want build a process that does a backup, zips the backup, and pushes the file out via FTP / SFTP to a remote location, and then maybe sends you an email indicating success and where the file exists on the FTP.

all those things can be done, and placed in a scheduled job, but how you wnat to do it is up to you; SSIS can do it, all via TSQL, except the FTP part, which you'd have to add a CLR procedure to do the FTP part.

it can be done via powershell, or via external applications called via xp_cmdshell.

the project's not exactly a light process, so we'd need to hear what tools you can use and where you are stuck.

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!