Are you running backups? Check on those.

Are you checking for fragmentation? Disk space? Free space in files? All the daily maintenance that should occur on your server is something you...

Is it a network path or a local path?

The server communicates with SQL just like any other system, and I think it is a generic error that says network paths...

Add a new one and switch to that one. The default one, I believe, comes from how you registered the server. You ought to be using the name or an...

It definitely sounds like a networking issues between the branches. I'd double check the IP / network setup in all locations and be sure you don't have conflicts somewhere.

Also, I'd...

I'll second Andrew's experiences. It's been a few years (6-7), but I worked in one place that had it and ran into it twice while consulting. In all three cases...

OK, I see both sides of this argument, and I'm not sure either side is correct. The question is confusing, IF you do not see the point of the question....

Oleg,

I think I addressed this by moving the values to variables. Is that not correct?

There's a link in the article to their site at http://www.worktamer.com/

I guess it's possible there is still being copy work done on the sparse file, but I wouldn't expect that. My thought was that a update/delete in the original file...

You're late, Jason. I whacked the post.

5GB/month, 60GB a year, not that much.

Do you mean you have client apps connecting to SQL Server across the Internet? Nothing in the way to secure it? I assume a...

Can you create a new snapshot, same name, different file?

This does sound strange. When you start the instance, the file goes in use, correct?

I'm not sure I completely understand your rules, but you can calculate all the values and then use a CASE that will pull back the value you want in the...

This somewhat looks like homework, so I'll give you some hints here.

I'd build an aggregate query that uses COUNT() to determine how many times each name appears. That it a...

Mike, that's really interesting. Want to write that up as an article?