have a look here:

http://blog.netnerds.net/2007/05/vista-net-send-is-gone-use-msg-console-instead/

there are also new ideas in comments

But issue is with service account's permissions  and it's better to consult with OS sysadmins

I suspect also fragmented db file  or disk  block size   -  more I/O to do to get the same data?

It looks like a bug

As soon as it adds incorrect spn record on the start,   you can run a stored proc on startup which does  setspn -D

It's not an elegant...

as expected

read this :

https://www.mssqltips.com/sqlservertip/1964/sql-server-2008-backup-compression/

Grant is absolutely right - there should be something different between databases/instances/whatever.

let's compare output of  sp_spaceused

            
July 29, 2019 at 1:13 pm
            
#3666811

            
            
                                                
        

by the way,  compare subsequent runs (durations)  of the same query...

Andrey, thanks.  This is very helpful.  I was hoping there was a 1 line, auto-magical script which could perform much of this but I understand it is a multi-step...

• This reply was modified 5 years, 5 months ago by  Andrey. Reason: minor amendments

are the tables the same in Contoso and your database?

what if you select *...

I bet it's configured there by default

run the query on both servers :

SELECT *
FROM sys.configurations 
WHERE name...

add ", COMPRESSION"  and run backups again , compare backup sizes

example:

BACKUP DATABASE [DBName]
TO DISK = N'E:\Old\DBName.bak' WITH NOFORMAT
, NOINIT
, NAME = N'DBName-Full Database Backup'
, SKIP
, NOREWIND
, NOUNLOAD
,...

run the command with  switch "-WhatIf"  and check what will happen with replication in your case

https://docs.dbatools.io/#Start-DbaMigration

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-login-transact-sql

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-user

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-role-transact-sql

use master 

create login [AD\user1] from windows

use [MyDatabase]

create user [AD\user1] for login [AD\user1]

alter role db_datareader add member [AD\user1]

in case if default trace is enabled, get ClientProcessID and check process trying to connect :

DECLARE @trcpath nvarchar(256)
SELECT  
@trcpath=left(CAST(value as...

You can think over database snapshots ,  if COB backups are needed only in case of...

couple of ideas:

1. sql2016 doesn't have option 'backup compression default' enabled, but others (sql2014) do
2. between  "I restored in SQL server 2016"     and      "when I take the...