-Going my snippet of log posted it seems which is INSERT statement pasted in first part, so application may have to re-run the transaction at later point of time.

-...

You need to elaborate on first question it is not clear.

Second start up parameters are applied at instance level when sql server instance is started, there are default ones and...

Did you try running profiler during this time if you see this happen at particular time or manually run sp_who2 when this is occuring ?

Also suggest querying the MSDB database.....

Are you experiencing same as posted below......

Currently using Litespeed for backup of 1TB+ database, which compresses down to 103GB within 2hrs, which is pretty good. Depending on your RTO, this...

Is this domain user part of SYSADMIN or Local Administrator group of mirror server ?

Verify if this user is part of WITNESS\PRINCIPAL not added to Mirror

Cheers

Sat

Collation setting applied in SQL 2005 should remain the same when you migrate to SQL 2008 , for in-place upgrade this would not be problem.

Compatability level can be changed to...

Snippet of error

Delete Old Report Files Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_delete_file 1,N'C:\Program F..." failed with the following error: [highlight=#ffff11]"xp_delete_file() returned error 2, 'The system cannot find...

This depends on workload on your server... for testing purpose or learning purposes 4GB RAM on both servers using Windows 2008 and SQL 2008.

Cheers

Sat

If it HA solution for warm standy server would not advice P2P replication , you are better of with mirroring or Log shipping.

Cheers

Sat

Good place to start for migration project in below link, hope your it answer's your question

http://www.sqlservercentral.com/articles/Upgrade/65872/

Cheers

Sat

Yes mirroring is at database level . so you can create multiple endpoint within the same instance.

Cheers

SAT

Are you planning to Host web application, along with SQL server cluster ?

In case you accidentally left it there and not plan to use MSDTC service then it should not...

- Yes you have two instances if you install default and later install named instance.

- Resources shared are RAM and DISK IO, some these setting's are configured in SQL server...

-We had build system for client sometime back where we use to ship 6 months old data to different server for reporting purposes (read only)

-Deleted the from current database previous...

I feel like sitting in interview panel now :-P, anyways try MSDN site further clarification.

Cheers