Exactly.

homebrew01 (9/8/2008)

---

Good Luck !

There are other IT tools outside of SQL, used for pushing data to different locations, that use the word "replication" in their name or description. Perhaps some...

I'll give it a shot, homebrew, and I actually have some hope. The migration has been put off for a few weeks, so taht we can better prepare. ...

Homebrew, you've put me into an awkward position. How do I answer your question, without, well, making it look bad for others. I'll try the best I can.

We're...

You've asked some good questions, Mr or Mrs 500, so let me see if I can answer them.

Yes, the databases are available 24/7 through our web applications. However, the...

Thank you, Timothy and David for your replies. I don't think we have a copy of SQL Server 2005 administration books around, but it sounds as though that would...

Thank you, Fraggle, for the link to the other thread on the difference between SQL Server Maintenance Plans and SQL Server Jobs.

What is logshipping?

David, it sounds like, given what you've said, I would be better off either dettaching the files and attachning them after I've copied them to the new server, or doing...

I just watched your video podcast on this topic, Steve. Nice place! If you ever want to sell it...

But seriously onto the topic at hand. I do...

Brian, I'd like to ask a question about the "Setting and Changing the Server Collation" article that you referred to. Steps 2 and 3 of the instructions say to...

OK, thank you, Brian.

Is the default collation not case sensitive for only username, or is it also not case sensitive for password?

WOW! You're right, that is not going to be easy or quick. Someone else set up this new test database, and now I wish he hadn't done that....

OK, I've found the problem. Apparently the username is case sensitive. I didn't expect that. I know that the password is case sensitive, but I didn't realize...