Link to home
Start Free TrialLog in
Avatar of Zoldy2000
Zoldy2000Flag for Canada

asked on

SQL Server Copy Database Wizard Error

Trying to use this method to move database from SQL 2008 to SQL 2016.    

https://www.experts-exchange.com/articles/22159/SQL-Server-database-migration-The-Copy-Database-Wizard-method.html

The job fails and tells me to check the log file for details ... however no log file was created in the specified location.
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

You can simply create a backup of SQL 2008 database and restore it on SQL 2016. No Wizards are necessary.
Avatar of Zoldy2000

ASKER

I chose this method because it also supports copy jobs ... users ... etc...
if there is another way to copy my maintenance jobs over so I don't need to rebuild them then I could use your method
First of all you should do these tasks manually which will teach you what everything is necessary to finalize the database port. Wizards does not allow to "look inside" and you then have no clue what everything can fail.

You can create a script for all your SQL jobs and execute it on the target machine. Of course, this requires users and logins defined on the target machine.
I understand what you are saying but at the same time for someone like me who manages one SQL server ... has maintenance plans and backups that were setup years ago and work as desired.    Copy is a much better option for me while Migrating to a new server.
I wrote that article and happy that you're following it.
Since you're migrating from an old database version to a more recent one, you'll need to run the Wizard from the last version of SSMS, that perhaps you've installed in the target server. Are you doing that?
Btw, the logs can be checked through the SQL Server logs or through the Windows Event Viewer.
Yes I am running the wizard from the new server.
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
great thanks for the info .....    If i see those techniques to get the users and jobs then I could also just restore databases from backup.    this worked in my tests
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good