MIS Systems Thread, Urgent Help needed.. Can't logon to sims.net in Technical; Hi,
We have been experiencing sims problems and advised to run the indexing patch....Ran the patch, never finished and received ...
13th September 2012, 03:15 PM #1
- Rep Power
Urgent Help needed.. Can't logon to sims.net
We have been experiencing sims problems and advised to run the indexing patch....Ran the patch, never finished and received an error ( I don't know what the error was as I was never there to see it)
We can no-longer login to sims with an error stating :-
"unable to set application role"
Any Ideas ???
Thanks in advance
13th September 2012, 03:18 PM #2
Database is still locked, if you've got management studio I think it'll say it's set as restricted_user. Change it multi_user should do it
alter database sims set multi_user with rollback immediate
Failing that, restore it from the backup it created. Actually that might be safer
13th September 2012, 03:19 PM #3
- Rep Power
How do I do a restore from the backup it created??
13th September 2012, 03:49 PM #4
Backup will be located in the backups directory within the default SQL Server application location on the server (usually D:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Backup), you will need to run dbattach.exe from on the server to restore.
13th September 2012, 04:29 PM #5
Yer, what Paul said. Run dbattach and restore from the latest backup in your mssql10.sims2008\backup folder.
By link470 in forum Windows
Last Post: 15th March 2012, 03:02 AM
By artfulmatt in forum MIS Systems
Last Post: 2nd December 2010, 11:02 PM
By The_GuRu in forum Network and Classroom Management
Last Post: 20th February 2008, 09:20 AM
Last Post: 18th January 2008, 01:46 PM
By ICTNUT in forum Windows
Last Post: 6th September 2007, 07:10 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)