After some research, I think I may have tempdb contention problem. Made 8 equal sized tempdb files. Will see how that's going to pan out.

Thanks, Henrico. I did check with our network guy when the system looked bad, but he thought the network was fine. Also, the SSMS was very slow at times even...

Thanks, Kevin.

Thanks a lot, guys. I think I found out what the problem is. The tempdb right now is on C:, which is where the main i/o outage happens. My plan...

Exactly so. Only that I don't need to back up and store the huge amount of data, which is refreshed constantly and is not worth saving.

Phil Parkin (8/24/2016)

This sounds...

Thanks, Eric. I just wanted to extract the db structure to a .sql file and backup the file on a regular basis. This way I can rebuild the DB from...

Many thanks to everyone. Great ideas! I'll look into the options and pick one that best fits my purpose.

No. If there was, it should happen consistently as well, but it didn't.

100% sure. Doesn't make any sense to me, either. That's why I'm very puzzled. Out of a dozen DBs restored this way, only one got into Master this time. Sometimes...

Those were auto generated scripts that I ran repeatedly over time. Sometimes I would have trouble, sometimes no. It really doesn't make any sense to me. I only noticed the...

Thanks, all. The problem is now resolved. As was suspected, I changed the port number to 1435 for one of the instances so the two were not conflicting. It's working...

Yes, that's how I found out I can only run one instance at a time. I thought one server was overwritten by another at the very beginning. But when I...

Thanks for the input. I meant if the email recipient doesn't exist, wouldn't the system get a delivery failure and log the error? I guess it can't be done because...

This is embarrassing. It turned out the problem was I misspelled the email address for the Operator. Checked that spot a million times but didn't notice it was spelled wrong....