Search Results for: Backup and restore

How to backup a TDE protected database on Azure SQL Managed Instance
Posted in MS SQL

How to backup a TDE protected database on Azure SQL Managed Instance

We can take a COPY_ONLY backup of a TDE-protected (encryption enabled) database…

Posted in MS SQL

Checking the Backup Path of a Database in SQL Server

Backing up a database is an important part of any database administrator’s…

Linux Commands frequently used
Posted in Linux

Linux Commands frequently used

Linux Commands frequently used Linux is a powerful and versatile operating system,…

Estimated time to complete Backup and Restoration database in SQL Server
Posted in MS SQL

Estimated time of Backup & Restoration

Estimated time to complete Backup and Restoration database in SQL Server As…

Posted in MS SQL

Backup & Restore Multiple Databases

Backup & Restore Script for Multiple Databases Backup and restore all databases…

Posted in MS SQL

Table backup in SQL Server

Introduction Here we will discuss different backup strategies and methodologies used to…

Posted in MS SQL

Database Backup & Restore in SQL server

Introduction Backing up a database is one of the most important things…

Posted in MS SQL

8. SQL Server Backups

SQL Server Backups Backup means, saving the exact copy of the current…

Common Backup Issues in SQL Server
Posted in MS SQL

Common Backup Issues in SQL Server

SQL Server is a powerful database management system that is used by…

Posted in MS SQL

Fixing Orphaned Users in SQL Server

Fixing Orphaned Users in SQL Server A ‘Login’ allows us to connect…

Posted in MS SQL

A Guide to SQL Server Migration

12. SQL Server Migration Migration means moving one (or) set of databases…

Posted in MS SQL

9. SQL Server Restoration Tutorial

SQL Server Restoration Tutorial Restoration is a process of using backups to…

Knowledge Transfer
Posted in MS SQL

All about SQL Server KT

Knowledge Transfer in IT Companies In the IT industry, knowledge transfer is…

SQL server database in SUSPECT MODE
Posted in MS SQL

SQL server database in SUSPECT MODE

Scenario A database in SUSPECT mode is one that is not fully…

Posted in MS SQL

Operating system error 50 in Azure SQL Managed Instance

We encountered an error while taking a backup of a database from…

Posted in Oracle

Oracle DBA Interview Questions

Oracle DBA Interview Questions A. COMPANY- Oracle (OFSS), Location -Bangalore 1. Describe…

Posted in MS SQL

Best Practices for SQL Database setting

1. Database Owner: ‘sa’ As per my understanding, the Database Owner always…

Posted in MS SQL

Error : FILESTREAM feature is disable

Introduction Error – System.Data.Sqltypes.SqlClent.SqlError:FILESTREAM feature is disable. (Microsoft.SqlServer.Smo) Scenario A database backup…

Posted in MS SQL

TSQL Queries Used by SQL DBA in day to day

Some TSQL queries used by SQL DBA in day to day activities…

Posted in MS SQL

MSSQL Frequently Asked Questions in SQL Server | FAQ

What is RDBMS? Relational Database Management Systems (RDBMS) are database management systems…

Posted in MS SQL

14. Log shipping

What is LOG SHIPPING in SQL Server DBA? Log shipping: Shipping of…

Posted in MS SQL

13. SQL Server Upgradation

What is SQL Server UPGRADATION? Upgrading means, migrating sql server old version…

Posted in MS SQL

10. SQL Server Security

SQL Server Security Security is the most important tasks for a DBA….

Posted in MS SQL

Complete SQL Server DBA Tutorial

MS SQL Server DBA Training Microsoft SQL Server database administration training course…