I'm attempting to create a new scheduled task to backup a SQL Sever 2008 R2 express database. I have an existing backup with the INIT option running against the database in question, and decided to modify to NOINIT. Rather than overwrite, I elected to create a new one. It will not run.
I'm getting return code 1 - last run result indicates (0x1). All other tasks (all backing up other databases) are running without issue. Googling has not yielded much.
Program/script set to"
"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE"
-S instance-name -i"D:\user-script\backup_noinit_script.sql"
BACKUP DATABASE [Resource] TO DISK = N'D:\SQL_Database_Backup\Resource_noinit.bak' WITH NOFORMAT, NOINIT, NAME = N'Resource-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO
Following the events, Task Scheduler launches instance of of task (script), the Task Engine receives a message from Task Scheduler to launch the task (script). Task Scheduler starts instance of script. Task Scheduler launches the SQLCMD.EXE in instance of the task (script). Task Scheduler launches the script. The next event indicates the Task Scheduler successfully completed the script / action SQLCMD.EXE with return code 1. Looks like standard event information - however I have no remedy.
This appears straight forward. Any ideas? Comments / URLs are appreciated - thanks.