Need help in changing the path of the data files and Transaction logs of the database used for WSUS server. The orginal location of the datafiles is on a volume that is almost full, hence I'm trying to move the data files and transaction logs to another volume.
When I try to take the database offline, I get an error stating that Error 5070: Database state cannot be changed while other users are using the database 'DB NAME' ALTER DATABASE statement failed.
sp_dboption command failed.
I have also tried stopping the Update services and then trying to take the databse offline.