Forum Replies Created

Viewing 15 posts - 5,566 through 5,580 (of 9,244 total)

  • RE: Transaction log/Full backup and Recovery

    AK1516 (5/14/2012)


    I have 2 TB database and I am doing a full backup daily. For now i have transactional log backup also running for every 30 mins for the whole...

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

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

  • RE: sa_help_rev.erse.sa.login

    why not just use the system function fn_varbintohexstr()

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

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

  • RE: SQL 2012 High Availibility

    Yes, fail over cluster instances may participate as an availability replica in AlwaysOn availability groups. Think of it like this

    You have a WSFC comprising of 3 nodes. You have a...

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

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

  • RE: SQL 2012 High Availibility

    derekr 43208 (5/12/2012)


    Perry Whittle (5/12/2012)


    derekr 43208 (5/12/2012)


    Regarding Storage: Am I right in that SQL 2012 HA Features doesn't make use of shared storage?

    From what I understand, it uses Failover Clustering,...

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

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

  • RE: SQL 2012 High Availibility

    derekr 43208 (5/12/2012)


    Which configuration Provides Database Level redundancy including Hardware Redundancy(Clustering)

    Thanks

    AlwaysOn availability gropus provide redundancy at the database (or a group databases) level.

    A failover cluster instance provides protection at the...

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

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

  • RE: SQL 2012 High Availibility

    derekr 43208 (5/12/2012)


    Regarding Storage: Am I right in that SQL 2012 HA Features doesn't make use of shared storage?

    From what I understand, it uses Failover Clustering, without the shared storage

    Is...

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

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

  • RE: SQL 2012 High Availibility

    derekr 43208 (5/8/2012)


    Hi All

    A question regarding the SQL 2012 High Availibility Features

    I understand that in order to use the High Availibility Features that comes with SQL 2012, the Servers need...

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

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

  • RE: Sllipstream a cumulative update into a service pack

    be honest with you i've never it tried it hat way but cant see it wouldn't work, give it a go it'll either work or it won't

    Download SP3 and CU4...

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

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

  • RE: LITESPEED xp_slssqlmaint issue

    my first temptation would be to re run the instance configuration and re create all the procedures, if you're still having issues after that maybe check with Quest support

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

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

  • RE: Active\Active cluster how many MSDTC needs to be configured?

    Ok, so you can leave DTC running locally as Elliott has pointed out and that's fine for some scenarios but this can affect in flight transactions though upon a failover,...

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

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

  • RE: LITESPEED xp_slssqlmaint issue

    what is your Litespeed version you are using?

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

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

  • RE: SQL Injection Vulnerability Question

    hisakimatama (5/10/2012)


    The application is certainly a Windows-based application, then.

    so it's not exposed to the "outside world" then.

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

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

  • RE: cant create logins in SQL

    Sounds like you're going to need single user mode to sort this one 😉

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

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

  • RE: SQL Injection Vulnerability Question

    hisakimatama (5/9/2012)


    I'm not sure what the distinction is there, Perry; I'm assuming Windows form would mean something coded in a language such as Java, C#, C++, etc.? Either way,...

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

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

  • RE: SQL Injection Vulnerability Question

    hisakimatama (5/9/2012)


    Hrm. Upon looking further into their coding, I've stumbled upon this:

    SET NOCOUNT ON;

    DECLARE @whereClause2 nvarchar(1000)

    SET @whereClause2 = @whereClause

    set @whereClause2 = ISNULL(@whereClause2,'')

    declare...

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

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

Viewing 15 posts - 5,566 through 5,580 (of 9,244 total)