hi,

  resourcedb in sql 2005 is a read-only DB.if u type sp_helpdb or select * from sys.databases or in the Management studio it will not be visible .......

hi all,

We have installed 3 instances of SQL server as instance 1 ,instance 2 and instance 3.All 3 instances in mystandalone PC for testing.

1.) Yes we successfully configured Mirroring b/w instance 1...

Hi Ram,

          What u did is rite.We normally change the Compatability level to 90 after restoring sql 2000 db to sql 2005.But theres a few issues u can refer the below...

may be u can script the tables and run in sql 2005.But if u have many tables its not advisable.Ur question seems to be unique.Generally it will not happen..Pls do...

Hi John,

         I'm having the following,SQL 2005 Evaluation edition and Windows XP professional SP2.I tried the following as u mentioned,

1.Stopped sql agent and found that Agent Xps were in disabled...

hi,

  If u restore a sql 2000 DB in Sql 2005 u need to change the compatability to 90 from 80.Else many of the T-Sql features available in 2k5 will not...

Hi,

 In my opinion there is an option called Reinitialize subscription.Instead of dropping and recreating Subscription,u can reinitialize it from the snapshot the next time the Distribution Agent runs

Cheers

Deepak

Hi George,

            Yes you are right.In SQL 2005 Standard edition it does not support Asynchronous mode i.e  a high performance mode.Also Failover is automatic only in High Availability mode since...

Hi friends,

 if u r performing inplace upgrade pls refer the link http://www.sqlservercentral.com/columnists/ssamuel/2987.asp.mite be useful.

start running the upgrade advisor and identify the problems.

Rgds

Deepak

hi dude,

         As far as logshipping is concerned,the failover is manual and the steps to be followed if primary server is down are,

1.try 2 backup the syslogins table of the...