I was going to suggest the same as Nagabhushanam, but I got there second...  Anyway, the suggestion given is without doubt the best way to go.

BACKUP LOG ... WITH TRUNCATE ONLY is doing what it says on the can.  Run the backup log process but ONLY truncate the log file. 

You need to do a...

This can be fixed.  You need to start SQL with the -T3608 and -f flags, and do the work in Query Analyzer.

1) Start SQL and QA as above

2) Run sp_attach...

If you have not turned on AWE, then regardless of the amount of memory you allocate to SQL Server, it will not use anything above the 4GB line.

If you have...

When we were looking at how to provision the storage we wanted, we looked at SAN, NAS and DAS.  NAS got rejected quickly due to performance issues.  The cost for...

Any request such as you have received has to be subject to a cost / risk analysis.  You should also verify with the auditors and your mangement that any solution...

Colin,

You will need to talk to your choice of SAN vendors concerning the serialisation of replicated data.  With HDS and asynchronous replication, we have an assurance that replicated data is...

The active/active applications update the databases in GB and US independantly.  There is no replication or other link between them.  We have a reconciliation process that periodically checks the two...

We use SAN replication for SQL between our GB and US data centers.  We use HDS 9900 series SANS at both sites.  Our applications are classed as active/active or active/pasive,...

One problem may be network connectivity.  We had a similar issue, but our network support people would not accept it was a network problem.

Eventually one of our guys wrote a...

I think when you look at the stats, the world's most popular sport by a very long way is fishing.  But maybe a database for fishing is not such a...

It is not the complexity of the sport that drives the database needs.  The complexity of the media operation around the sport requires complexity a few orders of magnitude greater...

There are a few issues with SP4, listed below.  All of them have fixes or workarounds except d) which you have to live with.  I would recommend applying the latest...

Logging in Tempdb is done in exactly the same way as for any other DB in Simple recovery mode.  i.e. everything gets logged, so that anything can be backed out. ...

So, you had a steam locomotive and have just purchased a diesel and want to know where to put the coal in so it works?

AWE is not relevant with 64-bit. ...