wsus database move from c to d drive.
Hi Guys,
Plase help me. I want to move my wsus database from c to d drive.
Hardware
Hi Guys,
Plase help me. I want to move my wsus database from c to d drive.
by ibm.saurabh Accepted solution
by llopez Accepted solution
Moving the WSUS database to a new location
Step 1: Stop any service that is accessing the database
Since this is a WSUS database, we need to stop several services like the Update Service, Automatic Updates and the WWW service. You can do so using the Services applet or by using the NET STOP command.
Step 2: Detach the database using the sp_detach_db command
The sp_detach_db command detaches the specified database from SQL Server/MSDE. If you didn't stop any service or application accessing this database, this command will fail. Below is the syntax for the sp_detach_db command.
To use the sp_detach_db in osql for the SUSDB database, execute this in the command line
osql -E -S %computername%\wsus -Q "exec sp_detach_db 'SUSDB'"
Step 3: Move the database files to a new location
Now that you have disconnected the database from the server, you can now treat it as any other file in your file system. Move the SUSDB.mdf and SUSDB_Log.LDF files (for any database, be sure you know which files correspond to which database by executing the sp_helpdb command)
Step 4: Re-attach the database using the sp_attach_db command
Execute the sp_attach_db in osql to re-attach the database files you have moved to a new location.
osql -E -S %computername%\wsus -Q "exec sp_attach_db @dbname=N'SUSDB', @filename1=N'E:\WSUS\MSSQL$SUS\Data\SUSDB.mdf', @filename2=N'E:\WSUS\MSSQL$SUS\Data\SUSDB_log.ldf'"
Step 5: Start the services which you stopped in Step 1
Resume the services or applications you stopped. Check whether the application still works fine and that it can still access the database.
This discussion is closed to new replies.
Sort by Trending