Forum Replies Created

Viewing 15 posts - 3,721 through 3,735 (of 9,241 total)

  • RE: Verify Backups

    Talib123 (1/17/2014)


    I'll read through all of this later but the Environment is too large and too much going on to test backups regularly. 150 + Servers. Just one DBA.

    99% of...

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

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

  • RE: Reclaim free space

    Thats why its not shrinking immediately the pages wont be freed straight away. Ghost cleanup handles that

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

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

  • RE: TEMPDB Configuration per vCPU

    Paulo


    The 10% theory is an old and good one, as long one doesn't take it literally.

    As already said, data file growth is not an issue if Instant File Initialization...

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

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

  • RE: SQL 2008 failover 2 node (A/P) license upgrade from STD to ENT

    Spud312R (1/17/2014)


    We have a 2 node STD sql 2008 sql failover cluster running A/P mode

    We want to upgrade the sql lic from STD to ENT but do not...

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

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

  • RE: Reclaim free space

    please post the exact commands you used

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

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

  • RE: Verify Backups

    Talib123 (1/17/2014)


    How can I tell which of my backup jobs is using the verify option.

    I have an estate with over 80 Servers. Is there a table in the MSDB that...

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

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

  • RE: TDE Enable???

    you're welcome, thanks for posting back

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

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

  • RE: SQL Named Instance Corruption During Multi-Site and AG Testing

    Ah ok no AO yet.

    Has the mirros session ever successfully connected\synchronised?

    What accounts are the sql server services running under?

    Did you use gui or tsql to setup mirroring?

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

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

  • RE: Need to make serverproperty('servername') the same as @@servername

    Susan-322874 (1/16/2014)


    We use naming conventions for our SQL Servers and I'm having an issue getting the serverproperty(servername) match the @@servername.

    I know that SQL controls the @@servername and I have that...

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

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

  • RE: TDE Enable???

    Sure, you can encrypt connections to SQL Server but it only uses 40 or 128 bit and based on the client. IMHO column level encryption is better, it's likely you...

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

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

  • RE: TDE Enable???

    In favour of TDE, it does also automatically encrypt any database backups, users may not just pilfer the backups and go restore them, they'll need the certificate that encrypts the...

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

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

  • RE: TDE Enable???

    New Born DBA (1/16/2014)


    Which raises another question. Let's say if there is a DB which consist of 30 tables. All columns in those tables have to be encrypted. Why its...

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

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

  • RE: SQL Server 2012 AlwaysOn

    crcoracle (1/16/2014)


    Hi,

    Do you guys know if I can set up a new SQL Server cluster with AlwaysOn Availability groups as follows:

    - One node inside the local network

    - Another node in...

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

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

  • RE: SQL Named Instance Corruption During Multi-Site and AG Testing

    Which replica is currently] the AO group primary, is it the FCI?

    Have you configured a listener for the AO group?

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

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

  • RE: TDE Enable???

    if you encrypt the data at the column level you wont need TDE.

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

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

Viewing 15 posts - 3,721 through 3,735 (of 9,241 total)