RMS DATABSE, WHERE DOES RMS KEEP THE DATABSE

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

Reply to
daniel buntic
Loading thread data ...

The database files are usually found in the SQL folder something like this; C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Reply to
Jozsef Gitta

The database files are usually found in the SQL folder something like this; C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Reply to
daniel buntic

Hi Daniel - first install sql server express and mgmt studio express on the new computer that will host the db - open mgmt studio right click databases and select ATTACH - point to the mdf file in the secondary drive and finish the process.

There is also a sql query you can run from store ops administrator 'exec sp_attachdb' but this is a little more 'convoluted' - also, I can't confirm

100 percent that sql server express supports that stored procedure, anyway - here's the syntax from sql server 2005 books on line -- hope this helps.....

Syntax sp_attach_db [ @dbname= ] 'dbname' , [ @filename1= ] 'filename_n' [ ,...16 ] Arguments

[ @dbname= ] ' dbname ' Is the name of the database to be attached to the server. The name must be unique. dbname is sysname, with a default of NULL. [ @filename1= ] ' filename_n ' Is the physical name, including path, of a database file. filename_n is nvarchar(260), with a default of NULL. Up to 16 file names can be specified. The parameter names start at @filename1 and increment to @filename16. The file name list must include at least the primary file. The primary file contains the system tables that point to other files in the database. The list must also include any files that were moved after the database was detached.

"daniel buntic" wrote:

Reply to
convoluted

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

Reply to
Jason

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

Reply to
Dan-902

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

Reply to
Jason

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

Reply to
Dan-902

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.