Viewing 15 posts - 2,266 through 2,280 (of 9,253 total)
granting execute at schema level is the only other way but it OTP in this case by the sound of it.
The object grants you are currently performing are the only...
March 18, 2015 at 10:56 am
Reg_Mayfield (3/18/2015)
data center and node3 is in another datacenter serving as the DR node.
We...
March 18, 2015 at 10:47 am
if you're going to be performing any of the backups against readable secondarys your backup scripts will need to employ a certain degree of logic to check which backups already...
March 18, 2015 at 7:19 am
balasach82 (3/17/2015)
March 18, 2015 at 4:29 am
mohan.bndr (3/15/2015)
I am still not understanding that why the need of clustering ? and how to achieve the clustering ?Please suggest any body.....Thanks!!
Check out my stairway series on this site...
March 16, 2015 at 5:53 am
djj (3/16/2015)
In case of failover, while using log shipping, how does the naming convention work? Should our log shipped database have the same name as the production?
A log...
March 16, 2015 at 5:51 am
what does your backup job do, whats the logic built into it?
March 16, 2015 at 5:47 am
by failing over the AG you are draining the node of any roles it holds
March 13, 2015 at 9:01 am
TheSQLGuru (3/11/2015)
Always On is ENTERPRISE EDITION ONLY, and the VAST majority of installed SQL Server in the world is NOT that edition.
AlwaysOn Failover Cluster Instances are not restricted...
March 12, 2015 at 6:58 am
please don't forget to mark answers as correct as this may help others
March 11, 2015 at 11:43 am
Well, the correct way is to use certificated logins and not pass through authentication.
Having said that, if you wish to continue as you are, try creating FQDNs in the...
March 11, 2015 at 4:20 am
friedrichsenm (3/10/2015)
I'm planning out how to best deploy an AlwaysOn availability group model in an environment with two separate datacenters (in the same domain) with 2 SQL Server instances in...
March 11, 2015 at 4:12 am
Ste_P (3/10/2015)
Just simply in Management Studio, highlight the primary database, right click - Tasks->Shrink->Files...
I also tried a script that I use occaisionally to shrink all databases and log files...
March 10, 2015 at 10:31 am
bissagars (3/9/2015)
during msSQL backup we see the disk activity is using 99% approximately 650mb/s , which is using all the RAID 10 speed causing some slowdown with other queries...
March 10, 2015 at 5:10 am
Hmmm, the message you're seeing is displayed when executing a shrink command against a secondary database.
On my system I run the shrink on the primary and the secondary is taken...
March 10, 2015 at 4:53 am
Viewing 15 posts - 2,266 through 2,280 (of 9,253 total)