The easiest and safest approach is to Restore...

It is a contention issue between two resources. You may find these articles useful to resolve deadlock issues.

http://www.simple-talk.com/sql/learn-sql-server/how-to-track-down-deadlocks-using-sql-server-2005-profiler/%5B/url%5D

http://msdn.microsoft.com/en-us/library/ms178104.aspx

http://msdn.microsoft.com/en-us/library/aa175791(SQL.80).aspx

You can make use of the FTP Task. Here[/url] is an example.

You may use sp_delete_backuphistory to purge backup history. Here is an example.

You may use the below query to track the progress of backup in SQL Server 2005 and above.

SELECT A.NAME,B.TOTAL_ELAPSED_TIME/60000 AS [Running Time],

B.ESTIMATED_COMPLETION_TIME/60000 AS [Remaining],

B.PERCENT_COMPLETE as [%],(SELECT TEXT FROM sys.dm_exec_sql_text(B.SQL_HANDLE))AS COMMAND...

Does the SQL Server Agent service start? If not check if the SQL Server Agent startup account has "sa" rights on the instance.

If SQL Server Agent starts, check if any...

Since you are planning to run it round the clock, running it through a job is a better option. Running it through SSMS or SQL Agent job will have the...

If the condition is true then you may Raise an Error using Raise Error. You can configure an alert which will send out an email whenever that particular Error Numger...

Cancelled - means while the job was running someone Stopped the job before completion

Unknown - Look at the "Last Run" column for this job. It will usually be "Never". It...

Apart from the example given by Henrico, here is one more

http://support.microsoft.com/kb/310083

I second JeremyE. Thats how you can get the information in SQL Server 2005.

Here is the official documentation from Microsoft.

Since the new nodes will have more Memory and CPU, ensure to increase the Max memory if you have set it in the existing...

Also ensure that the Antivirus has been configured exclude .mdf, .ldf, .ndf files

Here is the official documentation from Microsoft.

Since the new nodes will have more Memory and CPU, ensure to increase the Max memory if you have set it in the existing...

Did you have a look at this?

select * from sysdtslog90