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

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.

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

THANKS IN ADVANCE!!

hit "F5" or the Play button from Top.

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???

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.

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