Category: MS SQL

Microsoft SQL Server

MSSQL-Feature-Image
Author: Joe Chan Published Date: 08 Sep, 2019
Posted in MS SQL

Log Shipping

Log Shipping 1. Production Server send transaction log backups to…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 18 Aug, 2019
Posted in MS SQL

Standby Database

Standby Database It can minimize the down time It restore…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 11 Aug, 2019
Posted in MS SQL

Restore Database

We will use the backup files which set up at…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 04 Aug, 2019 1 Comment on Setup a backup file for restore
Posted in MS SQL

Setup a backup file for restore

Parepre of backup for restore: We create a database named…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 14 Apr, 2019
Posted in MS SQL

Tail-log backup in MS SQL

What is Tail-log backup: It is a log backup. It…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 12 Apr, 2019
Posted in MS SQL

Filegroup backup in MS SQL

How to list table and filegroup relation in T-SQL: SELECT…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 10 Apr, 2019
Posted in MS SQL

Log backup in MS SQL

How to Log backup in GUI: Open “SMSS” > expand…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 04 Apr, 2019
Posted in MS SQL

Differential backup in MS SQL

How to differental backup in GUI: Open “SMSS” > expand…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 30 Mar, 2019
Posted in MS SQL

Full Backup in MS SQL

How to full backup in GUI: Open “SMSS” > expand…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 29 Mar, 2019
Posted in MS SQL

Information of MS SQL Backup

We need to backup the following type of data in…