วันพฤหัสบดีที่ 29 เมษายน พ.ศ. 2553

Backup and Restore System Database

************************ Backup *****************************************
- backup Database to Disk

backup database master to disk = 'path'

- Backup Databse to Backup device

Create backup device

sp_addumpdevice @physicalType , @logicalname , 'Store Path'

Backup Database to device

backup database master to @devicename

************************ Restore *****************************************

1. Install the new SQL Server Instance
2. Start SQL Server Instance
3. Install Service Pack and hotfix
4. Stop SQL Agent
5. Start the SQL Server in single-user mode
6. Use SQLCMD log on to SQL Server instance with system administrator account
7. Restore the master database with excute command

Restore database [Master] from disk = 'path'

ไม่มีความคิดเห็น:

แสดงความคิดเห็น