2,187
edits
Difference between revisions of "MS SQL"
Jump to navigation
Jump to search
Added "Manual Backup"
(→Commands and Maintenance: Added "Database Sizes") |
(Added "Manual Backup") |
||
| Line 143: | Line 143: | ||
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%' /* Show tables */ | SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%' /* Show tables */ | ||
SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' /* Show base tables only (not views etc) */ | SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' /* Show base tables only (not views etc) */ | ||
</source> | |||
=== Manual Backup === | |||
<source lang="sql"> | |||
BACKUP DATABASE DatabaseName TO DISK='E:\bak\DatabaseName.bak'; /* Full database backup */ | |||
BACKUP LOG DatabaseName TO DISK='E:\bak\DatabaseName.trn'; /* Transaction log backup */ | |||
</source> | </source> | ||