Thanks for the update. Off the top of my head I wasn't sure why it wouldn't work, but then again I always would set the trace off and then save...

A maintenance plan can do this as well.

I'd try it, but have tests ready and be able to roll it back if you experience issues. IT sounds like a good idea to me.

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?