In some cases you need to transfer WIP repository database to another server follow this procedure
Stop all WIP Services
Launch SQL Server Management Studio
Select the database and open “properties / files”, note the location of the Database files
mine are here C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA
Close properties and press “Tasks / Take Offline” (check drop all active connection)
Go to the file folder and copy the <database>.mdf and <database>_log.mdf
Paste them in the file folder of the destination SQL Server
Select the “Databases” node right click and select “Attach Databases”
et voilà…
Add Comment