Backup vCenter DB through SSMS?

[aarondovetail]

I have my vCenter database running on SQL Express 2008, it would be easy to schedule a backup job but there is no SQL Server Agent with Express. If I run the SQL commands to back it up manually or right click | backup it works fine but is a manual process.

Does anyone know how to backup a SQL database from another SQL server's SQL agent?

Like if I could run this SQL:

Backup Database VIM_VCDB

To Disk = '
blah\VIM_VCDB.bak'

With Init

but specify a server, it would work fine, but the backup database command doesn't seem to have the ability to specify a server. I don't see a way to specify a connection to a different server while creating a SQL agent job either.

Thanks

[aarondovetail]

I kind of answered my own question in a different way, decided just to create a .BAT file and run it under task scheduler that kicks off OSQL and just runs the SQL code to backup that DB and dumps it to the UNC share.

Still would be nice to know if this could be done through SQL Server agent though on a different server