This needs to be run on the SQL server, or you need to add a -S SERVERNAME to the OSQL statement ... such as:
@OSQL -E -S SQL01 -Q "backup database BESMgmt to disk = 'C:\BlackBerryDBBackup\backup.bak'"
REMEMBER: You need to make sure though that you run the script as a user that has permissions on the database.
__________________
http://blog.port3101.org/hdawg/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|