May 26, 2015 at 7:34 am
Hello
Our production server and test server are currently on 2005. We have log shipping in place from production to test server. We are planning to upgrade to 2008 R2. I have to do this on the test server first. Can anyone please guide me on the steps to take since log shipping is set up.I am doing an in place upgrade. Should I disable the log shipping jobs and make the secondary log shipped databases which are currently in read only mode, read and write mode before doing the upgrade. Any pointers will greatly help.
After the upgrade can I continue to log ship from 2005 production to 2008 R2 test server? Any issues here that I should be aware of.
Thanks.
May 27, 2015 at 5:29 am
vsuresh (5/26/2015)
HelloOur production server and test server are currently on 2005. We have log shipping in place from production to test server. We are planning to upgrade to 2008 R2. I have to do this on the test server first. Can anyone please guide me on the steps to take since log shipping is set up.I am doing an in place upgrade. Should I disable the log shipping jobs and make the secondary log shipped databases which are currently in read only mode, read and write mode before doing the upgrade. Any pointers will greatly help.
If the secondary database is in standby readonly mode you'll need to switch it to restoring mode.
Disable the copy and restore jobs on the secondary, upgrade the secondary instance as usual to 2008 R2.
vsuresh (5/26/2015)
After the upgrade can I continue to log ship from 2005 production to 2008 R2 test server? Any issues here that I should be aware of.Thanks.
You may re enable the copy and restore jobs on the secondary and continue to log ship from the 2005 instance to the 2008 R2 instance but the secondary database will not be readable.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 6:17 am
Thank you, these pointers help. After the upgrade can I switch the secondary database back to stand by read only mode? Thanks again.
May 27, 2015 at 6:20 am
vsuresh (5/27/2015)
After the upgrade can I switch the secondary database back to stand by read only mode?
Only if you upgrade the sql version on the primary too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 6:30 am
Thanks Perry. I ran the upgrade advisor and have these issues. Do you have any idea how to go about fixing this, I spent a whole lot of time researching on a resolution but had no luck.-
Method not found: 'System.Collections.Generic.IEnumerable`1<Microsoft.SqlServer.Management.SqlParser.Parser.Error> Microsoft.SqlServer.Management.SqlParser.SqlCodeDom.SqlCodeObject.get_Errors()'.
for a couple of different objects - OLDSYSTEMTABLES, SPHELPTRIGGERNEWCOL,OUTPUTINTOFULLTEXT, ORDERB ORDINALS, DROPSYSOBJ, NONANSIOUTER, MERGE,OUTPUTTARGETHASTRIGGER,SYSLOCKINFO,
...
Also got Full-Text Search has changed in SQL Server 2008
The advisor says these have to be fixed prior to upgrade.
May 27, 2015 at 6:54 am
can you provide the full report?
Was this database previously a sql server 2000 database at any time?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 6:59 am
Hi Perry, I have attached the report. No this has always been a 2005 server which is the default instance. I do have a named instance of 2008 R2 installed on this same server. Can I just run the upgrade and ignore the issues.
May 27, 2015 at 7:00 am
Perry, Some of the databases in this server are 2000 compatible.
May 27, 2015 at 8:10 am
have you ever run DBCC CHECKDB against these databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 8:12 am
No, but these are test databases that have been restored from copies of live against which DBCC Checkdb has been run. I will run it and see what happens. Thanks Perry.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply