December 6, 2012 at 12:28 pm
Hi,
I am trying to backup a db from SQL 2005 and trying to restore in SQL server 2008 with standby/readonly mode.
However, I am getting some error saying "This database cannot be restored using standby because database upgrade is needed. Reissue the restore without standby."
Anyone had similar experience, if so, what is the solution.
Thanks,
SueTons.
Regards,
SQLisAwe5oMe.
December 6, 2012 at 2:55 pm
Don't use that option. Restore with recovery so that SQL 2008 can run the various stored procedures that upgrade the database structure to the new format.
Then change the database to offline or something if you need to restrict access for some reason.
December 6, 2012 at 3:08 pm
jerry-621596 (12/6/2012)
Don't use that option. Restore with recovery so that SQL 2008 can run the various stored procedures that upgrade the database structure to the new format.Then change the database to offline or something if you need to restrict access for some reason.
But if my requirement is to leave the database with standby/read-only mode. Then how to do so?
Can I restore with recovery then do another backup of the database itself then restore again using the current backup with standby/read-only mode. That should work right?
Thanks,
SueTons.
Regards,
SQLisAwe5oMe.
December 6, 2012 at 5:01 pm
SQLCrazyCertified (12/6/2012)
jerry-621596 (12/6/2012)
Don't use that option. Restore with recovery so that SQL 2008 can run the various stored procedures that upgrade the database structure to the new format.Then change the database to offline or something if you need to restrict access for some reason.
But if my requirement is to leave the database with standby/read-only mode. Then how to do so?
Can I restore with recovery then do another backup of the database itself then restore again using the current backup with standby/read-only mode. That should work right?
Thanks,
SueTons.
I'm no pro but I agree with jerry. Restore the 2005 with recovery on the 2008 system, then alter the 2008 database to offline or read only.
http://msdn.microsoft.com/en-us/library/aa275464(v=SQL.80).aspx
If I am reading your question correctly, it sounds like you might want two versions of the database, one usable and one read only. If you do need to have two versions of the same database in 2008, one usable and one in read only then yes, you can restore to 2008 with recovery first. Giving the usable database, then backup the 2008 and restore again leaving it in standby. (the database name will need to be different, since you cant have two with the same name)
If what you are after is one database on 2008, I would do as jerry said...
December 6, 2012 at 6:39 pm
SQLCrazyCertified (12/6/2012)
jerry-621596 (12/6/2012)
Don't use that option. Restore with recovery so that SQL 2008 can run the various stored procedures that upgrade the database structure to the new format.Then change the database to offline or something if you need to restrict access for some reason.
But if my requirement is to leave the database with standby/read-only mode. Then how to do so?
Can I restore with recovery then do another backup of the database itself then restore again using the current backup with standby/read-only mode. That should work right?
Thanks,
SueTons.
Is your requirement to restore to standby/read-only so you can establish logshipping?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 6, 2012 at 11:02 pm
You can always place the database in Read-only mode after the restore/upgrade. Unless I am mistaken, that is all that option does anyway.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply