Forum Replies Created

Viewing 15 posts - 6,916 through 6,930 (of 9,241 total)

  • RE: Question on Database Mirrorring

    what issues are you expecting or considering??

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

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

  • RE: High Memory Used in active MS SQL Clustering Server

    SQL Server buffer pool is typically the largest memory consumer, have you accounted for this?

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

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

  • RE: restarting an sql server

    thanoseft (7/14/2011)


    and i do not want it to run while i restarting

    ???????

    All operations are rolled back anyway. Do what you must but there is no need to disable the jobs...

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

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

  • RE: SQL Server Mirroring

    garfield81 (7/13/2011)


    Planning on setting up mirroring for a SQL 2008 standard production server and I realize I need to restore the DB on the mirror server with NORECOVERY and then...

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

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

  • RE: login transfers

    this link provides full details

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

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

  • RE: Application is unable to connect to the database.

    SVR (7/12/2011)


    Hi,

    I am using sql server 2008 on win 2008. I restored a database from sql server 2000 to 2008, and also installed the application using...

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

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

  • RE: restarting an sql server

    you don't need to disable the jobs to restart the instance!!

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

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

  • RE: Set recovery full for multiple database

    how many databases on the server are 90 compatibility

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

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

  • RE: Database Mirroring setup issue

    geenrally you dont want to use the sql server service account as the security principal for your endpoints. Create a base domain user, grant login to sql server and grant...

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

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

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

    tobyteel (7/12/2011)


    Why would you want to do this? What does this achieve?

    I thought that was clear from the introduction, thanks for your feedback

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

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

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

    thats the latest version which i'm not using in the tutorial and there is a vast difference. try this link for v7 stable release

    http://sourceforge.net/projects/freenas/files/FreeNAS-7-Stable/[/url]

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

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

  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    RAID10 can offer fast reads depending upon the controller used. Modern RAID10 arrays will read from all online disks to improve performance

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

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

  • RE: Database Mirroring setup issue

    pshaship (7/12/2011)


    Thanks for the links.

    Below are the error messages from the errorlog

    On Principal server's error log:

    Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was...

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

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

  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    RAID5 and RAID6 have the overhead of parity calculations. RAID10 write performance is much better.

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

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

  • RE: SQL server 2005 cluster installation fails on windows server 2003

    you were upgrading this instance is that correct?

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

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

Viewing 15 posts - 6,916 through 6,930 (of 9,241 total)