************************ 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'
สมัครสมาชิก:
ส่งความคิดเห็น (Atom)
ไม่มีความคิดเห็น:
แสดงความคิดเห็น