URGENT: Reinstall of HQ and restore of backup

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!
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
HI Jason, 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.
"Jason" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
If the HQ Database is running on the same system as HQ Administrator, try this: 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.
Glenn Adams Tiber Creek Consulting http://www.tibercreek.com snipped-for-privacy@tibercreek.com ---------------------------------------------- Please DO NOT respond to me directly but post all responses here in the newsgroup so that all can share the information.
Jason wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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.
message

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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.

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Jason,
From a command prompt or batch file;
NET STOP mssqlserver
If using RMS default installation
--
Jeff 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.
http://tinyurl.com/75bgz =====================================================
----------------------------------------------<BR>&gt;&gt; Please DO NOT respond to me directly but post all responses here in the<BR>&gt;&gt; newsgroup so that all can share the information.<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; Jason wrote:<BR>&gt;&gt;&gt; My HQ server all of a sudden started saying Cannot Connect To Database.<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; When I go into HQ Admin and try to connect it says that login for 'sa' <BR>&gt;&gt;&gt; is incorrect, which it is not. I have run into this same thing before <BR>&gt;&gt;&gt; with a store ops computer. It seems like MSDE gets corrupted during a <BR>&gt;&gt;&gt; Windows Update.<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Anyway, I have a backup of my database from last night and I just backed <BR>&gt;&gt;&gt; up the .mdf file also just in case. My questions is, when I reinstall <BR>&gt;&gt;&gt; MSDE and HQ Server and HQ Manager, what steps do I need to go through <BR>&gt;&gt;&gt; after restoring my backup to make sure HQ gets all of the data missing <BR>&gt;&gt;&gt; between the backup and the current time?<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Thanks in advance!<BR>&gt;<BR>&gt; <BR><BR></BLOCKQUOTE></BODY></HTML>
------=
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

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.