You could use sqlcmd to execute a backup statement - but as Kristen says ....
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
There is a solution to use the broker to schedule jobs in express - do a search. But using sqlcmd from the windows scheduler should work.
something like sqlcmd -Smyserver -E -Q"backup database mydb to disk='c:\mydb.bak'"
oops - was sqlcmd available for v2005? osql was very similar and was replaced by sqlcmd.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Use sqlcmd or osql to call it I've checked and sqlcmd was available in v2005 so sqlcmd -Smyserver -E -Q"exec mydb..s_MyBackup"
The -E means to use a trusted connection. It may need to be changed to a sql server connection depending on how the windows scheduler uns it but that's easy to set up.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Database Backup
Posted - 12/01/2010 : 02:18:54
