Could you provide more information?

Are you able to re-point the applications etc?

If you are I would personally build a new cluster then mirror the databases to the new cluster and...

Hi Andrew

I've never personally had any issues with breaking a mirror, I've probably only done it about 20 times though.

Cheers

Mat

We've had simliar(ish) issues in the past with Litespeed "Losing connection" to the database engine, in that case I think we had to re-start the SQL Service to fix this...

True, but then you could also delete audit data if you wanted to, I assume that it's not malicious.

Evil Kraig, your statement is incorrect, the host_name() function retrieves the host name of the machine making the request, I have used it in the past for auditing of important...

We have a few template stored procedures, we then just fill in the name of the table and a couple of other bits of info like number of days to...

Are you using a seperate server as the monitor? It sounds like your secondary server is not updating the monitor correctly. This could be a permissions issue or...

It sounds like you are using a SQL Authentication login and you have created a new login on the mirror server. If this is the case have a quick...

Hi Sapen

You need to get in touch with whoever looks after the storage system for that server.

The errors are from SQL Server trying to access tempDBs data and log files...

Are you taking regular transaction log backups?

If not you will need to otherwise the log file will continue to grow no matter what you do, there should be...

GilaMonster (3/23/2011)

---

mathew.walters (3/23/2011)

---

The only way to really "Delete" without generating log records is to use partitioning. We use this to switch out old data to an archive table then...

The only way to really "Delete" without generating log records is to use partitioning. We use this to switch out old data to an archive table then we can...