Viewing 15 posts - 1 through 15 (of 20 total)
check out this link: https://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx#BKMK_steps_precreating2
April 14, 2015 at 4:21 am
AlwaysON AG have built-in compression for the streams of transaction logs between the primary and secondary replicas, this is not an option that you can configure from within the AG.
I...
April 14, 2015 at 2:53 am
Consider the following; failover to the original primary replica and regenerate the master key with a new password (key). Use ssisdb. I said you should consider the option so you...
March 6, 2015 at 6:54 am
By 'not preserved', do you mean you don't remember the password you used when creating the SSIS Catalogue (creates SSISDB)? Or you expected that the password will be synced as...
March 6, 2015 at 2:24 am
Check the cluster logs from Failover Cluster Manager. If the Cluster Identity had trouble dynamically creating an A-record for the listener name in the DNS, it will log an event...
February 24, 2015 at 12:44 am
No, the SQL Server instance does not have to use the same port as the Availability group listener. On the other hand, if you decide to use a different port...
February 20, 2015 at 11:07 am
I have adapted the script significantly, so i think the right thing to do is to point you to the original post that got me going years ago ( big...
November 22, 2012 at 3:38 am
A simple way to get a rough idea about what the .bak size will be is to check the "disk usage" report in sql 2005+, if you installed them. Space...
November 9, 2012 at 9:25 am
Some of the info I gather on a central reporting server are about: disk space, db size (mdf, ldf), memory usage, I/O, network, CPU, user sessions. Easiest way for me...
November 9, 2012 at 4:58 am
I evaluated most of them before I went for Idera's DM and it's been great in terms of helping me easily spot issues.
November 9, 2012 at 4:31 am
You mentioned that both DEV and TEST are on the same server. How are you connecting to [servername], locally or remotely? The following comments assume that you are connecting remotely....
November 9, 2012 at 3:45 am
It's good that you have made your learning plan. Look at the skills measured in the exam and do a checklist so you can tick off items when you are...
November 6, 2012 at 7:22 am
Inbuilt "Schema Changes History" report can also help
November 1, 2012 at 4:36 am
sehgalnamit (10/24/2012)
I have around 100 of the primary...
October 25, 2012 at 9:30 am
Viewing 15 posts - 1 through 15 (of 20 total)