Nice one... good to recall old days SQL 2005 🙂

Time for the backup also vary depending on the processes going on the server. There might be some temporary blocking while taking the backup which may inturn increase the time...

The actual number of user connections allowed also depends on the version of SQL Server that you are using, and also the limits of your application or applications and hardware....

In addition, attached script also can be handy for backup and restore. However little modification is required as per the requirement. This is for log backup you can also use...

Just to clarify further...

Only if you didn't apply any Tlog backup your diff backup will work. Differential backup can't be apply on secondary server if subsequent tlog backups have successfully...

Find another link in addition to the above. This is perfect way to do step by step troubleshoot of database mail:

http://technet.microsoft.com/en-us/library/ms188663(v=sql.105).aspx

HTH

Execute following command:

select * from msdb..sysmail_faileditems

This table contain single row for each failed items.

HTH

Like the basic question.

Indeed a great one!!

Good easy one.

As explain by Gila it is not possible.

However if your all backup and everything are fine and still if you have the same problem there might be possibility that someone...

Here is the technical description of Checkpoint pages/sec: "Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to...

Agreed with Jeff, it all depends on the desing of the LUNs.

Redgate, ignite, SQL Sentry

Check for stored procedure to fix orphaned users or fix user login which may help. Or create a script of commands which manually you are executing on server to fix...