Debbie, did Eswin's links help you?

Great script Wayne!

Just to be sure. Which password are you being asked for?

I agree with homebrew01, by shrinking the database log file, you will not reduce the size of your backup. It is normal that a database will grow, so it is...

I must agree with The_SQL_DBA. It is always the best to try out things in test and then depending on the results implement the changes in production.

Siqing LU, did the artice THE_SQL_DBA suggested helped you? I was reading it and it seems to be the same problem you have, so I thing adding a unique constraint...

I agree with homebrew01. First test it and then do it in the production environment.

George, I know that the solution you gave helped to solve the problem, but I found it far more important to figure out what happened to the two transaction log...

Hi Sudhakara, did you findout what happened to the transaction log backups?

If you forget about adding the NICS, it is very simple to add an extra instance and let it run on the second node. Make sure that both nodes have...

Why do you want to add extra NICS?

Tara, could you please answer Dugi's question. There must be something in the event logs.

How can you be missing two log backups? You should check what happened to the two log backups as it may ocuur again.

If you follow Gail advice on installing developer edition instead of the enterprise edition, you problem should be solved.

You're welcome!