我们怎么能在SQL Server 2008备份

备份数据库？ 右键点击数据库，点击tasks ，然后backup

或者在T-SQL中

 BACKUP DATABASE YourDatabase TO DISK = N'C:\Backup\YourDatabase.bak' WITH NOFORMAT, INIT, NAME = N'Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO 

您可能会发现此MSDN页有帮助：

如何备份数据库（SQL Server Management Studio）

备份数据库：

 USE master GO BACKUP DATABASE MyDataBase TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLExpress\MSSQL\Backup\MyDataBase.bak' WITH NOFORMAT, INIT, NAME = N'MyDataBase Full Database Backup', SKIP, NOREWIND, NOUNLOAD GO 

恢复：

 USE master GO ALTER DATABASE MyDataBase SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE MyDataBase FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLExpress\MSSQL\Backup\MyDataBase.bak' WITH FILE = 1, NOUNLOAD, REPLACE -- use with next if file names were changed ,MOVE 'MyDataBase' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLExpress\MSSQL\Data\MyDataBase.mdf' ,MOVE 'MyDataBase_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLExpress\MSSQL\Data\MyDataBase.log.ldf' GO