Notes from the Ether

I’ve found this little legacy app on our network that runs on MSDE.  Of course, there’s no documentation on it, so to restor the app on a new server requires me to reset the sa login. Here’s how: from the command prompt, execute: osql -E -Q “sp_password NULL, ‘newpassword’, ‘sa’” #### replace newpasswd with a [...]

Today I had to set up some SQL Log Shipping, but the source server had transaction logs from the past few months that were never cleaned out because SQL 2005 was running with a “Full” backup model (as opposed to “simple”, that never cleaned out the transaction log files after the backups ran.  So, today, [...]