In order to succesfully schedule an sql backup batch witch expressmaint utility you must ensure that the following conditions are true.
- Choose an administrative account to run the batch
- make sure it has full control file system permissions on the folders containing the batch file and the destination folder
- choose a destination folder with no spaces, and avoid using " in the batch file.
- since expressmaint uses the launching user credentials to connect to the sql server, make sure that the windows user credentials under which you run the batch have full permissions on the sql dbs (use sql management studio to add/configure the windows account under the security section).
- Unless you specify the "Start in..." option when you select the script to run you must specify the full path to executable file in the batch file (e.g. c:\batch\expressmaint -S ecc..)
No comments:
Post a Comment