George is right. Follow his steps.

--

SQLBuddy

In SQL 2005, SP is cluster-aware. Just run it on the active node and it patches all passive nodes of that instance.

--

SQLBuddy

It's a matter of how people look at it. Some treat LS as a DR solution.

All Clustering,Mirroring,LS can be used as HA and DR solutions. As Log shipping involves moving...

Pause the Copy Job. Free up the space and then Manually run the Copy and Restore Jobs.

--

SQLBuddy.

Yeah, they are correct. In Mirroring,there's a difference in how the transactions are committed in Synchronous and Asynchronous mirroring modes. Just check that.

--

SQLBuddy

When you say domain migration, what are you referring to .. Also check if SQL Server has been disconnected with the domain ..

--

SQLBuddy

LS report usually gives correct state of the log shipping. How did you confirm that LS is in synch and is working fine ..

In on the same server if you...

Does it happen even after connecting to the SQL Server in the object explorer ?

--

SQL Buddy

Me too had to work with vendor apps that required SA privileges for them to function. Some need SA level of access only during initial setup to create vendor databases...

Yes, you need to make the service start up to be manual. In case of manual restart, just take the resource offline and then bring it back on line. This...

At prod site ..

--

SQL Buddy

Check for any errors in the setup log file ..

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\Summary.txt

--

SQLBuddy

Is the install button greyed out ..

--

SQLBuddy

Sharepoint uses SQL Server as backend. So that table should already exist in SQL Server.

Could you tell where is it actually residing ..

--

SQLBuddy

Having multiple log files for a database will not give you any errors or warnings.. Just wastage of space and increasing the complexity...

It's like buying 10 marriage dresses for ones...