May 12, 2015 at 5:09 pm
All below using ssms 2014:
When I run the "Copy Database Task" on server 1 to server 1 it runs fine. (same result on 2008r2 and 2014 servers)
When I run the "Copy Database Task" on server 2 to server 2 it runs fine. (same result on 2008r2 and 2014 servers)
When I run the "Copy Database Task" on server 1 to server 2 and the versions are the same it runs fine.
When I run the "Copy Database Task" on server 1 to server 2 and the server 2 version is newer or equal to the server 1 version it runs fine.
It only fails when I run it from 2008r2 to 2014.
Any ideas?
May 13, 2015 at 12:41 am
When I run the "Copy Database Task" on server 1 to server 2 and the server 2 version is newer or equal to the server 1 version it runs fine.
It only fails when I run it from 2008r2 to 2014.
is it correctly phrase ?
sql Server is backwardly compatible for up to 3 version like for 2014 it will be compatible to 120,110,100 and if u r copying the database having the level 90 (SQL 2005) or 80 (sql 2000) it wont work
server may be of 2008 R2 but database compatibility level may be lower than 100. so please change the level and than try
WINNERS NEVER QUIT AND QUITTERS NEVER WIN
May 13, 2015 at 12:41 am
So you're connecting from the older version of SSMS to the newer SQL Server instance? Yeah, that's going to fail because the software isn't forward compatible. Structures and internals change between versions and they can't be known by the older version of the software.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply