备份和恢复通常是在中间使用一个小文件复制的方式。



备份和还原SQL Server数据库 [ ^ ]



http ：//www.howtogeek.com/50354/restoring-a-sql-database-backup-using-sql-server-management-studio/?PageSpeed = noscript [ ^ ]

hello friends...

i have two server named server-A and server-B. both servers have sql server 2008 and have same editions. i need to transfer table data from server-A to server-B. how to solve this?

Backup and restore is usually how it is done with a little file copy in the middle.

Back Up and Restore of SQL Server Databases[^]

http://www.howtogeek.com/50354/restoring-a-sql-database-backup-using-sql-server-management-studio/?PageSpeed=noscript[^]