locked
Can't create a snapshot on a Mirror DB in sql server 2008 RRS feed

  • Question

  • I tried to create a snapshot on Mirror DB in sql server 2008 but I couldn't. And error said :

     

    Msg 946, Level 14, State 1, Line 1

    Cannot open database 'XXXXXX_MSCRM_SS' version 611. Upgrade the database to the latest version.

    Msg 1823, Level 16, State 2, Line 1

    A database snapshot cannot be created because it failed to start.

     

    Principal : 2005 Enterprise Edition  32bit (Service pack 2: 9.0.3042)

    Mirror : 2008 Developer Edition 64bit (10.0.1600).

    Database is a MSCRM database.

     

    Mirroring is synchronized on both servers if I check with sys.database_mirroring. Altough Management Studio 2008 on Mirror Server shows only RESTORING without (Mirror, Synchronized).

    I can retore a test database from Principal on Mirror server and create a snpahot on the restored db with exactly same SQL Statement, except db name and file name. (The db is not in mirroing. Just regular db backup and restore with recovery).

     

    I couldn't find any relevant information in the internet. I really appreciate your advice in advance.

     

    Thank you,

     

    Yun

     

     

     

    Sunday, September 28, 2008 6:29 PM

Answers

  • A database with compatibility level 90 is still an 2008 database in format. A true 2005 format database (as your mirror is) cannot be opened by 2008, and since it cannot be opened no snapshot can be taken.

    BTW, I hope you do realize that if by any accident you failover the partner right now, your production db will be upgraded to 2008 and will be impossible to put it back online on the 2005 instance.

    Sunday, September 28, 2008 8:12 PM

All replies

  • Upgrade the 2005 instance to 2008 and it will work. See http://msdn.microsoft.com/en-us/library/bb677181.aspx for upgrade steps advice. As it is right now the database is version 611 (ie. 2005 SP2) so it cannot be opened by 2008.
    Sunday, September 28, 2008 7:20 PM
  • Yes, upgrade should work.

     

    My question is whether it is possible to create a snpashot on the mirror DB from sql server 2005 or not.

    If it is not possible, I should find other solution.  Upgrading the production principal server is not in my option list at this moment.

     

    For a DB with compatibility level of 90, we can create a snapshot without an error in Sql server 2008.

    Only for a mirror db, whose principal is sql server 2005, we can't create a snapshot in sql serverff 2008.

     

    Logically, if the principal db is sql server 2005 and later, snapshot db creation should be possible as we can set up mirroring between sql server 2005 and sql server 2008.

     

    So I am asking :

    1) Is it a bug or by design?

    2) Is there any work around?

     

    Regards,
    Sunday, September 28, 2008 7:55 PM
  • A database with compatibility level 90 is still an 2008 database in format. A true 2005 format database (as your mirror is) cannot be opened by 2008, and since it cannot be opened no snapshot can be taken.

    BTW, I hope you do realize that if by any accident you failover the partner right now, your production db will be upgraded to 2008 and will be impossible to put it back online on the 2005 instance.

    Sunday, September 28, 2008 8:12 PM
  • Thank you for your quick responses and answer.

    Best Regards,

    Yun

    Sunday, September 28, 2008 9:01 PM