Keep Alive - SATA III to USB 3.0 Docking
Published: Thursday, November 29, 2018 written by Andy Flagg
View Count: 233
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:
dir c:\windows\temp > j:\temp.txt
timeout /t 60 /nobreak > nul
more to come..
if you found this article helpful, consider contributing $10, 20 an Andrew Jackson 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.
© 2020 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.