Hi,
we start our ssms with a command line, to connect to different sql server in different domains.
But this is not slow, and it feels like you work local...

Hi,
are you working with (local) firewalls?
default port sql server engine is 1433, but DAC port is 1434
Are you able to telnet this port from server2 to server1?

Hi,
did you take a look to the log-file  RSetup.log?

Hi,
try this query to check your backup-compression-ratio:


SELECT
    [database_name],
    [backup_size],
    [compressed_backup_size],
    [backup_finish_date],
    CAST(backup_size/compressed_backup_size AS DECIMAL(16,2)) AS backup_compression_ratio
FROM msdb..backupset;


It depends on...

Hi,
how did you create both users. If you created them without the same SID, for the sql server the users are different.
You can script the user from server...

Hi,
we use trace flag  "3226".
We take log backups every 5 minutes, and we won't spam the errorlog with the successfully backup information.
Kind regards,
Andreas

Hi,
you can use cursor to query all your databases on  your sql server:
Here is a very good link:
http://www.sqlservercentral.com/blogs/vivekssqlnotes/2011/07/21/cursor-in-sql-server/
Kind regards,
Andreas

Hi,
sorry for my missunderstanding.
I think it is not possible, to use 2 distribution databases for one publisher.

We were not able to do this with sql server...

Hi,
this is a very good  page for scaling out distribution:
http://www.sqlservercentral.com/articles/Replication/69663/
kind regards,
Andreas

Hi,
a backup won't shrink you logfiles. The internal LSN are marked for reuse.

Try to look the usage of your logfile

DBCC sqlperf (logspace)

If you are installaling a SP for SQL Server, the sql server service will restart.
Kind regards,
Andreas

Hi,
what version of SSMS do you have.
Kind regards,
Andreas

Hi,
if you like Powershell, try this page:
https://dbatools.io/
With  this set of tools you are able to move a complete database from server A to B, with logins,...

Hi,
this is a forum. It would be nice  to share  the question and the solution.
No post would be deleted.
kind regards,
Andreas

Hi,
what is the output if you  try this command:

KILL xxx WITH STATUSONLY