Back up the master key and certificate that are used for TDE to a safe location. The master key and certificate are required to restore backups that were taken when the database was encrypted with TDE. After you remove the database encryption key, take a log backup followed by a fresh full backup of the... » read more
TDE and Always On To configure the TDE on the TDE_Test database, we should first create a master key in the master database. Only one master key can be created per each SQL Server instance. All user databases that are hosted in the same SQL instance, and have the TDE enabled on it, will share... » read more
Create Database Master Key and Certificate Note: USE master database. You should backup the Certificate (With Master Key) as soon as you create the certificate. Note: You can not create a Master Key if a Master Key is already created. You can not drop a Master Key if there are existing Certificate created with the... » read more
Tasks Check Database Integrity Shrink Database Reorganize Index Rebuild Index Update Statistics Clean Up History Execute SQL Server Agent Job Back Up Database (Full) Back Up Database (Differential) Back Up Database (Transaction Log) Maintenance Cleanup Task
A synonym is a database object that serves the following purposes: Provides an alternative name for another database object, referred to as the base object, that can exist on a local or remote server. Provides a layer of abstraction that protects a client application from changes made to the name or location of the base... » read more
Note: sp_spaceused is the fastest way to get a list of table size of the database. sp_spaceused Note: This query is the most detailed. It breaks out the Used space to Data Space and Index Space. ReservedSpace = DataSpace + IndexSize + UnusedSpace Total Space Note: Total Space includes both Used Space (Data + Index)... » read more
Restoring database to original from full backup file. Note: After restore completed, need to re-map user permissions to that database. Time 100 GB = 1 hr
Problem: User can not connect to SQL Server from a remote computer via SSMS. Ping returns unreachable. When user remote desktop on to server and use SSMS from the server, the user is able to connect to SQL Server. Note: Make sure SQL Server Instance is running on the server. If multiple instances installed, make... » read more
View SQL Server Logs SSMS -> Server -> Management -> SQL Server Logs Error Logs View the error logs if SQL Server is unable to start. C:\Program Files\Microsoft SQL Server\MSSQLx.MSSQLSERVER\MSSQL\Log Sources: https://docs.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-sql-server-error-log?view=sql-server-ver15
After you have installed SQL Server Reporting Services 2017, you will need to configure SSRS before you can use it. Go to Reporting Services Configuration Manger to configure SSRS. Reporting Services Configuration Manager Configure the Web Service URL tab and hit Apply to create directory in IIS. Configure the Web Portal URL tab and hit... » read more