Viewing 15 posts - 1 through 15 (of 6,344 total)
So whats in the trace file? Does it help us understand whats happening in some way?
October 11, 2024 at 1:01 pm
sp_send_dbmail is not available on Azure SQL DB, so you will need to use some 3rd party application which can integrate with your application to send mail on it's behalf,...
October 10, 2024 at 2:06 pm
Maybe one to post on an actual Oracle forum also.
Everyone here will be primarily Microsoft SQL Server focused, not to say that there may not be a few Oracle people...
October 2, 2024 at 3:10 pm
Yeah SQLAgent can't work without MSDB so if MSDB is missing, then quite rightly so would SQL Agent.
Have you checked from sys.master_files the path to MSDB?
Have you check that those...
October 2, 2024 at 3:07 pm
You'll need some app / query logic to prevent it.
IF EXISTS(SELECT 1 FROM #unique_names WHERE email = @email AND first IS NOT '' AND last IS NOT...
October 2, 2024 at 2:58 pm
Use powershell and integrate with the Azure (AZ) module to make the Azure backend responsible for doing the restore for you.
You have picked a PaaS offering, let Microsoft do all...
October 2, 2024 at 7:50 am
This one perhaps then?
October 1, 2024 at 10:47 am
Does this one work at all?
https://www.microsoft.com/en-us/download/details.aspx?id=103466
October 1, 2024 at 10:15 am
No, do not restore them from 2012 to 2019.
To transfer logins you can search for “sp_help_revlogin” this will generate you a script to move logins.
The best thing though is get...
October 1, 2024 at 6:57 am
Why do you manually want to do backups?
Why not let Azure manage the backups for you?
What is the use case / benefit your senior wants to get here?
October 1, 2024 at 5:58 am
Looks like ADS needs to authenticate to Git so it can push your changes to the remote repo
September 26, 2024 at 1:26 pm
You may need to play with some settings like lease timeout, health check timeout, connection timeout on the replicas and clusters.
VSS has IIRC 60 seconds to get in do its...
September 20, 2024 at 3:43 pm
I logged in with my credentials to the sqlserver and not the domain account which the engine is currently running under..
That is a false test, you need to be...
September 12, 2024 at 10:23 am
Thanks for the response @Ant-Green
Also then map the UNC path in windows explorer as the engine account, can the drive map itself? - Yes I was able to map...
September 12, 2024 at 10:10 am
RDP to the UNC server, find the folder, and verify the engine account has full control access to the folder.
September 12, 2024 at 9:44 am
Viewing 15 posts - 1 through 15 (of 6,344 total)