February 8, 2018 at 7:55 am
How can I restore the DB which is on SQL Server 2014 to the server which is running on 2008 version of SQL Server? Or is it even possible (I am sure it is but how)
February 8, 2018 at 7:59 am
No, you can't do that. Your best bet would be to make a copy of it and use that to script out all the objects and copy the data.
John
February 8, 2018 at 9:32 am
Piling on.
Backwards restores are not possible. When you create/restore a database on a newer version of SQL Server, it uses all the new functions storage mechanisms, etc., that define the new version of SQL Server. The older versions can't read that stuff.
Solution is as John has already outlined.
"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
February 8, 2018 at 9:48 am
That's what I am working on right now (copying the data)
Thanks!
February 8, 2018 at 8:19 pm
ditto. you would think its something that should be simple but MS decides to make it harder. 🙂 same goes for edition downgrade. edition upgrade is a few clicks. edition downgrade is short of reinstalling the instance and putting back master, model, msdb. good luck 🙂
February 8, 2018 at 10:42 pm
Ivan R. - Thursday, February 8, 2018 8:19 PMditto. you would think its something that should be simple but MS decides to make it harder. 🙂 same goes for edition downgrade. edition upgrade is a few clicks. edition downgrade is short of reinstalling the instance and putting back master, model, msdb. good luck 🙂
Edition downgrade is sort of evil. But, forth compatibility is much, much, much more difficult.
GASQL.com - Focus on Database and Cloud
February 9, 2018 at 8:10 am
Ivan R. - Thursday, February 8, 2018 8:19 PMditto. you would think its something that should be simple but MS decides to make it harder. 🙂 same goes for edition downgrade. edition upgrade is a few clicks. edition downgrade is short of reinstalling the instance and putting back master, model, msdb. good luck 🙂
Are there software installs, especially something as absolutely huge as SQL Server, that easily let you downgrade? I don't mean Excel, I mean, Oracle or similar? I'm not aware of any. It's not usually an encouraged path for technical reasons, let alone monetary ones.
"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
February 9, 2018 at 8:31 am
Grant Fritchey - Friday, February 9, 2018 8:10 AMIvan R. - Thursday, February 8, 2018 8:19 PMditto. you would think its something that should be simple but MS decides to make it harder. 🙂 same goes for edition downgrade. edition upgrade is a few clicks. edition downgrade is short of reinstalling the instance and putting back master, model, msdb. good luck 🙂Are there software installs, especially something as absolutely huge as SQL Server, that easily let you downgrade? I don't mean Excel, I mean, Oracle or similar? I'm not aware of any. It's not usually an encouraged path for technical reasons, let alone monetary ones.
I think Ivan is talking about edition downgrade, not version downgrade:-) I think it's more about business (money), rather than technology. The tricky is MS named it edition change from Developer to Standard upgrade, rather than downgrade. Actually, what's upgraded? My understanding is, the upgrade is, you pay or pay more:-)
GASQL.com - Focus on Database and Cloud
February 23, 2018 at 12:10 am
Grant Fritchey - Friday, February 9, 2018 8:10 AMIvan R. - Thursday, February 8, 2018 8:19 PMditto. you would think its something that should be simple but MS decides to make it harder. 🙂 same goes for edition downgrade. edition upgrade is a few clicks. edition downgrade is short of reinstalling the instance and putting back master, model, msdb. good luck 🙂Are there software installs, especially something as absolutely huge as SQL Server, that easily let you downgrade? I don't mean Excel, I mean, Oracle or similar? I'm not aware of any. It's not usually an encouraged path for technical reasons, let alone monetary ones.
omgomgomg Grant F. replied to me. you won't realize how much you are a part of my career mate when it began 8 years ago. 🙂
anyway, agree there isn't much any other software. Just musings of mine.
February 25, 2018 at 1:39 am
Ivan R. - Friday, February 23, 2018 12:10 AMomgomgomg Grant F. replied to me. you won't realize how much you are a part of my career mate when it began 8 years ago. 🙂anyway, agree there isn't much any other software. Just musings of mine.
Ha! Well now it's happened twice.
Thanks for the kind words.
"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 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply