I have 2 databases (SERVICES and SERVICESTEST)
I need to restore the contents of SERVICESTEST into SERVICES.
I have made a backup of SERVICESTEST.BAK and I am trying to restore it over (with Overwrite box checked) and getting an error so I figure that I am doingit wrong.
Before the restore, I changed the SERVICESTEST.BAK to SERVICES.BAK.
System.Data.SqlClient.SqlError: The file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\SERVICESTEST.mdf' cannot be overwritten. It is being used by database 'SERVICESTEST'. (Microsoft.SqlServer.Smo)
I am sure that there is a better way to resolve this.
This is version SQLServer 2008