I'd go with the solution from GSquared; it will work for you and it's easy to understand.

Test is on another db first, be sure it clears up what you...

MSDE is the free version, but doesn't include all the functions. If you have a license for SQL 2000 at your company, you can install Personal edition, but you will...

Validation and calculations looking from one XLS to the other can cause problems as you scale it. It works, but it isn't designed for lots of users.

Excel can do a...

http://www.sqlservercentral.com/articles/Miscellaneous/2996/

When you run the script, it will appear.

The script has calls to sp_create_job, etc. that is exactly the same things run by SSMS when you build the job in the...

1. yes, connection strings need to change if they are not using trusted connections.

2. you can't. the Sa account cannot be used as that is for SQL authentication only. You...

The code is re-entrant. Both can run together.

You just run the script. That's the idea behind the scripting feature. You run that script on another server to recreate the job.

That's an interesting question. I would think the truncate would get passed through to the mirror as well.

Is the log growing? How often are you doing log backups? The best...

I'll add that it depends on where the free space is. If it's wrapped by active segments in the log, it might not shrink out all the free space, however,...

Just saw this, and it's good advice. Thanks!

I'd love an update to know what you tried, and what worked. Actually, if you are willing, it would be a great article.

Let's hope most of these companies survive, but they ought to have an escrow clause if they hold backups. Return the data if they die.

I'm tempted to get a safe...

wldhrs (8/23/2009)

---

Basically agree with that, but are your day job's backup processes the same now as they were, say, a year ago? I'd be quite surprised if they were identical....

It's harder in small businesses, but with remote connectivity, it shouldn't be too hard to implement. I wouldn't necessarily think this would be used constantly unless you had a really...