SQL script upgrade to version 8 from 6.1

Question

Hi everyone, 
 I am trying to upgrade Safeguard SQL script from 6.1 to 8. 
 I am having below issue, 
 Msg 924, Level 14, State 1, Line 15 
 Database 'Safeguard' is already open and can only have one user at a time. 
 Please guide me how to overcome it. 
 Best Regards, 
 Zaw

tralveller · Answer

Hello,

I performed following steps from SGN 6.0 to 7.0:

1. Stop all SGN Services on SafeGuard Server(s) (SGN sync Service, etc..)

2. Stop IIS on SafeGuard Server(s)

3. Add to SQL update script follwing line at the beginning of it (First line):

ALTER DATABASE [<ENTER SAFEGUARD DB NAME>] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; -- attension, all active transactions/connections will be killed, exclusive access to SQL with this
GO

4.

Add to SQL update script follwing line at the beginning of it (last line):

ALTER DATABASE [<ENTER SAFEGUARD DB NAME>] SET MULTI_USER; -- With this access to BD is possible again with multiple connections.
GO

5. Open Microsoft SQL Server Management Studio

6. open modified SQL Update script and execute it

Don't forget to perform backup steps, recommended update steps by Sophos and so on.

Try it and let us know if this was helpful.

Kind regards

Tralveller