SQL Server Performance

Database mirroring

Discussion in 'SQL Server 2005 Database Mirroring' started by alexboy456, Mar 30, 2007.

  1. alexboy456 New Member

    Sorry about this question but I am new to SQL. I am looking at getting a SQL server to run sage 200. it will be serving 20 – 25 users. the server will be a DL385 g2 with duel Opteron 2.8ghz 8gb ram 6*72gb 15k SAS drives(2 drives raid 1+0 and the rest raid 5). The database I am guessing will be no more than 8gb. Software windows server 2003 enterprise and SQl 2005 standard (both 32bit unfortunately as sage don#%92t support 64bit). We will hopefully at some point be putting in a second small sql server for some access control software as well. We are putting in a second small server so that the sage has full reign of the server. Would I be able to setup database mirroring on the second server for the sage server in case of failure?

    I apologise in advanced if this is a stupid question
  2. alexboy456 New Member

    sorry just notices wrong forum
  3. satya Moderator

    Yes the database mirroring is possible in this case provided the mode you want to choose for the databases on your SQL server.
    Ensure to select the required databases on the DB mirroring as it is pertained to databases only and not for whole server.

    Post is moved to DB Mirroring from H/w perf.tuning section (appreciate your feedback).

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  4. alexboy456 New Member

    Thanks satya
  5. Ramana New Member

    Hi

    I want complete database mirroring setup with screenshots.. can some one please help me on this...very urgent...

    Ramana
  6. MohammedU New Member

  7. satya Moderator

Share This Page