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

I've used box.net as well and that's worked well for me. I've even given the login to my brother and been able to "send" him pictures that won't go through...

I'm not sure it is because Mirroring is set to be at the database level, not server. The creation of those files, to me, is technically a server level command....

I don't think it's the same because you need a new process. You can't store the keys or passwords with the backup files, or on the same tape, so you...

I don't have a personal blacklist, but I'm happy to walk away from a post/thread if someone can't respond or maintain a sense of decorum.

and of course I get called...

I think it depends on hardware, and you'll see new drivers coming out all the time now that manufacturers have the RTM.

I had no issues on a 1yr old...