SaveAs/Export SQL DB to desktop so I can FTP via email

I have a db in SQL Server Enterprise Manager that I need to drop in an FTP folder as SQL or send via email.

How do I do export from Enterprise manager????

Thanks in Advance!!!
Who is Participating?
Saqib KhanConnect With a Mentor Senior DeveloperCommented:
if you are in Domain Coltroller envirnoment, and SQL Server can talk to your Pc without any login info then you can share a Folder on your PC and point to it.

Backup database TravelApprover to disk = '\\Pc_Name\shared_Folder_Name\FileName.Bak' WITH INIT

otherwise tell whoever manages the Server to give you the File.
Saqib KhanSenior DeveloperCommented:
in Query Analyzer do this..

Backup database Database_Name to disk = 'c:\Filename.BAK' WITH INIT

(change Database name)

it will make Database File in your C Drive with the name Filename.BAK.

now you can Email or FTP this File to whoever you want.
selmsAuthor Commented:
okay... typed this into the Query Analyzer:

Backup database TravelApprover to disk = 'c:\TravelApprover.BAK' WITH INIT

But then how do I acutally get it to EXECUTE...

tried save, save as,  didn't work...

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Saqib KhanSenior DeveloperCommented:
hit "F5" or the Play button from Top.
selmsAuthor Commented:
I tried both f5 and the play button,  in both instances, this message shows up on the Results section of the Query Analyzer,

Processed 384 pages for database 'TravelApprover', file 'Travel_Security_Data' on file 1.
Processed 1 pages for database 'TravelApprover', file 'Travel_Security_Log' on file 1.
BACKUP DATABASE successfully processed 385 pages in 0.102 seconds (30.850 MB/sec).

but then I go to my cDrive and there is nothing there - I even did a search on the entire drive for TravelAprover.BAK just in case it ended up somewhere else.

Am I missing something???

Saqib KhanSenior DeveloperCommented:
Remember it will store the File on the "C" Drive of SQL server Machine, not your Local Computer, as i assume SQL Server is Intalled on a different computer.
selmsAuthor Commented:
You're probably right, it's installed on another virtual server somewhere,  but I don't have access to that.

Is there a way to save directly to "my desktop" and not the "SQL's C Drive" since I don't have access?

I can open a new question/topic if necessary... Thanks!!!
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.

All Courses

From novice to tech pro — start learning today.