摘要：
BACKUP DATABASE [源数据库名]TO DISK = N'G:\testbackup.bak'WITH COMPRESSION,NOUNLOAD , NAME = N'源数据库名',FORMAT, CHECKSUMRESTORE DATABASE [目标数据库名] FROM DISK = N'G:\testbackup.bak' WITH FILE = 1, MOVE N'源数据库名' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER2 阅读全文