SQL2008 Express: For some of my DB's, I can access the Copy Database wizard via right-click Tasks. But for the DB I actually need to copy, the "Copy DB" task is missing from the tasks menu. I can't figure out why. :mad:
Printable View
SQL2008 Express: For some of my DB's, I can access the Copy Database wizard via right-click Tasks. But for the DB I actually need to copy, the "Copy DB" task is missing from the tasks menu. I can't figure out why. :mad:
What's compatibily level of the db?
How do I check compatibility level?
Right click on the db in ssms and open properties, go to options tab. You are better to work with your dba.