remote backup 1

[anuedwardlobo]

How can I perform a backup of a remote sql server.

The reason I am asking is I have a sql server and password of the sa account but I don't have the administrator password of the machine. Unfortunately I cannot get it so cannot install a backup utility. Backing each database is time consuming.

Any idea how I can do this easily with one command ?

Am new to sql so help would be appreciated.

thanks

 

[onpnt]

You can loop through all the databases showing in sysdatabases and call the BACKUP DATABASE command

Warning: check disc space prior to each backup ;-)

[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[onpnt]

Or read the FAQ's

faq962-5722

[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[anuedwardlobo]

thanks a million