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!

Reply to
Jason
Loading thread data ...

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.

Reply to
Akber Alwani

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 C> My HQ server all of a sudden started saying Cannot Connect To Database. >

Reply to
Glenn Adams [MVP - Retail Mgmt

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.

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:uaSkqn$ snipped-for-privacy@TK2MSFTNGP05.phx.gbl...

Reply to
Jason

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.

Reply to
Jason

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.

Reply to
CptSoft

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.