Which version have you got?
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 22.214.171.124
Try upgrading. Mine is 126.96.36.199
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 188.8.131.52? I search on supportnet for dbattach but got nothing
184.108.40.206 would have come with the summer update. So probably not the problem.
Have you tried stopping and starting the SQL service?
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.
Code:declare @mySIMSdb as nvarchar(100) set @mySIMSdb = '<your SIMS database name>' -- drop table #sp_who2 create table #sp_who2 ( spid int, status varchar(100), loginname varchar(2000), hostname varchar(2000), blkby varchar(100), dbname varchar(200), cmd varchar(max), cputime int, diskio int, lastbatch varchar(100), pgmname varchar(500), parentspid int, request_id int ) insert into #sp_who2 EXEC 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 anywayCode:use master; select distinct sysprocesses.loginame, /* sysprocesses.spid, */ sysprocesses.hostname, sysdatabases.name, /* sysprocesses.nt_username, */ /* sysprocesses.login_time, */ sysprocesses.status, sysprocesses.memusage, sysprocesses.dbid from sysprocesses join sysdatabases on sysprocesses.dbid = sysdatabases.dbid where sysdatabases.name = 'sims' OR sysdatabases.name = 'fms' order by sysdatabases.name, sysprocesses.loginame
Last edited by vikpaw; 26th July 2011 at 01:18 PM. Reason: add
fiza (27th July 2011)
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.
I have 220.127.116.11 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 18.104.22.168 - So you can't be using that, plus you don't have FMS..Code: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.
There are currently 1 users browsing this thread. (0 members and 1 guests)