Forum Replies Created

Viewing 15 posts - 4,621 through 4,635 (of 9,241 total)

  • RE: Log Shipping question.

    SQLSACT (11/15/2012)

    The moment your recover the secondary database in a Log Shipping setup, a restore is required to re-start the session again.

    this is incorrect, role switching in log shipping...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 15, 2012 at 12:01 pm

    #1559473

  • RE: What would be the best RAID configuration for this hardware?

    TheSQLGuru (11/15/2012)

    I think with so few spindles carving them up into smaller sets just sets yourself up for one or more of those smaller groups to be a bottleneck. ...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 15, 2012 at 11:55 am

    #1559471

  • RE: new 64-bit Sql 2005 Server - integrity check completes then memory spikes 75% and doesnt lower

    jswong05 (11/14/2012)

    If you don't want to distribute so much memory on SQL Server usage, just lower the Max memory. You can also issue commands to clear buffer and procedure cache...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 1:30 pm

    #1559106

  • RE: Seaparating Data files and Log Files

    chandan_jha18 (11/14/2012)

    Perry,

    Thanks for replying.

    The server uses VMWare and the sysadmin wrote the following to me:

    'All of these drives are situated on the same set volume on the NetApp'.

    He also wrote...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 8:30 am

    #1558967

  • RE: Availibility Group Listener Name

    yes, so you'll need to filter for your particular group then won't you 😉

    Check the link below for more info

    http://msdn.microsoft.com/en-us/library/ff878305.aspx

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 6:31 am

    #1558897

  • RE: Mount Point quick question

    sql-lover (11/14/2012)

    Thanks Perry,

    I'll take a look today

    It will help you understand better 😉

    sql-lover (11/14/2012)

    but regardless , with a max of two failover instances on a two node clusters ,...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 6:16 am

    #1558890

  • RE: Availibility Group Listener Name

    Check the following system catalog for listener info

    select * from sys.availability_group_listeners

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 5:33 am

    #1558873

  • RE: shifting sql server from one system to another

    abdsubhani (11/14/2012)

    Hi all,

    In our organisation we are shifting sql server to another system. we are done with that but we are not able to get logins. we need to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 3:53 am

    #1558837

  • RE: Mount Point quick question

    sql-lover (11/13/2012)

    Hi,

    I am working on the design of a MS-SQL 2012 failover cluster, running on top of Windows 2008. I am assuming mount point's behavior is similar between Denali and...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 3:45 am

    #1558832

  • RE: change initial size of tempdb

    are you increasing or decreasing the initial size?

    are the files all currently the same initial size?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 3:31 am

    #1558828

  • RE: Failed Transaction Log Restore

    can you post details of the exact error you receive?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 3:02 am

    #1558820

  • RE: SQL IO Performance

    robr-793239 (11/13/2012)

    I'm running out of brain cells trying to figure out what I've overlooked. Hoping someone has a quick checklist of things I can look for...

    Scenario: I have 3 SQL...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 3:00 am

    #1558817

  • RE: Seaparating Data files and Log Files

    chandan_jha18 (11/14/2012)

    Hi Folks,

    I am facing an issue which I thought I understood but looks like reading and implementing a strategy are very different.

    I have a SQL 2008 running on a...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 14, 2012 at 2:54 am

    #1558814

  • RE: What would be the best RAID configuration for this hardware?

    Controllers and disks differ. The only sure fire way is to create test arrays and spin up SQLIO to test your throughput and latency. Try different arrays and number of...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 12, 2012 at 5:16 pm

    #1558355

  • RE: SQL 2012 multisite cluster

    charmon79 (11/11/2012)

    Perry Whittle (11/9/2012)

    rupengzhao (11/7/2012)

    Hi All,

    With SQL 2012, one can setup multi-site (multi-subnet) failover clusters.

    This is also possible with Windows and SQL Server 2008

    I've been researching this as well for...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    November 12, 2012 at 6:12 am

    #1558138

Viewing 15 posts - 4,621 through 4,635 (of 9,241 total)