SQL




Common error after installation of MS SQL server 2012

After installation of MS SQL Server 2012 on Windows Server 2012, I had gotten these errors in Event Viewer on execution server:
The server was unable to initialize encryption because of a problem with a security library. The security library may be missing. Verify that security.dll exists on the system.
TDSSNIClient initialization failed with error 0x139f, status code 0x80. Reason: Unable to initialize SSL support. The group or resource is not in the correct state to perform the requested operation.
TDSSNIClient initialization failed with error 0x139f, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. The group or resource is not in the correct state to perform the requested operation.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

I must notice that I had an old distributive of MS SQL Server 2012.

(read more...)

Backup MSSQL database with compression

To create a full backup of MS SQL Server database with compression use this SQL command:

use YourDataBaseName
go

BACKUP DATABASE YourDataBaseName
TO DISK = 'Z:\BACKUP_FILE_NAME.bak'
WITH COMPRESSION

According to database size and your server capabilities, backup time can vary.

 


MarkiMarta.com. Notes of web-specialist
Since 2009
18+