本篇文章主要介绍了"How to backup and restore database in SQL Server"，主要涉及到方面的内容，对于SqlServer感兴趣的同学可以参考一下：
/*By Dylan SUN*/If you want to backup and restore one database in SQL Server.Fir...
/*By Dylan SUN*/
If you want to backup and restore one database in SQL Server.
Firstly, create a shared folder, and add everyone with read/write right.
Secondly, backup your database.
You can use the following script :
backup database DatabaseName to disk ='\\SharedFolder\backup_database\DatabaseBackup.bak' with INIT, stats=10
Thirdly, restore your database
You have two methods to restore the database.
1. Use command line
If your database exists, you can drop it.
DROP DATABASE DatabaseName
Recreate it
CREATE DATABASE DatabaseName
Find the logical names for the data files and log files of the database backup.
restore filelistonly from disk='\\SharedFolder\backup_database\DatabaseBackup.bak'
Then you can restore your database with the following information.
RESTORE DATABASE DFM_INT_FI
FROM DISK = '\\SharedFolder\backup_database\DataBaseBackup.bak'
WITH REPLACE,
MOVE 'DB_PRIMARY1' TO 'c:\temp\DB.mdf',
MOVE 'DB_PRIMARY2' TO 'c:\temp\DB2ndf',
MOVE 'DB_log' TO 'c:\temp\DB_log.ldf';
2. Use SSMS
Right Click DataBases, and then click "Restore database..."
Choose "Device", and then add the backup file
And then click OK, SSMS will restore the database itself.
以上就介绍了How to backup and restore database in SQL Server，包括了方面的内容，希望对SqlServer有兴趣的朋友有所帮助。
本文网址链接：http://www.codes51.com/article/detail_124376.html
