Oke that 1 was cool 😀 it was even dutch for me 😉

Using compressed file/folder? backup fails then arround 35 Gb

Can you telnet send a email to you re mailbox from the sql server?

here is an example how to send a mail from telnet: http://www.yuki-onna.co.uk/email/smtp.html

If this is working...

hmm intresting default db is assigned and exist for login.

do you get also a login failed if you try to login with that account for example into SSMS on the...

you want to "replay" the trace

http://msdn.microsoft.com/en-us/library/ms189604.aspx

check also out the requirement

You say it has the correct rights and the db login is nicely mapped to the db user

so what is the userlogin his default database and does the default db...

abit to cryptic for my taste, i see its sql server 2008 and probably running some kind of replication.

You can filter you re trace to a certain database

If I have an instance with...

you re not going to reach 0 downtime therefore you got the 9's in you sla. Also take in account which application you use you re db server for

Consider:

Clustering, even...

What you also can consider beside the regulare strategies for system databases. Is to make an offline backup esspecially before upgrades/sp's will save you alot of time if recovery is...