yostnet
asked on
SQL DB Restore
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.SqlE rror: The file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER \MSSQL\DAT A\SERVICES TEST.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
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.SqlE
I am sure that there is a better way to resolve this.
This is version SQLServer 2008
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER