SQL Data Sync table creation error

As you are setting your first SQL data sync between on-prem and Azure SQL you may come up with an error when trying to sync the group: Database provisioning failed with the exception “SqlException Error Code: -2146232060 – SqlError Number:15247,Message: User does not have permission to perform this action.SqlError Number:2759, Message: CREATE SCHEMA failed due…

0

How Statistics in SQL Server determines performance

SQL Server collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. When a large number of rows have been inserted/updated/deleted on a table then statistics may become out of date causing…

0

SQL Cluster resource fails to come online

You have a SQL clustered resource and it’s failing to come online as a clustered resource. When you look at the SQL Server error log we can see that SQL is starting and all the DB’s are also starting however, SQL is shutting down without any error messages. This is because cluster service is taking…

0

Testing AlwaysOn routing URL using SQLCMD

You have created a listener and have configured routing URL for the replicas in the AlwaysOn group. When you are trying to check if the routing URL is working as expected by trying to connect from SQLCMD using the below command: sqlcmd -S Listenername,portnumber -d databasename -K ReadOnly   you are getting the below error…

0

AlwaysOn:Joining database on secondary replica resulted in an error

Many a times when you try to create a new Availability group it would fail with the below error message :   TITLE: Microsoft SQL Server Management Studio—————————— Joining database on secondary replica resulted in an error.  (Microsoft.SqlServer.Management.HadrTasks) ——————————ADDITIONAL INFORMATION: Attempting to join availability group resulted in an error. (Microsoft.SqlServer.Management.HadrTasks) —————————— Failed to join the…

0

Moving database from On premise to Azure

It may be that you are trying to move your DB from on premise to Azure and using ALTER DATABASE command. Once you make the metadata change using ALTER DATABASE and then move the physical file to AZURE, the DB fails to come online with the following error message: 2014-05-15 04:31:59.370 spid26s      Error: 5120, Severity:…

0

Explicit DBO permissions on TempDB for a domain group

To do this we created a stored procedure and added it as a startup procedure so that whenever the SQL server service is restarted then the stored procedure will automatically grant the access to the group on the tempdb. Add the domain group to the SQL server logins and then create the following procedure: create…

0

Server Manager consuming memory

You may have seen issues on Windows 2012 server, where even after the users have disconnected from the server, their session is still consuming the memory. When you open task manager, you would see the session manager of the disconnected session taking huge amount of memory.   This happens when people with disconnected sessions are member…

0

Adding a Remote Distributor for a Transactional Replication

You may encounter the following messages when creating a remote Distributor :   TITLE: Configure Distribution Wizard—————————— SQL Server could not connect to the Distributor using the specified password. For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.0.2100.60&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=CantConnectAdminPassword&LinkId=20476 ——————————ADDITIONAL INFORMATION: An error occurred during decryption.There is no remote user ‘distributor_admin’ mapped to local user ‘(null)’ from the remote server ‘759D11CB-6B1A-4AAD-9D8E-5A89B2DAA151’….

0

Master DB restore & Service Master key

If we don’t have a recent master backup and have to make use of the files from the DR server, then as long as our target instance matches the path and build requirements we can restore master and bring it up. If the build is different , we will get an error. If the path…

0