备份与还原主数据文件

use master
go
alter database llqunkong2 set recovery full with no_wait;
go
DECLARE @FileName VARCHAR(200),@CurrentTime VARCHAR(50);

SET @CurrentTime = CONVERT(CHAR(8),GETDATE(),112) + CAST(DATEPART(hh, GETDATE()) AS VARCHAR) + CAST(DATEPART(mi, GETDATE()) AS VARCHAR);

SET @FileName = 'F:\DBBackup\' + @CurrentTime;

BACKUP DATABASE [llqunkong2] FILEGROUP='PRIMARY' TO DISK=@FileName WITH FORMAT;
GO
use master
go
ALTER DATABASE [llqunkong2] SET RECOVERY SIMPLE WITH NO_WAIT;
GO

--还原主分区
RESTORE DATABASE [llqunkong2] FILEGROUP='PRIMARY'
FROM DISK='F:\DBBackup\20110916000001.bak' WITH FILE = 1,
MOVE N'llqunkong2.mdf' TO N'E:\database\llqunkong2.mdf',
MOVE N'llqunkong2_log.ldf' TO N'E:\database\llqunkong2_log.ldf',
RECOVERY,REPLACE, STATS = 10;
GO

--注意：还原结束后可能会出现数据库正在还原状态，数据库不能使用。可删除此数据库，重新执行还原操作。