Snapshot technology is used during the first synchronization in other types of replication. Below you can find more articles about the types of replication. …
Read More »dbtut
Merge Replication On SQL Server
Merge Replication is a technology developed for applications that want to update on the same table through multiple servers. In other words, Publisher and …
Read More »How to Fix “Saving changes is not permitted” Error
You may get an error as follows when you want to change and save a column type or size in a table in the database. …
Read More »DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports
The Oracle Database produces reports that are called AWR at specific periods and that share the general status of the database. You can use the …
Read More »Peer to Peer Transactional Replication On SQL Server
It uses the technology of Transactional Replication. As a difference, every subscriber is also publisher. You can read my article “Transactional Replication On SQL Server“. …
Read More »Does it take a long time to delete the database On SQL Server?
When you delete the database, remove the tick on “Delete backup and restore history information for databases” and check “Close existing connections”. Thus, the database …
Read More »How to Fix “Cannot open backup device” Error?
When you want to back up your database, you may see “Cannot open backup device” error as you see in the picture below. To resolve …
Read More »Policy-Based Management(Check The Trustworthy Option Of Databases-Database Facet)
Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »Instant File Initialization(Restore or Allocate Disk Space Faster)
Instant File Initialization is a feature that introduced with SQL Server 2005 and Windows Server 2003-Windows XP. To enable this feature, the SQL Server …
Read More »Transactional Replication On SQL Server
In order to understand this article more clearly, I suggest you read the article “SQL Server Replication Types“. First, the snaphot of the table …
Read More »