Forum Replies Created

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

  • RE: Multiple Availability Group Listeners - best practice to define ports?

    your setup is not clear from your description

  • RE: Always On

    The only time shared storage comes into play is when you incorporate an FCI as an AlwaysOn replica

  • RE: Clustering

    ramana3327 (1/18/2014)


    Hi,

    Please let me know the main difference b/n Microsoft Clustering & Veritas Clustering.

    What is the use of Domain controller in clustering? I mean is it mandatory to create domain...

  • RE: Upgrading from SQL 2012 Standard to 2012 Enterprise

    launch the installation media and in the installation centre there is an option to upgrade the SQL Server edition. Should be fairly painless to complete

  • RE: Insert or update

    could it be the OP is actually confused and is really enquiring about the MERGE option?

  • RE: Copy logins with their password

    GilaMonster (1/20/2014)


    Also consider the SSIS Transfer Logins task.

    Oh jesus, not that festering steamy pile of doggy doo doo 😀

    My script is a lot cleaner and easier 😉

  • RE: Copy logins with their password

    SQL_Surfer (1/17/2014)


    I need to copy some databases from one server to another. What is the best way to copy logins with their passwords? Each login has access to multiple databases...

  • RE: TDE Enable???

    You would usually purchase certs from a recognised vendor rather than self generating them 😉

  • 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...

  • RE: Reclaim free space

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

  • 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...

  • 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...

  • RE: Reclaim free space

    please post the exact commands you used

  • 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...

  • RE: TDE Enable???

    you're welcome, thanks for posting back

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