Most of these are answered in Books Online.

To get the web server to move, you'd need to change the web.config unless you have the new SNAC client. In that case,...

You can move databases as Gail mentioned for user databases. If you need to move system databases, there are other procedures.

You really need to provide more details and explain what you are trying to do. Include some sample data that shows what checks you want to do.

Ha! always tan, but true, a new shirt.

Actually two. The M-R pictures are different from Fri.

There are a few possibilities, but please provide more information as SilverFox has noted.

One way is to set up a surrogate key as a GUID. They can be uniquely generated...

Please do not cross post

Answer here: http://www.sqlservercentral.com/Forums/Topic773592-146-1.aspx

Interesting splits of opinion here.

I don't think there is a great benefit to an employee here for sure. I guess you can work with people for a couple days and...

If the SQL Browser isn't running, or the UDP 1434 is blocked, then I believe -L doesn't work.

If you have good primary keys, that should prevent duplication. Make sure the archive database has the same PKs.

The process I'd use it to move a slice of the data...

I'm not sure what this is, but without asking a question in the post and formatting things better, I'm not sure anyone will try to answer this.

I used to manage a mixed shop (DB2/Oracle/SQL Server), and the DB2/Oracle guys would always take cold backups on a regular basis.

A cold backup is one where the server is...

We are happy to help, but we don't like to do work for you. This looks like an exam or interview question, and in that case, you should be trying...

I'd second the maintenance plan if you're not familiar with SQL Server and how backups work.

Partitions might make more sense in that case. Sorry, wasn't sure what you were trying to accomplish from the first post.

No matter how you do it, you probably want to...

I think having a large db would be a headache. On call, no sleep, family interrupted. It would be a challenge, but I'm not sure I'd think it was fun.

I...