You don't want to shrink the log as a general rule. The only time you shrink the log is when it has grown uncontrollably for some reason. Either you forgot...

Closing

I'd agree with ALZDBA on this. You don't need another instance, and it will make upgrading easier if you do this now.

One thing that is probably happening is that users...

It's a weird issue. You do own the physical copy of the music. The murkiness comes because for a long time, when these laws were written, it was hard to...

Do you mean something like this? http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html

Interesting. A few experts that haved dived in heavily to Powershell and they seem to like it. It follows what I'd consider is a very simple format and structure.

Whether it's...

I'm not aware of connection rejections as a concept. SQL Server might terminate a connection on a fatal error, but otherwise it is the client that terminates connections.

Have you enabled PAE?

That should allow you more RAM, but I'm not sure if it will get the entire 64. The 4GB limit is a fundamental limit of 32 bit...

Is DTC running on both computers? Not sure if it's needed here, but it helps to control transactions across two computers, and you are starting a transaction in the linked...

Please suggest what? You haven't asked a question.

If you have a table you want to partition, you need to learn how to partition. There are articles on this site...

You typically use an insert..select to insert and in that case, you can specify the columns. If you look in Books Online, you will see examples for the insert statement.

As...

Dropping and recreating should give it a new ID, as well as change the versioning. IF there is substantial data in the object, that can take time.

Renaming just changes...

Note that SQL Server will not automatically move data to this file unless it is in the same filegroup.. The default filegroup will still likely be your mdf.

SQL will not...

SQL Server's endpoints are using TDS, HTTP, or SOAP.

If you want to receive some other format, you'll have to write a receiver that takes the data and inserts it into...

Are you moving on the same server or to a new server?

In either case, Gail's #2 will have the least downtime. You can keep taking logs and moving them, getting...