Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 2241

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

4
votes
Find out what process is already using TCP 1433. You can do this through the use of TCPView. That utility is a sysinternals tool that gives you the information you need. Just start it, pause the da …
answered Mar 27 '14 by Thomas Stringer
6
votes
By selecting SQL user without login within SSMS' create user dialog, this is the T-SQL that is generated (with no other options besides the user name supplied): USE [AdventureWorks2012] GO CREATE USE …
answered Jun 24 '14 by Thomas Stringer
14
votes
Please see the reference on BOL for Database-Level Roles: db_owner Members of the db_owner fixed database role can perform all configuration and maintenance activities on the database, and ca …
answered Jun 26 '14 by Thomas Stringer
1
vote
If you want to enable automatic failover, you will need to ensure that you have an "automatic failover set", to include two replicas (in your case, that'd be your two nodes) both set with synchronous …
answered Jan 7 '14 by Thomas Stringer
41
votes
Within your SQL Server Agent job, have some conditional logic to test for if the current instance is serving the particular role you are looking for on you availability group: if (select ars. …
answered Jun 24 '13 by Thomas Stringer
2
votes
There's only a couple of "gains" that I can think of off the top of my head. First off, security. If for some reason a login had to have elevated permissions on the instance but there are sensitive da …
answered Nov 21 '12 by Thomas Stringer
3
votes
By default, replication will push out the following DDL changes to subscribers: ALTER TABLE ALTER VIEW ALTER PROCEDURE ALTER FUNCTION ALTER TRIGGER And by default, I mean unless you have specified …
answered Dec 11 '13 by Thomas Stringer
1
vote
If by AlwaysOn you mean "Availability Groups" (which is typically the case), then you can most definitely use your failover cluster instance as a replica. For this to be an Availability Groups design …
answered Apr 25 '14 by Thomas Stringer
10
votes
You can backup the transaction log from either of the replicas. Doing the transaction log backup on either the primary replica or the secondary replica will mark both replicas' transaction logs as re …
answered Jun 20 '13 by Thomas Stringer
0
votes
You are on the right track. With the database in full recovery mode, no portions of the log file will be marked for reuse until it has been backed up. I'm assuming you've created your maintenance pl …
answered Jul 8 '14 by Thomas Stringer
3
votes
We'd like to introduce AlwaysOn Availability Groups from ClusterP to ClusterS. I've read multiple guides to this and there is one question I can't really answer. We do NOT have the ability to have …
answered May 30 '14 by Thomas Stringer
3
votes
The Setup.exe will do the dirty work for you and take the passive node (currently upgrading node) away from being a possible owner of the SQL FCI's virtual network name (VNN). But if you want to ensu …
answered Oct 8 '13 by Thomas Stringer
6
votes
You can change this behavior with the ALTER SERVER CONFIGURATION statement. The flexibility to modify all of the necessary parameters (path, max files, max file size) should give you enough control t …
answered Aug 18 '14 by Thomas Stringer
2
votes
Does this failover cluster impose any restrictions on this backup restore or will it be a normal backup restore operation. It will be a normal backup and restore operation (provided there are no …
answered Mar 27 '14 by Thomas Stringer
2
votes
It sounds like you may have set Force Encryption on the instance. In SQL Server Configuration Manager, you can see this setting (server-side encrypting enforcement) by expanding SQL Server Network Co …
answered Dec 5 '13 by Thomas Stringer

15 30 50 per page