Hola...
Lo que tienes que hacer es generar un BACKUP de la base de datos del servidor "A" y pasarlos al servidor "B"...
En el servidor "A"
Código:
BACKUP LOG MyDataBase WITH TRUNCATE_ONLY;
DBCC SHRINKDATABASE ( MyDataBase, TRUNCATEONLY );
BACKUP DATABASE MyDataBaseTO DISK = 'C:\DATABASE\BACKUPS\MyDataBase.bak';
El el servidor "B"
Código:
USE MASTER
GO
IF EXISTS(SELECT NAME FROM SYSDATABASES WHERE NAME = 'MyDataBase')
BEGIN
DROP DATABASE MyDataBase;
END
GO
RESTORE DATABASE MyDataBase
FROM DISK = N'D:\DATABASE\MyDataBase.bak'
WITH RECOVERY,
MOVE 'MyDataBase' TO 'D:\DATABASE\MyDataBase.mdf',
MOVE 'MyDataBase_log' TO 'D:\DATABASE\MyDataBase_log.ldf'
GO
USE MyDataBase
GO
Saludos.