SQL SERVER 2008 R2 + Database In Recovery -


i store data web app in sql server 2008 r2. when connected ssms today database had (in recovery) in front of it.

when ran query: select databasepropertyex('nydatabase', 'status')

the status comes online.

i confused should next.

does mean recovery has happened successfully. if yes, why sql has in recovery in front of db still?

with sql server express 2008r2, auto_close property set true default:

setting database options

true databases when using sql server 2000 desktop engine or sql server express, , false other editions, regardless of operating system.

when set, property can cause behaviour you're seeing, i.e. ssms queries sql server metadata , @ particular instant database being opened.

if set auto_close false, should disappear.

you'll find few recommendations have set, anyway. can see through this link it's deprecated in 2008r2 it's odd it's still set default in circumstances.

microsoft employee buck woody describes why setting not help:

sql server best practices: autoclose should off

basically, in unused databases causes more work database engine prevents.


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more