Forum Replies Created

Viewing 15 posts - 4,576 through 4,590 (of 9,250 total)

  • RE: Network ip

    you can also use xp_regread to query the apprpriate registry values for your SQL server instance.

    November 26, 2012 at 5:57 am

    #1562177

  • RE: How to check mirrored database

    shohelr2003 (11/26/2012)

    Thank You, Perry Whittle. But what does "database will be totally out of sequence" mean?

    The LSNs and hence restore points will be completely different between databases, it would make...

    November 26, 2012 at 5:55 am

    #1562176

  • RE: Error after changing the Domain

    mahesh.dasoni (11/24/2012)

    We have SQl Server 2005 Standard edition which was Intially on another domain at that time it was working fine.

    Now when it been moved to another domain we are...

    November 26, 2012 at 5:52 am

    #1562174

  • RE: SNAPSHOT Isolation with (NOLOCK) being used all over

    SQL_ME_RICH (11/21/2012)

    Recently, my applications architect decided that we needed to change the level of the database Isolation from the the default READ COMMITTED to SNAPSHOT ISOLATION (basically Read Committed with...

    November 26, 2012 at 5:13 am

    #1562159

  • RE: Transaction log files had grown to five times the database size.

    sanath.kumar.kura (11/26/2012)

    Hi All,

    The log file is grown to five times the database size.

    Transaction Log file size 3.1GB

    Database file size is 700 MB

    Recovery Model : Full

    backup strategy : Daily full database...

    November 26, 2012 at 4:37 am

    #1562142

  • RE: How to check mirrored database

    shohelr2003 (11/23/2012)

    Now for some reason I wanna restore database to my principal from another databse.

    Will it cause any inconsistency in mirror databse?

    Yes, of course the databases will be totally...

    November 26, 2012 at 1:27 am

    #1562090

  • RE: windows cluster ip Configuration.

    Follow my guide at these links

    Part 1[/url]

    Part 2[/url]

    Part 3[/url]

    November 24, 2012 at 4:56 am

    #1561970

  • RE: Mirror Database Recovery Problem

    Can you provide more details around your mirror setup?

    What do you mean corrupted?

    What are you doing to get the principal back online?

    November 24, 2012 at 3:12 am

    #1561968

  • RE: RAID and Its impact on your SQL performance

    The differences between RAID 1+0 and 0+1 are not academic. Let's just review that again, not academic!!!

    If you do decide to deploy a 0+1 array for your mission critical data...

    November 24, 2012 at 3:09 am

    #1561967

  • RE: backup file growth and disk size-SQL 2005 database

    Sqlsavy (11/23/2012)

    Hi All,

    We use Litespeed to backup our databases. One particular database grows 330MB/day there is enough space on the data and log drives but I think backup drive will...

    November 23, 2012 at 6:37 pm

    #1561947

  • RE: SQL Trace causes application to hang

    you never considered raising the Cost threshold for parallelism instead?

    November 23, 2012 at 8:09 am

    #1561874

  • RE: SQL Trace causes application to hang

    adb2303 (11/22/2012)

    Windows 2008 R2, SQL Server 2008 R2 SP + CU4, multi-instance cluster.

    :w00t:

    adb2303 (11/22/2012)

    32 cores (64 with h/t),

    :w00t:

    adb2303 (11/22/2012)

    384GB per node.

    :w00t:

    adb2303 (11/22/2012)

    Maxdop 4 server wide

    ??

    Why dont you just...

    November 23, 2012 at 8:02 am

    #1561871

  • RE: Tempdb log file location and Filegroup optimizations

    TheSQLGuru (11/21/2012)

    I would like to add to this thread that the number of clients I have had in 15 years of consulting that actually had tempdb allocation issues is TWO,...

    November 21, 2012 at 10:10 am

    #1561311

  • RE: How to check mirrored database

    SQLCrazyCertified (11/21/2012)

    Ohk....thanks Perry.....didn't know that.

    SueTons.

    Standard only supports full safety, this translates into synchronous mode

    😉

    November 21, 2012 at 10:05 am

    #1561310

  • RE: How to check mirrored database

    SQLCrazyCertified (11/21/2012)

    shohelr2003 (11/21/2012)

    Thank you, so nothing to be worried.

    You should also see next to the principal db says "synchronized"

    Since you have witness server, I am thinking, you configured with synchronize...

    November 21, 2012 at 7:46 am

    #1561259

Viewing 15 posts - 4,576 through 4,590 (of 9,250 total)