SQL Server Mirroring

[GeorgeB]

Hey,

One for the SQL Gurus...

Our Live server failover to the mirror last night, which worked fine. But I dont know why it happened.

Is there a log file somewhere which will tell me why it happened.

Cheers,
George.

edit: sql server 2008

[GeorgeB]

shameless bump....

[Durbs]

I assume you've already looked in Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG?

[GeorgeB]

I assume you've already looked in Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG?

I do now! - Thanks this will be handy for alot of things.

Turns out the server ran out disk space!