Export SSIS Package Open up SSMS -> Integration Services Catalogs -> SSISDB -> Projects -> Export This should create a .ispac file. Import SSIS Package Copy over the .ispac file to new server. Double click on the .ispac file to start the Integration Service Deployment Wizard. Select “Project deployment file” and set the “Path” to... » read more
Copy Deployment File to SQL Server File Type Note MyPackage.dtsx Integration Services Package MyPackage.SSISDeploymentManifest Integration Services Deployment Manifest Double click to launch Package Installation Wizard MyPackageInterfaceConfig.xml XML Configuration Document Select “SQL Server deployment” and check “Validate packages after installation” Enter “Server name”, Use Windows Authentication, and “Package path”, check “Rely on server storage for encryption”.... » read more
Error: Could not start the <service name> service on Local Computer. Error 1069: The service did not start due to a logon failure. Resolution: Service account might be disabled. Try using another service account. Sources: https://www.codetwo.com/kb/troubleshooting-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sent-items-update/
Issue: Always On database stuck in “Restoring” state after setting up Always On Fix: Go to Always On High Availability -> Database -> “Join to Availability Group” Sources: https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/
SQL Server 2019 (15.x) Edition Upgrade The following table lists the supported edition upgrade scenarios in SQL Server 2019 (15.x). For step-by-step instructions on how to perform an edition upgrade, see Upgrade to a Different Edition of SQL Server (Setup). Upgrade From Upgrade To SQL Server 2019 (15.x) Enterprise (Server+CAL and Core)** SQL Server 2019 (15.x)... » read more
Indicates that the text, ntext, image, xml, varchar(max), nvarchar(max), varbinary(max), and CLR user-defined type columns (including geometry and geography) are stored on the specified filegroup. TEXTIMAGE_ON is not allowed if there are no large value columns in the table. TEXTIMAGE_ON cannot be specified if <partition_scheme> is specified. If “default” is specified, or if TEXTIMAGE_ON is not specified... » read more
Error SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed Alert SQL Server Log
Alert Log
Getting this error during updating a large number of records to a large table. Solutions Put the database recovery mode from “Full” to “Simple” to avoid generating transaction logs in the Full recovery mode. Update in batches. Update multiple columns at a time.
To import/export between Staging and Production server, use the SQL Server Import and Export Wizard Tool. Use “SQL Server Native client 11.0” Use query to import data to a temporary table and then insert into the destination table from the temporary table. 30 million records = 10 minutes to import data from source table to... » read more