sql upgrade

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » sql upgrade

sql upgrade

Rate Topic

Display Mode

Topic Options

Author

Message

ramyours2003

Posted Monday, December 03, 2012 11:44 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 358, Visits: 1,482

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 ?

Post #1392259

sanket kokane

Posted Tuesday, December 04, 2012 12:05 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:49 PM
Points: 323, Visits: 960

ramyours2003 (12/3/2012)

Run the upgrade advisor ,check if any errors or warnings it showing ,Fix them and then start upgrading

-----------------------------------------------------------------------------
संकेत कोकणे

Post #1392262

Suresh B.

Posted Tuesday, December 04, 2012 1:35 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:59 AM
Points: 1,075, Visits: 5,114

While upgrading replicated instances, order matters.

Upgrade should be done in the following order:
1) Distributor
2) Subscriber
3) Publisher

Post #1392284

arunyadav007

Posted Tuesday, December 04, 2012 2:48 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 03, 2013 3:06 AM
Points: 42, Visits: 285

ramyours2003 (12/3/2012)

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..

Post #1392308

arunyadav007

Posted Tuesday, December 04, 2012 2:48 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 03, 2013 3:06 AM
Points: 42, Visits: 285

ramyours2003 (12/3/2012)

Post #1392309

« Prev Topic | Next Topic »

Permissions