December 3, 2012 at 11:44 pm
i need to upgrade SQL 2005 to sql 2008 r2 where the db's are configured transactional replication .
can any one send the step by step approach who to upgrade and the precautions while upgrading the server ?
December 4, 2012 at 12:05 am
ramyours2003 (12/3/2012)
i need to upgrade SQL 2005 to sql 2008 r2 where the db's are configured transactional replication .can any one send the step by step approach who to upgrade and the precautions while upgrading the server ?
Run the upgrade advisor ,check if any errors or warnings it showing ,Fix them and then start upgrading
-----------------------------------------------------------------------------
संकेत कोकणे
December 4, 2012 at 1:35 am
While upgrading replicated instances, order matters.
Upgrade should be done in the following order:
1) Distributor
2) Subscriber
3) Publisher
December 4, 2012 at 2:48 am
ramyours2003 (12/3/2012)
i need to upgrade SQL 2005 to sql 2008 r2 where the db's are configured transactional replication .can any one send the step by step approach who to upgrade and the precautions while upgrading the server ?
Hello,
Please refer to the below links..
http://www.techrepublic.com/blog/10things/10-tips-for-upgrading-to-sql-server-2008-r2/2376
http://msdn.microsoft.com/en-us/library/ms143699(v=sql.105).aspx
Regards..
December 4, 2012 at 2:48 am
ramyours2003 (12/3/2012)
i need to upgrade SQL 2005 to sql 2008 r2 where the db's are configured transactional replication .can any one send the step by step approach who to upgrade and the precautions while upgrading the server ?
Hello,
Please refer to the below links..
http://www.techrepublic.com/blog/10things/10-tips-for-upgrading-to-sql-server-2008-r2/2376
http://msdn.microsoft.com/en-us/library/ms143699(v=sql.105).aspx
Regards..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply