cancel
Showing results for 
Search instead for 
Did you mean: 

Restore database in SQL 2005

Former Member
0 Kudos

Hello All,

still today it works fine to Copy or Restore a databe.

beginning today i got a problem.

if i try to copy a database to another one with the Copy Wizard from SQL

i got an error: Library not registered.(Copy Database Wizard)

or

If i create a new database and want to restore from another database ore Backup file i got an error:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'TestPigmenti_08122010' database. (Microsoft.SqlServer.Smo)

so i have actually no clou how can i copy live database to a test database??

Thank you and best regards

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

> so i have actually no clou how can i copy live database to a test database??

You can't copy a "running" database using explorer and copying the files over. The proper way of copying a system can be found in the system copy guides in addition to

Note 151603 - Copying an SQL Server database

Markus

Answers (2)

Answers (2)

Former Member
0 Kudos

Thank you for your support!!

William_Laverde
Product and Topic Expert
Product and Topic Expert
0 Kudos

IWould it make sense to use a backup of the database and restore it on the new system? If that is not an option then the note 151603 as suggested earlier would be the best option.

Edited by: William Laverde on Dec 9, 2010 6:29 AM