6 months? I've struggled to remember things I did last week at times.

Everyone definitely needs a log

incorrect.

a backup does not affect anything in process. It captures all changes that are committed up to the end of the backup, but does not lose anything.

How are users connecting?

My short answer is that if you can force them to run dynamic SQL through a proc of some sort, you could use REPLACE to strip out...

First, all tables need a PK. Otherwise you'll get into issues at some point trying to work with the individual rows. Set one up for all tables.

Second, how do you...

This is logged somewhere. It's been a low priority feature, especially with relatively few people using the briefcase, but I'll bump it up a bit.

Coffee isn't necessarily for steak. Maybe after, with the "adult beverage group" included.

First, a diff contains all changes since the last full backup. So if you make 1 change, then run a diff, then make a 2nd change and run a diff,...

You need to make sure that you perform regular log backups to ensure that it does not grow so large again. In doing your log backups, you do not need...

Keep in mind that when you connect to B, the backup is made local to B, meaning from the drives that the service account on B can see.

There are lots of people that are consultants or DBAs that list resumes on their blog. You can try Pinal Dave, maybe Brent Ozar, but you don't want to necessarily...

I believe this is true. Integration Services is the subsystem for running packages. They can be stored in msdb or in the file system, and built in Visual Studio or...

Database Mail should work in all editions except Compact and Express.

Lynn has a good idea. What you need is a programmatic task that will create a new file name each day. How are you doing this right now? What is...

Should be no issue with multiple IP addresses. I haven't seen problems with connectivity because of this. If they are timing out, I might check and be sure that it's...

Now I want a steak for dinner, but my wife put a turkey in 🙁