Viewing 15 posts - 16 through 30 (of 486 total)
As much as it was a very long time ago, it was indeed the source of our issue, once we removed the duplicated articles the issue never came back.
MCITP SQL 2005, MCSA SQL 2012
June 7, 2018 at 6:09 am
One option is to write the backups (full \ log) on a local EBS volume and subsequently push them to S3. It will make restoration slightly more complex than just...
MCITP SQL 2005, MCSA SQL 2012
May 16, 2018 at 8:17 am
Yeah you do, I'm not sure why it doesn't cover it as it would have made sense to.
MCITP SQL 2005, MCSA SQL 2012
April 26, 2018 at 7:25 am
I had similar issues when setting this up on SQL 2017. This may be of some help to you:
https://www.sqlservercentral.com/Forums/1924105/Always-on-and-SSISDB
MCITP SQL 2005, MCSA SQL 2012
April 25, 2018 at 8:38 am
MCITP SQL 2005, MCSA SQL 2012
April 23, 2018 at 4:56 am
MCITP SQL 2005, MCSA SQL 2012
April 11, 2018 at 3:07 am
Sorry for the slow reply. I assume the URL they gave you is something like this:
April 6, 2018 at 9:03 am
This is one way to do it:
$aws_profile = 'MyAWSProfile'
$awskey = 'XXXXXXXXXXXXX'
$awssecretkey = 'XXXXXXXXXXXXXX'
$bucket = "MyBucket"
$keyPrefix = "install/"
$localPath = "D:\install\"
Import-Module AWSPowerShell
Set-AWSCredentials...
MCITP SQL 2005, MCSA SQL 2012
April 3, 2018 at 8:32 am
We are talking about the encryption certificates for the SQL server backups containing...
MCITP SQL 2005, MCSA SQL 2012
March 6, 2018 at 4:25 am
Is using online storage not an option? For example Amazon's S3 is secure (providing you set it up correctly), it is also one of the most redundant online storage facilities...
MCITP SQL 2005, MCSA SQL 2012
March 6, 2018 at 2:27 am
Thanks for the reply, yes I have been through the pain of doing this manually in prior versions, its still not perfect in 2016 / 2017 but a marked improvement.
MCITP SQL 2005, MCSA SQL 2012
February 20, 2018 at 2:26 am
Turns out using the backup and restore method worked adding the database on the secondary using this method, it would be good though if someone could confirm this is the...
MCITP SQL 2005, MCSA SQL 2012
February 19, 2018 at 8:53 am
One easy and free solution is to use a parameterised batch file (there are more elegant solutions), this is just a basic example.
Save the following as deploy.bat: MCITP SQL 2005, MCSA SQL 2012
December 7, 2017 at 5:06 am
Sorry yes, this particular example is for SQL 2012, but the same works for SQL 2014. We have been running this very setup for almost 2 years. As I say...
MCITP SQL 2005, MCSA SQL 2012
September 7, 2017 at 2:10 am
Another workaround which avoids the use of developer edition and the licencing issues around that is as follows:
1. Install SQL Server 2014 Express edition on the host, this...
MCITP SQL 2005, MCSA SQL 2012
September 6, 2017 at 9:15 am
Viewing 15 posts - 16 through 30 (of 486 total)