sql - Joining a database to an Availability Group-error -

-

i getting "insufficient transaction log data" error when adding database (42gb) availability group. have taken full , transaction log backups on primary server , restored onto secondary, i'm not sure why there insufficient transaction logs.

i suspected maybe due large amount of time takes transfer backup files secondary server , time restore on secondary server, log backup taken insufficient.

anyone have suggestions why i'm getting error?

try shrinking log file before doing restore. also, allow wizard handle full backup, trans backup , restore.


Comments

Post a Comment

Popular posts from this blog

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub
Read more

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array(
Read more

html - Fade out of a Mp3 song using javascript -

-
i'm trying create html file javascript embedded allows me press button , begin fade out of song. i've managed working play song (which start). i've been playing around second function try , reduce volume , setting delay on function can please ?! <audio id="myaudio" <source src="1.mp3" type='audio/mp4'> </audio> <button type="button" onclick="aud_play()">play</button> <button type="button" onclick="aud_fade()">fade</button> <script> var vol = myaudio.volume; var timer; function aud_play() { var myaudio = document.getelementbyid("myaudio"); myaudio.play(); } function aud_fade(){ var myaudio = document.getelementbyid("myaudio"); if (vol > 0) { vol = vol - 0.2 ; } timer = settimeout(aud_fade,2); } </script> a couple things seem need addressing ;) first off, in example provided, have not closed aud
Read more