Azure sql server size resets to 1GB -


i working on web application based on ef on 1 gb seeded data. application hosted in azure bizspark subscription account.

i created app service plan web application associated app service sometime back. started uploading data sql server failed. realized default size 1gb upgraded plan standard plan 10 dtu , 10 gb yesterday , uploaded data around 5 days back.

after due issues, wiped out app service plan , created new one. sql server size , setup not modified.

i created new plan , uploaded application , observed following -

  1. database tables got wiped out
  2. database prizing structure reset basic

i upgraded database plan once again 10 gb , 10 dtu yesterday night. see change has not taken affect yet.

  1. how long take size fixed?
  2. will tables have recreated?

9/11 tried uploading data via bcp tool. got following error:

1000 rows sent sql server. total sent: 51000 communication link failure text column data incomplete communication link failure tcp provider: existing connection forcibly closed remote host. communication link failure

this new yesterday before changed db size got following error: 9/10

1000 rows sent sql server. total sent: 1454000 the database 'db' has reached size quota. partition or delete data, drop indexes, or consult documentation possible resolutions. bcp copy in failed

i don't understand inconsistency in failure message or upload failed same data file.

regards, lalit

scaling database higher service tier should not take more few minutes basic standard. schemas , table inside database left unchanged.

you may want activity log of azure server understand initiated scale down standard basic. furthermore, may want turn on auditing feature understand operations performed on database.

on connectivity issues, can start looking @ documentation page. looks have inserted rows several times database through bcp command , causes space issue basic tier.


Comments

Post a Comment

Popular posts from this blog

Sort a complex associative array in PHP -

this question has answer here: php sort array subarray value 5 answers i have associative array in php like: $newarray1 = array ( [producta] => array ( [link] => http://sanjosespartan.com/blog/products/agile-java-development/ [visitcount] => 4 ) [productd] => array ( [link] => http://sanjosespartan.com/blog/products/intro-to-go/ [visitcount] => 1 ) [productg] => array ( [link] => http://sanjosespartan.com/blog/products/node-js-for-developers/ [visitcount] => 1 ) [productb] => array ( [link] => http://sanjosespartan.com/blog/products/beginning-mysql/ [visitcount] => 1 ) [productc] => array ( [link] => http://sanjosespartan.com/blog/products/computer-networks/ [visitcount] => 1 ) ...
Read more

vb.net - How to ignore if a cell is empty nothing -

how use roscolor() ignore value (like empty cell) ? color row if value upper 5 when there nothing in cell, want ignore roscolor() apply, how? public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val integer val = quotedatagridview1.rows(i).cells(3).value if val = vbempty quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white elseif val < 5 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.red elseif val > 5 , val < 10 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.lightyellow end if next end sub you can check empty value following public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val = quotedatagridview1.rows(i).cells(3).value if isdbnull(val) or val nothing quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white ...
Read more

recursion - Can every recursive algorithm be improved with dynamic programming? -

i first year undergraduate csc student looking competitive programming. recursion involves defining , solving sub problems. understand, top down dynamic programming (dp) involves memoizing solutions sub problems reduce time complexity of algorithm. can top down dp used improve efficiency of every recursive algorithm overlapping sub problems? dp fail work , how can identify this? the short answer is: yes. however, there constraints. obvious 1 recursive calls must overlap. i.e. during execution of algorithm, recursive function must called multiple times same parameters. lets truncate recursion tree memoization. can use memoization reduce number of calls. however, reduction of calls comes price. need store results somewhere. next obvious constraint need have enough memory. comes not-so obvious constraint. memory access requires time. first need find result stored , maybe copy location. in cases, might faster let recursion calculate result instead of loading somewher...
Read more