Sp will be faster as they are on same computer so all precompile and other things for ssis can be avoided.

IT will be great if you can describe how log shipping is configured, when was it configured and how was it working after initial setup

Since failover will start sql server services on other node it will also move tempdb. I have not tried it but definitely it will move as internally failover is going...

I too faced similar situation where in taking log backup to disk throws error message as BACKUP detected corruption in the database log. Following are the things that I have...

yes very much necessary so that it will also failover to the node incase your sql server is failing over.

Hi All,

One more thing to add to this is that if you want to move TEMPDB database to different location, Alter DAtabase is only option you have.

You need to restart...

Hi Killer,

I think your question is incomplete to get the ans. Knowing the table size and no of columns one cannot decide on how many non clustered index are required...

Hi Bill,

Please find my ans in the lines marked with ***

) What factors should be taken into account in determining whether this should be done daily, weekly or at some...

Hi

I think u should cycle error logs regularly according to ur needs. U can schedule a job to run according to ur requirements. U can use sp_cycle_errorlog command.

To open...

Hi Kim

I guess the problem could be bcz of memory. As in backup process, first backs up the file in memory and than writes to disk. So may be it...