July 5, 2016 at 4:31 am
Hi,
My database is "AdventureWorks2012" sample database.
1. I have taken backup from default instance 11.0.6020 and again taken backup from named instance 11.0.2100 (Here both instance having same database).
2. Delete database from 11.0.2100 and restore database using 11.0.6020 .bak file through query by using "with move option". It has successfully restored.
3. Delete database from 11.0.6020 and restore database using 11.0.2100 .bak file through query by using "with move option". It has successfully restored.
How it is working... how support this concept SQL...? Pls can any one explain.....
Pls provide your valuable suggestions......Thanks in advance....
July 5, 2016 at 4:33 am
you are restoring the same version, 11 = 2012, is that not what you expect?
July 5, 2016 at 4:40 am
Thanks for respond.....
But here build version is different one is "RTM" and another one is "SP3". In this case also SQL treat same versions…? Is it sure..?
Pls provide your valuable suggestions....thanks in advance...
July 5, 2016 at 4:42 am
You can't restore a database to a server with a lower version number. That doesn't also apply to the build number, though.
John
July 5, 2016 at 4:53 am
Thanks John, i doubt has cleared....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply