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 |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
 Posted - 2009-04-21 : 16:44:53
|
| We recently upgraded the mirror server to SQL 2008 but left the principal server at 2005. Now when I attempt to create a snapshot database of a mirrored database on the mirror server, I get a message that the database needs to be upgraded:"Msg 946, Level 14, State 1, Line 2Cannot open database 'MyDB_Snapshot' version 611. Upgrade the database to the latest version.Msg 1823, Level 16, State 2, Line 2A database snapshot cannot be created because it failed to start."Previous to the upgrade, this was our standard means of operating.Can anyone shed some light on resolving this? Do I need to upgrade the principal server, also?=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-04-21 : 17:31:24
|
| yeah the 2008 snapshots can't be restored to 2005 server. same with the backups.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-04-21 : 19:03:57
|
| Thanks for the reply.I'm not trying to restore from 2008 to 2005 (I'm not sure if I made that clear). I am mirroring from 2005 to 2008 and trying to take a snapshot from 2008 to 2008.Should this, in theory at least, be possible?=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
|
|
|
|
|
|
Create Snapshot failure after mirroring