Простой вариант контроля кода для ms sql:
Source code control of programmatic and other objects for MS SQL server
воскресенье, 30 декабря 2018 г.
вторник, 29 мая 2018 г.
Ansible task to create vm snapshot on ESXi host without vCenter
- hosts: localhost
tasks:
- name: Create snapshot
vmware_guest_snapshot:
datacenter: esx15
hostname: esx15.domain.local
username: uname
password: upass
validate_certs: false
name: GuestMachineName
folder: /
state: present
snapshot_name: snapName
memory_dump: false
description: snapDescription
delegate_to: localhost
Ansible Docs
tasks:
- name: Create snapshot
vmware_guest_snapshot:
datacenter: esx15
hostname: esx15.domain.local
username: uname
password: upass
validate_certs: false
name: GuestMachineName
folder: /
state: present
snapshot_name: snapName
memory_dump: false
description: snapDescription
delegate_to: localhost
Ansible Docs
вторник, 13 февраля 2018 г.
Repair MS SQL after upgrade crash(2008 to 2014)
ERROR: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.backupset' and the index name 'backupsetMediaSetId'. The duplicate key value is (
1. Run ms sql with trace flag:
sqlservr.exe -sServerName -T 902
2. Connect to ServerName over sql client and manual change data. Find you error script in update scripts. Typycaly path to update script is "C:\Program Files\Microsoft SQL Server\MSSQL12.EVMVC\MSSQL\Install"
1. Run ms sql with trace flag:
sqlservr.exe -sServerName -T 902
2. Connect to ServerName over sql client and manual change data. Find you error script in update scripts. Typycaly path to update script is "C:\Program Files\Microsoft SQL Server\MSSQL12.EVMVC\MSSQL\Install"
Подписаться на:
Сообщения (Atom)