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
Installing Note Requires at least Windows Server 2012 or above. Developer edition has all the features of the Enterprise edition. Standard edition do not have certain features. If you want to install Machine Learning Server, you might have to do an offline install. Otherwise do not select the Machine Learning Server feature from both the... » read more
Grant Stored Procedure to Role Grant Function to Role Grant Type to Role Grant Table to Role Grant View to Role
Get Data File Information from Backup File Drop Database Restore Database
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/