troubleshooting Question

Change WSUS database datafiles path

Avatar of pereira_allwyn
pereira_allwyn asked on
Operating Systems
9 Comments1 Solution3464 ViewsLast Modified:
hi,
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.

ASKER CERTIFIED SOLUTION
rizla7

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros