restoring a corrupt HQ backup database?

Kamal Hood wrote: > We are located in Oakland, CA so if anyone can help us restore this backup

Do you have enterprise manager to try with it?

Antonio

i don't know what enterprise manager is but will look into it.

however, the question still stands....is there anyone that knows how to restore RMS backup databases?

thanks, kamal

Kamal,

All the following commands are in Store Ops Administrator

File | Connect | put in your password | OK

Backup the existing database. When you save it, give it a unique name. Database | Backup

Delete the database Database | Delete

Create a new one using the older backup as a template Database | Create | Give it the same name as the corrupt one | on the 3rd screen, point to your older database

Is the file physically located on the SQL Server machine? If so, are you accessing through the Drive Letter or through a share? Try restoring the database by using SO Administrator locally on the SQL Server machine rather than from a register or management station. Sometimes you will have problems restoring a backup from a network location - so try to use the drive letter and path rather than a share. You might also check user permissions on the file and the directory it's in.

enterprise manager is admin-console of SQL-Server.. not MSDE or SQL 2k Desktop Engine (blablabla.. MSDE 2K!)

With Enterprise manager you have no size-limit of database.. and you can admin your database correctly ... your db backup is corrupt or what?

also via OSQL..

RESTORE DATABASE yourdbname FROM DISK ='fullpath.bck' /* Optional parameters.. if you restore the database on another server */ WITH MOVE 'logical_name' TO 'pathfile', MOVE 'logical_name' TO 'pathfile'..

In RMS HQ you have for standard two logical file..

QSC2000HQ_Data with all tables QSC2000HQ_Log with transaction log (simple recovery model for rms standard)

if you have problem with restore.. please write and if is urgent send me a copy also via email...

bye antonio

I would even suspect that the database could be oversize (2GB) or the Translog could be......

Antonio recomended getting SQL 2000. You should do this.

Ivan Brebner