1、备份你的数据,比如test
BACKUP DATABASE [test] TO DISK = N'D:\test.bak' WITH NOFORMAT, INIT, NAME = N'test-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
2、还原一个新的数据库,
RESTORE DATABASE [test2] FROM DISK = N'D:\test.bak'
WITH FILE = 1, MOVE N'test' TO N'D:\test.mdf',
MOVE N'test_log' TO N'C:\test_log.ldf', NOUNLOAD, REPLACE, STATS = 10
GO