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,
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?
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,
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
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??
We run a backup as a batchfile, which is run nightly as a scheduled task. Here is what we have in the batch file:
del d:\SObackup\backup1.bck copy d:\SObackup\backup.bck d:\SObackup\backup1.bck del d:\SObackup\backup.bck
osql -U sa -P password -S servername -Q "BACKUP DATABASE StoreOps TO DISK 'd:\SObackup\Backup.bck'"
Modify the file locati> I ended up calling MS, we restored from the old backup, I understand that
If you had not used SQL Server Management Studio as a tool to look into and fix this problem, you may want to if you have access to it. Its very nice for managing and administering multiple database(s) and database servers.
Jamieson Gill
I had a virus on my computer, so a tech re install window and Retail Management, now I cant connect to my dadabase.
I know that you have to first create a database with SQL, but I cant find the way to restore backup and even less create a new dababase from SQL.
Please, Please HELP. Going Crazy!
"Jeff" wrote:
Caze,
To create a database, go into SO Admin
File | Connect | put in your password when you installed RMS | OK | Database | Create | give it a name | Next | Next | click on the magnifying glass and point to your backup file | Next | Finish
File | Connect | put you password again | change the database name to what you just created
File | Configure | put in your password | check the database name, change it if necessary | Test
File | Exit
I'm an idiot. I admit it :)
For the sake of anyone else who may be somewhat challenged, I had connected to the correct database, but had not selected said database in the configuration in HQ Administrator. It was trying to connect to a Store Ops database.
When you run SQL queries, it uses the connected database, but Manager uses the database referenced in the configuration.
Sorry for the stupid question...
Jason
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.