Does anyone know why when I try to use DBAttach to detach my SIMS DB I get the message that "This Database is currently in use. You cannot detach this database until all users have logged out".
No users are logged in (currently all user accounts are disabled to allow me to work in peace). I have rebooted the server.
The Dialogue box has the title "FMS Database Installation". As far as I know we dont use FMS.
Anyone have any ideas? I need to detach this DB so I can rebuild the server to 2008 R2.
I have successfully used DBattach in the past.
Which version have you got?
DBattach version 184.108.40.206
Try upgrading. Mine is 220.127.116.11
Are you on Summer 2011?
no still on Spring. I was hoping to migrate to 2008 R2 from 2003 before implementing the Summer release.
Where can i get 18.104.22.168? I search on supportnet for dbattach but got nothing
22.214.171.124 would have come with the summer update. So probably not the problem.
Have you tried stopping and starting the SQL service?
Just tried that but no joy
Originally Posted by creese
Will raise a call with Supportnet.
Try running SQLApplication setup, from memory FMS has it's own dbattach, I think you may be using that one.
If you're OK with SQL queries, this will show the current logged-in users for your database.
declare @mySIMSdb as nvarchar(100)
set @mySIMSdb = '<your SIMS database name>'
-- drop table #sp_who2
create table #sp_who2
insert into #sp_who2
select loginname, hostname, dbname from #sp_who2
where dbname = @mySIMSdb
drop table #sp_who2
How are the accounts disabled? What if there is a rogue machine out there with SIMS open..?<br>Try going on the local console and then disabling tcp/ip access.<br>Also try a script in sql management studio to see who is logged in...<br><br>
Gah! he beat me to it. Maybe you can check my code is good @jinnantonnixx - though i probably got it from you anyway :p
select distinct sysprocesses.loginame,
/* sysprocesses.spid, */
/* sysprocesses.nt_username, */
/* sysprocesses.login_time, */
join sysdatabases on sysprocesses.dbid = sysdatabases.dbid
where sysdatabases.name = 'sims' OR sysdatabases.name = 'fms'
order by sysdatabases.name, sysprocesses.loginame
I think the clue is in the FSM error. We don't support FSM so can't really check.
Are you using the shortcut on the start menu?
The other option is to run the detach manually from SQL manager.
Be sure to copy the db users to the transfer table first. PM is you want the SQL code.
Does anyone know if SIMS are now flagging users as 'logged in' in the database?
If this is new, it could explain the problem.
Originally Posted by Banjo
I have 126.96.36.199 too from Spring.
The sims one and the fms one are the same though. Not sure it would make a difference. There was an explanation somewhere previously from Phil Neal about why there were two, but i didn't really get it. It came from a developer!
It's a pain that they both have the same name.
The SIMS one lives in the db binn folder :
FMS as above but in the FMSSQL subfolder. Mine actually for FMS is 188.8.131.52 - So you can't be using that, plus you don't have FMS..
Program Files\Microsoft SQL Server\MSSQL10_50.SIMS2008\MSSQL\Binn
I usually track them down and change the shortcut names so i can ID them. Also you can add parameters to save you typing in server / db name every time. Helps if you use it alot, mostly on test server.
I know from bitter experience, that if a workstation has SIMS open it will be making a connection even if no-one is there, because of the stupid homepage graphs!
Not sure about the 'logged in' flag, but that script i use does show both the user and the workstation, so a remote shutdown command does the trick. Or kill tcp/ip connections which is more reliable.