GoGreen PC TuneUp™
Learn More

Insta-Install™
this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com

myBlog

myBlog Home

Back to Blog MTNCOMP


Keep Alive - SATA III to USB 3.0 Docking

Published: Thursday, November 29, 2018 written by Drew Jackson
View Count: 138
Keywords: tripp lite usb 3.0 dock keep alive sleep



something trivial and minor but relevant to my current db tasks.

 
My SQL db kept giving me a message about state of db error even though the database was there.. so at night I go into SQL management studio and for the primary db that I have on the external drive, I take the db offline and disconnect any live connections, and then turn off the drive. in the morning, I turn the dock on, and then go back into smss and bring the database back online. Just right click on DB and All Tasks | take on or off line.
 
the keep alive batch file I have on my desktop that runs is below:
 
 
keepusbdockalive.cmd
@echo on
:loop
dir c:\windows\temp > j:\temp.txt
timeout /t 60 /nobreak > nul
goto loop
 
more to come..

if you found this article helpful, consider contributing $10, 20 or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.

© 2019 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.