Database problems

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Database problems Terry 06-21-2006  Re: Database problems Jeff 06-21-2006  Re: Database problems Terry 06-21-2006  Re: Database problems Jeff 06-22-2006  Re: Database problems Terry 06-22-2006  Re: Database problems ozzie 06-22-2006  Re: Database problems root 06-22-2006  Re: Database problems Caze 09-10-2006  Re: Database problems Jeff 09-10-2006  Re: Database problems Jason 09-11-2006  Re: Database problems j 06-24-2006
Posted by Terry on June 21, 2006, 2:58 pm Please log in for more thread options I am a computr Tech, I installed RMS for a friend and explained that they need to back it up every night, which i discovered has not been done. Now when I try to use store Ops, I get "login failed" If I go to Ops Admin, I can connect to the DB, but when I test the connection, it tells me "login failed" at one point i even get "the database has been marked suspect by recovery" I cannot ever use Operrations manager Help me PLEASE -- Terry Posted by Jeff on June 21, 2006, 10:38 pm Please log in for more thread options Terry, Are you sure you are using the correct SQL SA password? How did you copy/install/place the database onto the computer's hard drive? -- * Get Secure! - www.microsoft.com/security You must be using Outlook Express or some other type of newsgroup reader to see and download the file attachment. 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 ********** I am a computr Tech, I installed RMS for a friend and explained that they need to back it up every night, which i discovered has not been done. Now when I try to use store Ops, I get "login failed" If I go to Ops Admin, I can connect to the DB, but when I test the connection, it tells me "login failed" at one point i even get "the database has been marked suspect by recovery" I cannot ever use Operrations manager Help me PLEASE -- Terry Posted by Terry on June 21, 2006, 11:44 pm Please log in for more thread options this is happening several month's after an upgrade from QS2000. the database was picked up by RMS and was in use until 2 -3 days ago. Yes I am sure about ht password -- Terry "Jeff" wrote: > Terry, > > Are you sure you are using the correct SQL SA password? > > How did you copy/install/place the database onto the computer's hard drive? > > -- > * > Get Secure! - www.microsoft.com/security > > You must be using Outlook Express or some other type of newsgroup reader to > see and download the file attachment. 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 > > ********** > > I am a computr Tech, I installed RMS for a friend and explained that they > need to back it up every night, which i discovered has not been done. Now > when I try to use store Ops, I get "login failed" If I go to Ops Admin, I > can > connect to the DB, but when I test the connection, it tells me "login > failed" > at one point i even get "the database has been marked suspect by recovery" > > I cannot ever use Operrations manager > > Help me PLEASE > -- > Terry > > > Posted by Jeff on June 22, 2006, 4:54 pm Please log in for more thread options Terry, My suggestion is that you contact the SQL Server/MSDE newsgroups for a possible fix. You should be able to use SO Admin queries or TSQL statements to fix it. For starters, try; microsoft.public.sqlserver.server microsoft.public.sqlserver.msde -- * Get Secure! - www.microsoft.com/security You must be using Outlook Express or some other type of newsgroup reader to see and download the file attachment. 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 ********** this is happening several month's after an upgrade from QS2000. the database was picked up by RMS and was in use until 2 -3 days ago. Yes I am sure about ht password -- Terry "Jeff" wrote: > Terry, > > Are you sure you are using the correct SQL SA password? > > How did you copy/install/place the database onto the computer's hard > drive? > > -- > * > Get Secure! - www.microsoft.com/security > > You must be using Outlook Express or some other type of newsgroup reader > to > see and download the file attachment. 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 > > ********** > > I am a computr Tech, I installed RMS for a friend and explained that they > need to back it up every night, which i discovered has not been done. Now > when I try to use store Ops, I get "login failed" If I go to Ops Admin, I > can > connect to the DB, but when I test the connection, it tells me "login > failed" > at one point i even get "the database has been marked suspect by recovery" > > I cannot ever use Operrations manager > > Help me PLEASE > -- > Terry > > > Posted by Terry on June 22, 2006, 6:15 pm Please log in for more thread options I ended up calling MS, we restored from the old backup, I understand that there is a way to do automatic back-ups. do you know the article number or that?? -- Terry "Jeff" wrote: > Terry, > > My suggestion is that you contact the SQL Server/MSDE newsgroups for a > possible fix. You should be able to use SO Admin queries or TSQL statements > to fix it. > > > For starters, try; > > microsoft.public.sqlserver.server > microsoft.public.sqlserver.msde > > -- > * > Get Secure! - www.microsoft.com/security > > You must be using Outlook Express or some other type of newsgroup reader to > see and download the file attachment. 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 > > ********** > > this is happening several month's after an upgrade from QS2000. the database > was picked up by RMS and was in use until 2 -3 days ago. Yes I am sure about > ht password > -- > Terry > > > "Jeff" wrote: > > > Terry, > > > > Are you sure you are using the correct SQL SA password? > > > > How did you copy/install/place the database onto the computer's hard > > drive? > > > > -- > > * > > Get Secure! - www.microsoft.com/security > > > > You must be using Outlook Express or some other type of newsgroup reader > > to > > see and download the file attachment. 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 > > > > ********** > > > > I am a computr Tech, I installed RMS for a friend and explained that they > > need to back it up every night, which i discovered has not been done. Now > > when I try to use store Ops, I get "login failed" If I go to Ops Admin, I > > can > > connect to the DB, but when I test the connection, it tells me "login > > failed" > > at one point i even get "the database has been marked suspect by recovery" > > > > I cannot ever use Operrations manager > > > > Help me PLEASE > > -- > > Terry > > > > > > > > > Similar Threads Posted Database problems May 2, 2009, 9:23 am Backup Database problems Help February 23, 2007, 4:02 am Worksheet 51 to copy from HQ database to each store database July 8, 2008, 12:07 pm Database offline error when database is local December 22, 2008, 1:42 pm problems in RMS March 3, 2006, 11:48 pm RMS 2.0 Problems February 27, 2007, 12:31 am SQL problems with 2.0 March 8, 2007, 7:37 pm some problems with RMS 2.0 August 19, 2007, 7:12 pm problems in HQ November 19, 2007, 9:01 am problems with V1.3 March 16, 2009, 2:30 pm