Powershell -file ‘C:\Automation\TempdbFolder.ps1’ If you have setup a PowerShell script to execute the script in the following manner using single quotes, then this issue occurs. Task Scheduler successfully completed task “\Tempdb Folder Creation”, instance “”, action “C:\Windows\System32\WindowsPowerShell\v1.0\powershell.EXE” with return code 4294770688.įirst, let us find out why this error message gets reported. The last run result is reported as 0xFFFD0000 and the task history would show the following message: However, when the scheduled task executes, the following error is reported in the Task Scheduler logs. The blog post in the reference section has more details on how to achieve this. I already have a scheduled task created on my Azure virtual machine which re-creates the folder structure on the D: drive. So, when the Azure virtual machine restarts the D: drive is re-created and all my folder structure is lost. If you have change the drive letters on your Azure VM, then you can use the PowerShell script in my earlier blog post to identify the temporary drive. However, the D: drive on Azure virtual machines is not a persistent drive. I am using a D-Series machine which allows me to store my tempdb files on the D: drive which is a SSD drive. I have a SQL Server instance installed on an Azure virtual machine. This is another gotcha for setting up scheduled tasks which execute PowerShell scripts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |