SQL Server 2008数据备份与还原的示例分析

SQL Server 2008数据备份与还原的示例分析

1. 备份数据库

--备份数据库

BACKUP DATABASE [数据库名]

TO DISK = N'D:\SQLData\数据库名.bak'

WITH NOFORMAT, INIT,

NAME = N'数据库名-Full Database Backup',

SKIP, NOREWIND, NOUNLOAD,

STATS = 10

GO

2. 还原数据库

--还原数据库

RESTORE DATABASE [数据库名]

FROM DISK = N'D:\SQLData\数据库名.bak'

WITH FILE = 1,

MOVE N'数据库名' TO N'D:\SQLData\数据库名.mdf',

MOVE N'log' TO N'D:\SQLData\log.ldf',

NOUNLOAD, REPLACE, STATS = 5

GO

3. 备份数据库的某个表

--备份数据库的某个表

BACKUP TABLE [数据库名].[dbo].[表名]

TO DISK = N'D:\SQLData\表名.bak'

WITH NOFORMAT, INIT,

NAME = N'数据库名-Full Database Backup',

SKIP, NOREWIND, NOUNLOAD,

STATS = 10

GO

4. 还原数据库的某个表

--还原数据库的某个表

RESTORE TABLE [数据库名].[dbo].[表名]

FROM DISK = N'D:\SQLData\表名.bak'

WITH FILE = 1,

NOUNLOAD, REPLACE, STATS = 5

GO