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
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!
You have taken the only .mdf file backup i think it is not complete as you
require to take the .ldf file also which is primary log file. make sure to do
the backup from the program so it will combine both of these files and your
restoration process will be simple.
Now if you taken the backup from program then simple procedure is go to
Admin program and then first connect to SQL Server don't put the database
name then, go to database and create new database name it anything you want
and when it ask for the database file give the backup file you have. then it
will create new database and restore the all its objects from your backup.
Once done then go to File->Configuration and specify the user id, password
and name of database, along with your server name. Let me know if you still
face the problem.
If the HQ Database is running on the same system as HQ Administrator,
log into windows as an Administrator
in HQ Admin, File/Connect, Select "Windows Authentication" (You won't
need to enter the SQL User & Password).
If this gets you connected,then the DB is fine and yes you really do
have a bad password. There is a knowledge base article that gives
instructions for changing it, or you can search the newsgroup - it's
been posted here before...
If you have the .mdf and .ldf files you can attach them to a new
database install and you will immediately be up to date. Do a google
search for "Attach database" and you should find steps, but this is kind
of advanced - there is no RMS menu option to do it.
if you have a DB Backup taken from RMS Manager or Admin, that is a
"snapshot" backup - you can't use it for a differential restore (the
transactions after the backup). There are certainly ways to create
those backups in SQL Server, but if you are asking the question then you
didn't have it set up in advance so it is too late now. Generally,
taking a single file daily backup after business hours is sufficient for
most RMS users.
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.
It was definitely not a password problem. Again, I have run into this
before. Some MSDE file gets overwritten and the whole thing goes bad...
I am very happy right now that I had the foresight to backup the mdf and ldf
files rather than using the backup from the prior evening. It went smooth
and all tranactions after the problem began were properly uploaded to the HQ
database on the next 401 connection.
I am going to add mdf and ldf backup to my backup routine, both for this
reason and because I have had experience with corrupt backup files.
Now what I did not do is any "attaching." The way I handled it was as
follows: When removing HQ and MSDE from your computer, it will delete all
user created databases. Again, glad I had some foresight. Upon reinstalling
I just had the master and test databases. I created a new HQ database with
the same name as my previous database. Then I exited HQ and turned off SQL
server and overwrote the newly created mdf and ldf files with my backup
copies. Voila - it worked perfectly.
My plan to backup nightly the mdf and ldf files is not working.
I have a batch file that runs on a schedule to copy my backup files to a
network share. I wanted to also copy the mdf and ldf files to the network
share, but I get a Sharing Violation presumably because MSDE has locked the
files. How can I shut down MSDE/SQL Server from the command line so I can
copy the files? I don't need to restart it because the batch file later
restarts the compter.
From a command prompt or batch file;
NET STOP mssqlserver
If using RMS default installation
Check Point Software
You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.
----------------------------------------------<BR>>> Please DO NOT
respond to me directly but post all responses here in the<BR>>>
newsgroup so that all can share the
information.<BR>>><BR>>><BR>>> Jason wrote:<BR>>>>
My HQ server all of a sudden started saying Cannot Connect To
Database.<BR>>>><BR>>>> When I go into HQ Admin and try to
connect it says that login for 'sa' <BR>>>> is incorrect, which it is
not. I have run into this same thing before <BR>>>> with a store ops
computer. It seems like MSDE gets corrupted during a <BR>>>> Windows
Update.<BR>>>><BR>>>> Anyway, I have a backup of my database
from last night and I just backed <BR>>>> up the .mdf file also just
in case. My questions is, when I reinstall <BR>>>> MSDE and HQ Server
and HQ Manager, what steps do I need to go through <BR>>>> after
restoring my backup to make sure HQ gets all of the data missing
<BR>>>> between the backup and the current
time?<BR>>>><BR>>>> Thanks in advance!<BR>><BR>>
BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here.
All logos and trade names are the property of their respective owners.
Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee
neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.