I agree, depending on the circumstances I think one could make an argument that Database Mirroring and Log Shipping both require little administrative effort once they are set up. ...

Just a batch file with the following line before we do the file copies:

net use

I'm sure it's not the most secure thing in the world, but it will...

We ended up deciding to just do this outside of SQL.

Finally figured it out. There was a database trigger involved that was causing it.

I've got a SQL server box outside our domain, and I need to be able to use xp_cmdshell on it to access a filesystem that is on our domain.

Anyone...

You shrink a mirrored databases's log file just like any other. Mirroring has no effect on your log file backups/truncating.

You don't need to kill your mirroring session to truncate your transaction log file.

Glad you got it working. Just keep in mind two things about mirroring from a 2005 principal to a 2008 mirror:

1) You can't do snapshots

2) If for some reason...

If by manually you mean by scripting it instead of using the GUI setup in SSMS, then yes, I did it manually.

I haven't ever played with the GUI, so...

Jeff Moden (1/30/2009)

---

Sounds like a lot of fun but, consider this, would you like it if your post and name showed up on a "Twit List". Bad enough they...

Hey! Now that's what we need. A hall of fame for stupid posts, (and another one for the most creative replies to these posts).

I'd reccomend running thru the upgrade process a couple of times on a dev/test server before doing your production server.

We just did an upgrade of about 8 dev boxes and...

Steven Cameron (1/21/2009)

---

I got the question wrong, but after searching some more found out I WAS wrong. It would put the information into the restorehistory table if you used the...

I must be pretty bored today. I just tried it on both SQL 2005 and 2008, and niether wrote a record to the restorehistory table.

One interesting thing...

Yea, we did have that problem a little bit.

We solved it by telling them any development they did would get lost the next time we did a software update.

Which was...