Save the original database "raw" files in a secure location (or two to be safe). Stop SQL Server, then delete the original database from the database location. Start SQL Server. Next, create a new database using Admin with the same names. Stop SQL Server again. Overwrite the new small database with the "raw" database files you backed up. Start SQL Server.
Now when you start RMS SO or POS you will be using the "raw" database you want.
On that note, I always backup the "raw" database files in addition to my night backups. I had to restor from backup once, but RMS said the .BCK was corrupt. That ruined my week.
Is there a way to restore these files, these are raw database files how can I restore these files to rms? Thanks a lot
CHICAGO CASH REGISTER Daniel Buntic snipped-for-privacy@chicagocashregister.com 847-965-9500 -----Original Message----- From: Jozsef Gitta [mailto: snipped-for-privacy@jgitta.com] Posted At: Friday, May 30, 2008 5:44 PM Posted To: microsoft.public.pos Conversation: RMS DATABSE, WHERE DOES RMS KEEP THE DATABSE Subject: Re: RMS DATABSE, WHERE DOES RMS KEEP THE DATABSE
daniel buntic wrote: > > > IS THERE A WAY TO RECOVER THE DATABASE EXCEPT THE USING THE BACKUP > FEATURE OF RMS. > THIS IS THE CASE. WINDOWS XP WILL NOT IT HAS SOME DAMAGED FILES, SO WE > TOOK OUT THAT HD AND INSTERTED INTO ANOTHER PC AS A SECOND HD. SO WE CAN > ACCESS THE MICROSOFT RMS FOLDER ON THAT DRIVE BUT I CAN NOT FIND THE > DATABASE FILES ANYWHERE. WHERE DOES RMS KEEP THE DATABASE FILES AND CAN > COPY IT AND RESTORE IT? ANY HELP WOULD BE APPRICIATED. > > TX >
The database files are usually found in the SQL folder something like this; C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data