One last thought, perhaps you are backing up to the same file (appending) as well. Are you using INIT in the backups?

Matt is correct, this doesn't necessarily work from remote computers by default.

there have been quite a few debates on the "green-ness" of hybrids. I think the jury's still out on whether they are better or worse for the environment overall.

Nothing on the OS is affected. The server stops and SQL does not respond to clients, but the OS isn't changed.

There should be more resources available for the OS and...

Litespeed coes with an extractor that will extract the compressed backup back to native SQL Server format and then you can perform a restore on any server.

On separate WANs, you might have networking rules preventing the port from being used.

What is "ok"?

The data size grow because:

1. Someone increases it.

2. Data is added and autogrow is on.

That's it. It doesn't shrink because you don't have data. This isn't like a...

Nope, can't know it's the last row until you move past it.

First, please post in the appropriate forum and not just anywhere. Moved to Admin area.

Second, servers have a default collaction and sort order, databases can be set differently, as can...

Thanks for the update. When you delete replication, need to be sure the jobs are removed as well.

The IP address and port are not communicating. Can you check a netstat and see if that port is open on the server?

You either have an open transaction preventing it from shrinking or being cleared, or you are performing a large transaction that needs that space.

Log space is in no way related...

Look at sp_who2, and dbcc inputbuffer to see what work is being done. I might profile as well and see if anything is happening or if the connection is just...

I agree with what Brian has written on the technical side.

But, why do you want to block this? Think about that and honestly rather than creating issues with a one-off...

I'd disagree with the time length we have for rights. Most, meaning high 90-some %, of content produces it's value in the first 5-10 years, especially in the media and...