I would recommend SSIS also - and I don't see Service Broker as the right solution. I would think service broker is more geared toward event driven processing -...

You should be able to run the process to add a node for that instance. You run that on the additional node where you want that instance. Remember...

In addition to all of the advice given so far - you really need to look at how you are using those functions. Scalar functions are notoriously slow and...

There are only a few processes that will break the differential backup chain. This has nothing to do with the log chain at all - specifically, this is some...

I am going to guess that the OP means he needs to add 14GB of the additional 28GB of memory to that instance of SQL Server.

The question still remains -...

Can you provide the backup statement that is being used to backup the databases?

Also, just to verify - can you provide the results of @@version for each instance?

what you are seeing is just a display issue. By default, output is truncated at 255 characters or the size of the column, whichever is smaller.

The data type is...

And, reviewing your code - I am not sure what you are trying to accomplish. There doesn't seem to be any reason to use rtrim, nor any reason to...

The above is from...

It depends on what has happened on the principal after mirroring has been stopped. If you have a continuous log chain, then all you need to do is apply...

I know this isn't a solution - but there are two buttons next to the database drop-down to connect/disconnect or change connection.

After dragging the file, or double-clicking a sql file...

I don't see what columns you are totaling, and what the expected total should be.

For this example, what is the expected value - and what is the actual value you...

This is normal when you haven't set max memory for SQL Server. SQL Server will take all of the memory you allow it.

This cannot be done using the standard tasks provided for maintenance plans. To do this, you would need to write custom code to loop through each database - backup...

That looks good to me - good luck.