This topic is relevant only for backup and restore of SQL Server databases that are using the full or bulk-logged recovery models. A tail-log backup captures any log records that have not yet been backed up (the tail of the log) to prevent work loss and to keep the log chain intact. Before you can recover a SQL... » read more
You can access the Microsoft Failover Cluster Management in a couple of different ways: Go to Server Manager, Features, Failover Cluster Manager Go to Control Panel, Administrative Tools, Failover Cluster Manager Sources: https://www.mssqltips.com/sqlservertip/2672/managing-a-windows-and-sql-server-cluster-using-the-failover-cluster-manager-tool/
There are 4 High Availability options in SQL Server 2008 that we will cover; Failover Clustering, Database Mirroring, Log Shipping and Replication. Each one has its own features and benefits. The Failover Clustering supports server level high availability whereas Database Mirroring and Log Shipping are per database and Replication is object level. Failover Clustering This... » read more
You can upgrade from SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 (11.x), SQL Server 2014 (12.x), and SQL Server 2016 (13.x). Upgrades from Earlier Versions to SQL Server 2017 (14.x) SQL Server 2017 (14.x) supports upgrade from the following versions of SQL Server: SQL Server 2008 SP4 or later SQL Server 2008... » read more
Install https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 The SSMS 18.x installation doesn’t upgrade or replace SSMS versions 17.x or earlier. SSMS 18.x installs side by side with previous versions, so both versions are available for use. However, if you have a preview version of SSMS 18.x installed, you must uninstall it before installing SSMS 18.4. You can see if you have the Preview version by going... » read more
You can upgrade instances of SQL Server 2012 (11.x), SQL Server 2014 (12.x), SQL Server 2016 (13.x), or SQL Server 2017 (14.x) directly to SQL Server 2019 (15.x). For SQL Server 2008, and SQL Server 2008 R2, you’ll either need to do a side-by-side upgrade, or a migration, to move to SQL Server 2019 as... » read more
SQL Transparent Data Encryption (TDE) Feature is a native feature of SQL Enterprise edition. Transparent Data Encryption is designed to protect data by encrypting the physical files of the database, rather than the data itself. Its main purpose is to prevent unauthorized access to the data by restoring the files to another server. With Transparent... » read more
Upgrade the existing instance to 2019 – specially for the other databases for other projects on the same server instance. You can upgrade instances of SQL Server 2012 (11.x), SQL Server 2014 (12.x), SQL Server 2016 (13.x), or SQL Server 2017 (14.x) directly to SQL Server 2019 (15.x). For SQL Server 2008, and SQL Server... » read more
In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission. Sources: https://www.mssqltips.com/sqlservertip/3559/how-to-grant-permissions-to-run-sql-server-profiler-for-a-non-system-admin-user/ https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/permissions-required-to-run-sql-server-profiler?view=sql-server-ver16
Select “Automatic seeding” (default) if you have not created the database on the secondary replica and would like this wizard to create the database on the secondary replica based on the same setting as the primary replica. Use this option, if this is a small database. Select “Join only” if you already have already created... » read more