Forum Replies Created

Viewing 15 posts - 3,406 through 3,420 (of 9,253 total)

  • RE: Question about SQL2012 availability groups & security

    Zubius (4/1/2014)

    How should application/users security be set up? If server #1 fails, availability group #1 fails over to server #2 but the security does not, so applications...

    April 1, 2014 at 1:43 pm

    #1702208

  • RE: SQL Cluster

    Enthusiastic Jones (4/1/2014)

    I'm referring to the option in cluster manager where if the agent can't start it causes the instance to failover to another node. I'm trying to see how...

    April 1, 2014 at 1:18 pm

    #1702202

  • RE: SQL Cluster

    Enthusiastic Jones (4/1/2014)

    Should it be setup so that an instance be set to failover if the SQL Server Agent fails?

    Thoughts??

    The default for this resource is the same as others, initially...

    April 1, 2014 at 9:38 am

    #1702108

  • RE: IDENTITY(1,1) doesn't work, from 17 jumped to 1001

    mario17 (3/31/2014)

    Thanks, all

    Yes, I did reseed and it worked.

    DBCC CHECKIDENT ('Person.AddressType', RESEED, 10);

    The problem here is, when the value jumped if identities were created in the upper range and you...

    April 1, 2014 at 3:47 am

    #1701929

  • RE: IDENTITY(1,1) doesn't work, from 17 jumped to 1001

    TheSQLGuru (3/31/2014)

    If you shut down SQL Server there is a known bug that advances the identity values. I don't know if there is a fix for that or not.

    according...

    April 1, 2014 at 3:45 am

    #1701926

  • RE: Memory Issue with Named Instance

    AmarettoSlim (3/30/2014)

    Using the link Lynn mentioned you'll likely need to start SQL Server in single user mode (-m). If you find that you can't connect to the instance after doing...

    March 31, 2014 at 7:00 am

    #1701564

  • RE: Evenly splitting large DB files

    DVSQL (3/26/2014)

    So I tried it that way, stuck the command into a cursor, looped through all the user indexes, and it didn't seem to work. Maybe 8% of data was...

    March 31, 2014 at 6:18 am

    #1701553

  • RE: Can you determine an estimated execute time of an SQL statement

    sys.dm_exec_requests has a percent complete column and also an estimated finish time, but only for a set of specific commands. You'll need to capture time stats in a similar environment...

    March 31, 2014 at 5:25 am

    #1701537

  • RE: SQL 2012 AlwaysOn

    adeel.imtiaz (3/30/2014)

    Do we need a Shared Storage(SAN) for SQL Server 2012 AlwaysOn

    No, not for a standard AlwaysOn configuration involving replicas that are standalone installs of SQL Server

    adeel.imtiaz (3/30/2014)

    Do we need...

    March 31, 2014 at 4:08 am

    #1701524

  • RE: SQL Server Failover cluster virtualbox

    chewychewy (3/29/2014)

    Hi Guys,

    I have virtualbox installed on my notebook.

    For testing purpose, is it possible to setup SQL Server Fail-Over cluster using virtual box?

    I don't have a shared storage. How can...

    March 29, 2014 at 5:29 am

    #1701359

  • RE: User database moved to "System Databases" container

    deepak.bisht (3/21/2014)

    I need help.

    One of my user database is somehow moved to "System Databases" container in SQL Server Management Studio(I don't know how it moved).

    i.e. it is visible in Enterprise...

    March 28, 2014 at 9:14 am

    #1701175

  • RE: recovering space from the Primary database file?

    Eric Mamet (3/27/2014)

    We have a little problem where our database has grown far too much and we'd like to recover (most of the) space.

    This database contains mostly one BIG...

    March 28, 2014 at 9:03 am

    #1701162

  • RE: Duplicate key issue ... again ... and again ...

    sql-lover (3/28/2014)

    Perry Whittle (3/28/2014)

    The default behaviour for an identity column now is to increase the seed after a restart or failover, etc. By doing this

    sql-lover (3/27/2014)

    I fixed it via...

    March 28, 2014 at 8:36 am

    #1701139

  • RE: Failover on 2 servers AlwaysOn AG with read-only secondary replica

    GordonLiddy (3/28/2014)

    with the primary configured for Read/write.

    This means that connections with the application intent set to ReadOnly will not be granted in the Primary role

    March 28, 2014 at 8:32 am

    #1701133

  • RE: Duplicate key issue ... again ... and again ...

    The default behaviour for an identity column now is to increase the seed after a restart or failover, etc. By doing this

    sql-lover (3/27/2014)

    I fixed it via DBCC command

    you are...

    March 28, 2014 at 7:21 am

    #1701078

Viewing 15 posts - 3,406 through 3,420 (of 9,253 total)