Please enable JavaScript.
Coggle requires JavaScript to display documents.
MS SQL relational database management system RDBMS (Database (System…
MS SQL
relational database management system
RDBMS
Usage
create database
analyze data thru SQL Server Analysis Services (SSAS)
generate report thru SQL Server Reporting Services (SSRS)
carry out ETL operations thru SQL Server Integration Services (SSIS)
Database
System Databases
Master
Model
MSDB
Tempdb
Resource
Distribution
Create Database
Create database Testdb
Restore Database Testdb from disk = 'D:\Backup\Testdb_full_backup.bak
use SQL Server Management Studio (SSMS)
Select Database
Exec use msdb
select msdb database
Drop Database
Drop database Testdb
Backup Database
Full backup
Backup database Testdb to disk = 'D:\Testdb_full_bak'
Differential/Incremental Backup
Backup database Testdb to disk = 'D:\Testdb_diff.bak' with differential
Transactional Log/Log backup
Backup log Testdb to disk = 'D:\Testdb_log.trn'
use SSMS
Restore Database
Restore database Testdb from disk = 'D:\Testdb_Full.bak' with replace
use SSMS