Viewing 6 posts - 1 through 7 (of 7 total)
Enjoy, this query is made for Azure SQL. Please modify it accordingly
DECLARE @DatabaseUserName [sysname]
SET @DatabaseUserName = 'thinkbrainbox@alphaonedata.com'
SET NOCOUNT ON
DECLARE
@errStatement [varchar](8000),
...
james rossi
Senior SQL Server DBA
Senior Software Developer
Alpha One Data
Brain Box SQL Mobile DBA
September 18, 2020 at 6:52 pm
Hi fodderoh,
Just log ship to the primary replica of the AG. However, you can't add it as a AG replica database just yet.
You first have to break the log shipping...
james rossi
Senior SQL Server DBA
Senior Software Developer
Alpha One Data
Brain Box SQL Mobile DBA
September 15, 2020 at 11:29 pm
Hi T.C.,
I haven't ran into any issue as well. You'll actually see a performance boost by migrating to SQL Server 2019. The first boost I saw were in the inserts. ...
james rossi
Senior SQL Server DBA
Senior Software Developer
Alpha One Data
Brain Box SQL Mobile DBA
September 15, 2020 at 9:59 pm
Hi Henk West,
Is there any other Oracle driver you can install and use? If so, maybe give that a shot
As a possible workaround, have you tried downloading two sets of...
james rossi
Senior SQL Server DBA
Senior Software Developer
Alpha One Data
Brain Box SQL Mobile DBA
September 15, 2020 at 9:48 pm
Hi JLeino,
Why not just let the HADR process auto backup and restore the secondary database for you?
Also check your "Model" database in the SECONDARY replica and ensure it's not in...
james rossi
Senior SQL Server DBA
Senior Software Developer
Alpha One Data
Brain Box SQL Mobile DBA
September 15, 2020 at 9:38 pm
Hi Summer90,
There are quite a few acknowledgements and potential hurdles if you want to temporarily setup a side by side instance of SQL Server. Side by side setup is one...
james rossi
Senior SQL Server DBA
Senior Software Developer
Alpha One Data
Brain Box SQL Mobile DBA
September 14, 2020 at 11:28 pm
Viewing 6 posts - 1 through 7 (of 7 total)