Viewing 15 posts - 1 through 15 (of 64 total)
Thanks guys, so I don't think there would be any limitations other than using this on production.
I hope even the database sizes, memory , CPU / high availability features would...
September 2, 2020 at 3:22 pm
Thank you Jeff ! and all others!
The issue is fixed by granting access to the GMSA to the folders where the files were extracted and where the backup files were...
August 28, 2020 at 11:42 am
Finally it turns out that permissions to the folder were required, permissions to the SQL server service account. Once this was granted
EXEC Master.dbo.xp_DirTree 'D:\Backups\',1,1 ==> Command worked !
Thanks all for...
August 28, 2020 at 11:38 am
My command is : EXEC Master.dbo.xp_DirTree 'D:\Backups\',1,1
And I have one file in the directory, but the out is : (0 rows affected)
I am running this on SQL Server 2017 version.
August 27, 2020 at 5:38 pm
This same bat file ran successfully through Windows task scheduler job. That is the extractor bat file.
You mean to say ==> : E:\Extractor64 -F "E:\Test\%NewestFile%" -E D:\TestBackups\test.bak ?
August 27, 2020 at 12:52 pm
Thank you all for the suggestions/ inputs , really appreciate it.
Previously, I was using my own account to create the task scheduler job and it was running successfully. Now, management...
August 27, 2020 at 12:38 pm
Thanks for the suggestion Brian, I also suspect that the GMSA needs to be added to Log on as batch Job and needs to be in the Administrator group. I...
August 26, 2020 at 6:16 pm
Hi Brian, thanks for the response.
tns ping works from SQL SERVER box to the oracle server that is mentioned in the tns names file.
i think I can create a linked...
August 24, 2020 at 9:39 pm
Thanks Andy, let me try this method you suggested , keep posted
July 17, 2020 at 7:59 pm
Thanks for replying back, I'll take a look at the suggestion
June 17, 2020 at 12:19 pm
thank you I will try that
June 15, 2020 at 7:05 pm
Thanks for all the help, I'll try this out.
June 15, 2020 at 3:20 pm
This is how I get data in CSV format : As you can see the rows are not aligned to proper columns above
June 15, 2020 at 12:27 pm
That's nice points you said. I was trying to automate this process using SQL Server agent job and selecting SSIS, once I have my export package saved. I tried using...
June 13, 2020 at 5:03 pm
Thanks I will try that. This issue seems with only using excel 2007. If I select excel 2016 (while exporting) on another machine I don’t see this happening.
So appears I...
June 13, 2020 at 4:13 pm