Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sergmis
Starting Member
3 Posts |
 Posted - 2009-05-31 : 21:36:11
|
| Hello All,got a headscratcher of a problem,I successfully setup mirroring of the adventureworks 2005 DB between my SQL 2005 production server (principal) and a SQL 2008 production2 server (mirror). Figured I was ready for mirroring production databases on my prod server. Wrong!!Restored copy of production DB and transaction log to prod2 (left it in recovering state)Started Mirror wizard on principal (prod server) click on Configure Security... and tried to connect to my mirror server instance (prod2). I get the following error(Failed to connect to server XXXXX-->This SQL Server version 10.0 is not supported...)Now I know this basically means SQL 2005 can't recognize/connect to the SQL 2008 server, But why did it work for me when I first tested it using AdventureWorks?I previuosly had verified others where able to setup mirroring between SQL 2005 and SQL 2008Upgrading to 2008 on production server would be an added pain, plus added expense |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-02 : 10:53:36
|
| Right off the bat, this will not work because of the possibilities around failovers. You might be able to fail over from SQL 2005 to SQL 2008, but can you go back?Each version of SQL Server changes the file structures just a little bit. This is why you see a bunch of extra messages when you restore a database from an earlier version onto a newer version. And this is why you can't mirror across versions. |
 |
|
|
sergmis
Starting Member
3 Posts |
Posted - 2009-06-05 : 11:19:57
|
| Uninstalling SQL 2008 and going to reinstall 2005 :(Thanks |
|
|
|
|
|
|
Mirroring SQL 2005 to SQl 2008