Viewing 15 posts - 1 through 15 (of 17 total)
I encountered this kind of issues due to mismatch between the SET properties in the...
June 12, 2018 at 9:12 am
SQL Jobs are per instance but if you use always on availability groups you can setup a job step to check if this is primary before executing the desired task.
June 1, 2016 at 9:03 am
Permissions still active on the sqlJDBCXAUser role?
February 16, 2016 at 9:11 am
Hi,
Always held tempdb and logs on the same drive and never found it to have an issue. Although it's always a case of depends.....
January 18, 2016 at 2:51 am
One way I've set this up previously is by exporting the job names into a table with a 0/1 in a second column.
That way the table can be updated...
November 25, 2015 at 4:10 am
As Krypto said make sure you stop the data transfers.
Also make sure that all permissions are matched through the folder structure.
November 12, 2015 at 4:23 am
Yes it's true there's no need to restart the service
https://msdn.microsoft.com/en-GB/library/ms365941.aspx
Although for the agent account on a stand-alone instance of SQL Server, the password takes effect immediately, without restarting...
November 12, 2015 at 3:30 am
If you setup always on with a listener you will have a small amount of downtime (milliseconds) when the secondary becomes primary. Most of the time it's not even noticeable.
November 6, 2015 at 2:26 am
Hi
Had a similar problem which was caused by inconstant timings with replication at SAN level.
November 5, 2015 at 4:54 am
Standard one I've used in the past but you can add extra conditions or use the config file
Sorry hit the wrong slash it should be /q
Setup.exe /q /ACTION=Install /FEATURES=SQL...
November 4, 2015 at 3:21 am
Hi Sam,
Not sure if this will be much help - had a similar issue before the following post help diagnose the issue
November 4, 2015 at 2:52 am
Hi,
Looks like it could be a simple as missing out the /q from the command line.
Cheers
November 4, 2015 at 2:40 am
Hi,
This is a common issue when the windows installer cache has been cleared.
If you run the installer it will tell you which service packs contain the missing MSI.
Follow the instructions...
November 2, 2015 at 7:55 am
Viewing 15 posts - 1 through 15 (of 17 total)