sql server 2005 - SQLSERVER mirroring VS Log shipping -

-

i need understanding mirroring follwoing example.

primary server in fl mirror server in germany

my application doing insert table fl system

case 1 : mirror server down -- network issue -- assume insert written transaction log on principal -- not commited disk happen if tries query fl database.will see last transaction[insert]? when sql server perform query, @ both db , tlog?.

case 2: if mirror server down 2 days. guess transation log continue grown. can explain how affect response time of appplication

case 3 : if mirror down while (week). better break mirroring. also, means have take full backup of db again in order reconfigure mirroring

you haven't specified kind of mirroring, assume high safety automatic failover

case 1 : principal in 'disconnected' state. transactions committed disk on principal, not mirror (obviously). transactions remain in 'active' part of log , not backed up. i.e. see transaction log grow , log_reuse_wait_desc column in sys.databases mirroring. fl database remain offline , in disconnected state. not able query unless use force_service_allow_data_loss bring online @ point you've broken mirror (although principal doesn't know yet & continue hold logs)

case 2: transaction log keep growing in accordance autogrow settings. usual case autogrowing logs, have overhead everytime autogrow , potentially end lots of virtual log files. best set autogrow reasonable it's not growing in 50mb increments.

case 3: depends on how data change you've had changed compared size of full database backup need copied between sites re-init mirroring. in sql server 2008 have options log compression means can stuff more transaction down wire less bandwidth (if you're using it)


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more