September 30, 2016 at 8:21 am
Hi All,
I've detached a db from 2K12 and attempted to attach it to a 2K8 R2 server, I get an error that I assumed I needed to change service credentials in server and agent services to my domain credentials. I did this. The 2K12 SQL no longer recognized the 2K8 server. At this I'm considering upgrading the 2K8 to 2K12 as a remedy but as a last resort. There is another post that recommended the aforementioned steps...they didn't help me. Importing the data is virtually starting over. Anyone out there with suggestions...any help is welcome!
Thanks!
September 30, 2016 at 8:24 am
Once a database has been moved to a newer version of SQL Server you cannot re-attach or restore it to a previous version of SQL Server. If you need the database to be available on an earlier version of SQL Server the only way to do it is to re-create the database schema on a lower version and bulk-copy the data in from the higher version. You may be able to do replication to sync the data, but I don't know that for sure.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 30, 2016 at 8:26 am
You also won't be able to do a backup and restore going down in versions.
"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
September 30, 2016 at 8:31 am
You can script the DB, export the data and recreate the DB on SQL 2008, or you can upgrade the 2008 server to 2012, but that's about your only options.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2016 at 8:42 am
I thought bumping up to 2K12 would be the best option. Thanks for the replies.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply