Trying to use KB-2019698 to back up SQL express web backend.
Stored procedure created ok, can run stored procedure with success from within SQL managment studio after granting 'everyone' rights to the backup directory. Creating stored procedure produced an error near / comment but don't know why MS code would produce
an error? stored procedure seems to run fine from within SQL managment anyway. Is that error significatn to my problem?
Batch script run as adminstrator (based on example 4, Full backups of the database USERDB in the local named instance of SQLEXPRESS by using Windows Authentication) from the command line produces no errors, no logs, no output and no backup at all.
Completes almost immediatly.
Q: What user will create the back up file when this works (who needs access to the backup dir)? MSSQL$SQLEXPRESS?
Q: Why does the batch command complete with no error and no work done?
Q: If @BackupType = 'F' is for ful ...
Go to the complete details ...