Bob, I think it depends on your app. Here we've done both. Originally dropping them in the file system since we have all this web code and we can easily...

That's the thing. I don't know. If you had a snapshot database, I'd say it would go suspect, but since you don't, I have no idea.

At this point, I would...

You're welcome, Dugi. It's been a long time, but Backup Exec has off my list for those old reasons. The restore process is relatively simple now and I see no...

Good note, Ian and Lynn.

If I remember this, for a named instance, you'll connect with UDP 1434 and get the port that the instance is using, then you connect on...

I made a few changes to the formatting, so the article should read better now.

Good job Timothy. I've heard of most of these, but a nice reminder of what they do and how they work. Easy to forget them if you don't work with...

A PK is a logical structure. It means the field(s) that uniquely identify each row in the table.

This is implemented in SQL Server as a unique index. If you set...

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...