Rebuilding an SQL server that I just finished single-handedly corrupting with a single query script.
Fortunately for me the database is small and this is a part-time production server. I have some time. lol
Have yet to screw up a DB via my own mistakes, but, I do manage a couple, and write the software to write to them.
I work on the production server directly... then again, it's no big deal if I screw it up. Just a few minutes of downtime while I drop and recreate the DB and populate it again with a few items.
I restored the database with success. But the EMR app that uses it won't start. The logs say a certain user cannot login because it doesn't exist, but it does.
It exists on the security table of the database but not on the security list of the SQL server. Not sure why this is an issue now, never had this problem before with many database restores.
·
·
.