-
Types of MySQL Version Upgrades
•
there are two types of upgrades Minor Version Upgrade The first step when performing a minor version upgrade is to obtain the current version of MySQL and the newer minor upgrade available. To get the current version of MySQL on Red Hat, we use the following command, which queries the RPM package: To obtain…
-
Understanding SQL Server Replication: Types, Prerequisites, and Key Components
•
Replication doesn’t send the entire database to another location, unlike log shipping or always-on solutions. Instead, it has a unique advantage – you can choose to replicate specific parts of the database, like views, tables, or any other objects you want. In essence, replication gives you the flexibility to pick and choose exactly what…
-
Sql server database backup in details
•
What Is a Transaction Log? Transaction log is a list of records for all Microsoft SQL database changes. It is an essential component of the SQL Server database. If there is a system failure, you will be able to use the T-log to bring your database back to a consistent state before the point…
-
Sql Server how to Manage transaction logs
•
Managing transaction logs Transaction managing in simple mode : here we will test log managing in both simple mode and full mode . i have created two database one full one simple mode added table on it then i will run trsnaction but i will not commit the transaction you can see the qurey…