Backing up the database without enterprise manager

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Backing up the database without enterprise manager

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-09-21 : 07:19:14

Richard writes "Hi,

I have the dbhost, dbname, dbuser and dbpasswd for a sql server database. I want to back this up on my local machine but don't have enterprise manager installed here. Is there any way I can download a sql file from sql server without using enterprise manager?

Many thanks,

Richard"

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-09-21 : 09:15:52

My 2 step job for backups on remote servers

First step, write something like so...

Backup Database MyDatabase To Disk = 'C:\MyBackup.bak' WITH INIT

Second step is an ftp script to copy the file back to home base, and it goes something like this

ftp
open www.MyWebServerWithFTPService.com
username
password
cd MyBackupDirectory
del YesterdaysBackup.bak
put C:\MyBackup.bak
quit

====================================================
Regards,
Sean Roussy

aka the merciless black hearted capitalist troublemaker

"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources