SET DATEFORMAT ymd

This should be your case:

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

check buffer cache hit ratio and also look at Lock Pages In Memory option in sql server. There seems to be memory pressure.

Let me know how your DB's are configured...

ok this one whould provide you enough info:

http://blogs.technet.com/filecab/archive/2005/12/09/extending-cluster-storage.aspx

Surely Hardware level i.e. RAID controller level will be the best option to go with.

It is a debate in itself, as you will see more members debating my opinion.

You can get connected information from sysprocesses as follows:

select SPID,

DB_NAME(dbid) as dbname,

dbid,

login_time,

last_batch,

status,

hostname,

program_name,

cmd,

net_library,

loginame from master.dbo.sysprocesses

Order by login_time desc

Or sp_who2

For Failed attempts, you have to Query to ErrorLog. Get the ErrorLog into...

Do you mean the Server overall(windows or SQL Server)

Pl specify in detail.

Or if it is SQL Server Date Format:

Check BOL for SET DATEFORMAT Syntax

SET DATEFORMAT mdy;

SET DATEFORMAT ydm;

more on BOL

personally, i will place my binaries on the OS Drive and consider RAID 5 for system Databases. consider Raid 5 for user DataFile as they are readonly most of the...

Well, here is the basic IDEA.

A table striped across multiple drives can typically be scanned/accessed faster than the if the same table is stored on a single drive

and otherwise, Placing...

Interesting query.

you can have a step in the job that can send you emails when to job started and ofcourse the notification can be set to send you email on...

see if this helps

http://support.microsoft.com/?kbid=300956

Some storage arrays can continuously capture database snapshots

(i.e., point-in-time copies of data backups), which are overall faster back up and restore than the common traditional database backup methods.

This...

This maybe a case of Corrupted Database BAckup or a Corrupted hardware that the Database is on.

DBCC UPDATEUSAGE(DBNAME)

DBCC CHECKALLOC (DBNAME)

Also try this: DBCC PAGE (DBNAME,1,1,0)

How do toy backup the LOG?

There should be several T-Logs available gright, if you are using a maintenance plan to BAck them up.?

Manually Sort/check the logs by Datetime appended at...

Try this

Restore all transaction log backups that have not yet been restored in the secondary database.

Kill all the users from secondary database to bring the database online. (if there...