Forum Replies Created

Viewing 15 posts - 3,751 through 3,765 (of 9,244 total)

  • RE: TEMPDB Configuration per vCPU

    Paulo A. Nascimento (1/15/2014)

    Well if tempdb database was, say, 640 MB in size, then that would not seem strange to me :-). 64 MB is exactly exactly 10% of the...

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

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

    January 15, 2014 at 11:41 am

    #1680388

  • RE: Splitting DBs into multiple files for IO spread

    Michael Valentine Jones (1/15/2014)

    There is another possibility: Use the four LUNS to create a single volume on the server for the database datafiles.

    The data would be spread across the...

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

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

    January 15, 2014 at 11:27 am

    #1680383

  • RE: Log Shipping scans files but doesn't restore

    Steve Jones - SSC Editor (1/15/2014)

    and an item for Connect.

    No, log shipping is doing exactly what it should be. If anything, you'll probably get an unsupported message for the...

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

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

    January 15, 2014 at 9:24 am

    #1680335

  • RE: Question about SRDF DR test

    looking at the document i linked above its done at the array level. If all LUNs for the instances are carved from the same array (and i'm guessing they are)...

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

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

    January 15, 2014 at 8:07 am

    #1680287

  • RE: Question about SRDF DR test

    ah i see. You'll need to speak to the storage administrator regarding the SRDF storage fail over

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

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

    January 15, 2014 at 7:39 am

    #1680268

  • RE: What is the default sa password?

    It's simples, the only sure fire thing to do when performing the change from windows to mixed is to issue this staright after

    ALTER LOGIN [sa] WITH PASSWORD = 'somelongpassword';

    ALTER LOGIN...

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

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

    January 15, 2014 at 7:36 am

    #1680264

  • RE: Correctly sizing Temp datafiles

    PearlJammer1 (1/15/2014)

    Find out what is generating the hash\sort warnings and fix it. Just extending TempDB is merely putting a sticky plaster over the real problem.

    Would I be best setting...

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

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

    January 15, 2014 at 6:59 am

    #1680252

  • RE: Question about SRDF DR test

    SQLisAwE5OmE (1/15/2014)

    Perry Whittle (1/15/2014)

    SQLisAwE5OmE (1/15/2014)

    I have 2 node, active/active cluster with 10 instances on it.

    I have to do a DR test(SRDF), however, one of the application/instance do not want to...

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

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

    January 15, 2014 at 6:57 am

    #1680251

  • RE: Question about SRDF DR test

    SQLisAwE5OmE (1/15/2014)

    I am not too experienced with SRDF, so if you can share your experience, it would be great.

    You shouldnt need to be it's ouitside of your control as the...

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

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

    January 15, 2014 at 6:51 am

    #1680247

  • RE: Question about SRDF DR test

    SQLisAwE5OmE (1/15/2014)

    I have 2 node, active/active cluster with 10 instances on it.

    I have to do a DR test(SRDF), however, one of the application/instance do not want to move to DR...

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

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

    January 15, 2014 at 6:42 am

    #1680242

  • RE: Splitting DBs into multiple files for IO spread

    sql4gnt (1/13/2014)

    I have a question to add to this...would separating a database into multiple files on the same storage group have much of an impact? (Not considering SAN caching...

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

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

    January 15, 2014 at 6:40 am

    #1680240

  • RE: Newly Migrated backend DB

    you'll need to use linked table manager to relink the tables

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

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

    January 15, 2014 at 6:32 am

    #1680234

  • RE: Newly Migrated backend DB

    check connections in the sql server.

    Rename the backend Access db 😀

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

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

    January 15, 2014 at 5:31 am

    #1680216

  • RE: database Restore hystory LOG

    jamessdba (1/15/2014)

    Thanks i found this info under log

    C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log...

    😉

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

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

    January 15, 2014 at 5:30 am

    #1680215

  • RE: desensitize data after a restore

    PearlJammer1 (1/15/2014)

    looks like a complicated process to implement. I'm going to have to give this some serious thought.

    :-):-)

    What?

    Identitfy the Live tables that require obfuscating (there's likely only a few). Build...

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

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

    January 15, 2014 at 4:57 am

    #1680202

Viewing 15 posts - 3,751 through 3,765 (of 9,244 total)