Linked server

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  December 23, 2010 at 4:11 am

  #244660

  Hi friend's

  I am going to upgrde SQL 2000 to SQL 2008 with SP2. Method of IN-PLACE upgrade.

  In this case what will be happend linked server configuration in already exists in SQL 200 box?

  Please tell me suggestion, after upgraded to sql server 2008 linked server should be there or need to be configure again?

  Thanks for your help.

  ananda

• abhishek.8604

  SSC Enthusiast

  Points: 106

  More actions

  December 23, 2010 at 4:53 am

  #1265862

  Need to be configured again

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  December 23, 2010 at 9:49 am

  #1266003

  Thanks for reply..

  Please tell me one more suggestion as following task can be configure after upgraded to SQL 2008 method of IN-Place.

  1. Replication

  2. Mirroring

  3. Logshipping

  ---------------------------

  email Alert

  Demo Alerts for SQL Server 2008.

  Type - SQL Server Event alert.

  Demo.sev.19 Errors

  Serverity - 019 Fatal error in resources

  Demo.sev.20 Errors

  Serverity - 020 Fatal error in current process

  Demo.sev.21 Errors

  Serverity - 021 Fatal error in database process

  Demo.sev.22 Errors

  Serverity - 022 Fatal error in Table Integrity suspect

  Demo.sev.23 Errors

  Serverity - 023 Fatal error in database integrity suspect

  Demo.sev.24 Errors

  Serverity - 024 Fatal error in hardware error

  for the pro-active monitoring, I have enable those alerts and mention to notify operator receving email alert. Is it corret way?

  thanks for your help

  ananda

• abhishek.8604

  SSC Enthusiast

  Points: 106

  More actions

  December 24, 2010 at 2:30 am

  #1266159

  Ya thats the way it should be