頻道欄目
首頁 > 資訊 > SQL Server > 正文

How to backup and restore database in SQLServer

15-04-07        來源:[db:作者]  
收藏   我要投稿

/*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.

相關TAG標簽
上一篇:臺積電:絕大多數7nm客戶都會轉向6nm_IT新聞_博客園
下一篇:最后一頁
相關文章
圖文推薦

關于我們 | 聯系我們 | 廣告服務 | 投資合作 | 版權申明 | 在線幫助 | 網站地圖 | 作品發布 | Vip技術培訓 | 舉報中心

版權所有: 紅黑聯盟--致力于做實用的IT技術學習網站

美女MM131爽爽爽毛片