on 12-08-2010 3:42 PM
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your support!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.