My HQ server all of a sudden started saying Cannot Connect To Database.
When I go into HQ Admin and try to connect it says that login for 'sa' is incorrect, which it is not. I have run into this same thing before with a store ops computer. It seems like MSDE gets corrupted during a Windows Update.
Anyway, I have a backup of my database from last night and I just backed up the .mdf file also just in case. My questions is, when I reinstall MSDE and HQ Server and HQ Manager, what steps do I need to go through after restoring my backup to make sure HQ gets all of the data missing between the backup and the current time?
Thanks in advance!