View Single Post
  #10 (permalink)  
Old 09-08-2009, 09:09 PM
hdawg's Avatar
hdawg hdawg is offline
Proprietor
 
Join Date: Nov 2008
Posts: 2,238
Blog Entries: 147
Default

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.
Reply With Quote