Is there any other alternative available to schedule the task of the user databases using Task Scheduler using Ola Hallengren's Script. The following link is one of the way to schedule task using Job Properties Scheduler
asked
Ola Hallengren's script to be used in Task Scheduler
you can definitely run these from task scheduler
from the FAQ page - https://ola.hallengren.com/frequently-asked-questions.html
- Download MaintenanceSolution.sql.
- Execute MaintenanceSolution.sql. This script creates the stored procedures that you need.
- Create cmd files to execute the stored procedures; for example:
sqlcmd -E -S .\SQLEXPRESS -d master -Q "EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES', @Directory = N'C:\Backup', @BackupType = 'FULL'" -b -o C:\Log\DatabaseBackup.txt - In Windows Scheduled Tasks, create tasks to call the cmd files.
- Schedule the tasks.
- Start the tasks and verify that they are completing successfully.
Here are my finding:
Got the error (0*1), did not create the backup file in D:\Backup. Script is as following:
sqlcmd -E -S .\SQLEXPRESS -d master -Q "EXECUTE dbo.DatabaseBackup @Databases = 'IMSAi3old', @Directory = N'D:\Backup', @BackupType = 'FULL'" -b -o D:\Log\DatabaseBackup.txt
Created the task with account DEVWIN\SqlServIntSvc, Action, but the script does not run. Is this specific for SQLExpress.?
From command prompt got the error:
D:\Backup Script>FOBbackup
D:\Backup Script>EXECUTE dbo.DatabaseBackup
'EXECUTE' is not recognized as an internal or external command,
operable program or batch file.
'Databases' is not recognized as an internal or external command,
operable program or batch file.
'Directory' is not recognized as an internal or external command,
operable program or batch file.
'BackupType' is not recognized as an internal or external command,
operable program or batch file.
'Compress' is not recognized as an internal or external command,
operable program or batch file.
'CheckSum' is not recognized as an internal or external command,
operable program or batch file.
'CleanupTime' is not recognized as an internal or external command,
operable program or batch file.
D:\Backup Script>
To test direct from command line you need to run the entire command:
sqlcmd -E -S .\SQLEXPRESS -d master -Q "EXECUTE dbo.DatabaseBackup @Databases = 'IMSAi3old', @Directory = N'D:\Backup', @BackupType = 'FULL'" -b -o D:\Log\DatabaseBackup.txt
Changed the code a bit to run from command prompt but not successful yet
sqlcmd -S DEVWIN\sqlServIntSvc -d master -Q "EXECUTE dbo.DatabaseBackup @Databases = 'IMSAi3old', @Directory = N'D:\Backup', @BackupType = 'FULL'" -b -o D:\Log
Error log: How do I fix this issue
HResult 0xFFFFFFFF, Level 16, State 1
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.
Action Detail:
Start a program
"D:\Backup Script\FOBbackup.cmd" and no arguments but the job fails.
Not sure without more detail but I saw some suggestions here (https://stackoverflow.com/questions/4437701/run-a-batch-file-with-windows-task-scheduler) that you don't need the double quotes around the path and that you may also need to include your path in the "Start in" text box.
17 People are following this question.
