SQL Server Management Studio备份和还原数据库的操作

环境：windows10、已经部署好sql server 2008 R2、能成功连接到数据库；sql server备份以及还原的命令操作_sql

sql server备份以及还原的命令操作_Backup_02

例如：备份class1数据库

BACKUP DATABASE [class1] TO  DISK = N'D:\program files\sql server\MSSQLSERVER\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\class1.bak' WITH NOFORMAT, NOINIT,  NAME = N'class1-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

sql server备份以及还原的命令操作_sql_03


备份日志

BACKUP LOG [class1] TO  DISK = N'D:\program files\sql server\MSSQLSERVER\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\class2.bak' WITH NOFORMAT, NOINIT,  NAME = N'class1-事务日志  备份', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

sql server备份以及还原的命令操作_sqlserver_04

还原

RESTORE DATABASE [class1] FROM  DISK = N'D:\program files\sql server\MSSQLSERVER\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\class2.bak' WITH  FILE = 1,  NOUNLOAD,  STATS = 10
GO

sql server备份以及还原的命令操作_Backup_05