How to properly configure and maintain a bunch of Microsoft SQL Server and 1C?

I

infriNger2020-02-26 11:13:20

1C-Enterprise

infriNger, 2020-02-26 11:13:20

I want to deal with the installation, configuration and maintenance of Microsoft SQl Server and 1C. The solution is very popular, there is probably a book or article somewhere with accumulated experience and typical solutions. Please tell me where to find these, because there are a lot of articles on the Internet, but I have no experience in this topic to evaluate their quality. I would like to know everything: from installing and configuring SQL Server and ending with its optimization, backups, server load assessment, and so on. Thank you!

Reply

Answer the question

In order to leave comments, you need to log in

6 answer(s)

K

Konstantin, 2020-02-26
@infriNger

The very first thing is to look into the box from any 1C product and find the book Client-Server Version there. Admin Guide
Well, very entertaining reading, the rest is experience.

S

s19s93, 2020-02-26
@s19s93

In fact, not everything is so scary, if the database size does not exceed 10 Gb, then you can use the MSQL Express edition with a 1C bundle. If it exceeds, you must already consider a licensed version with a key.
For 1C, you need to install the 1C (Administration) snap-in where it will be necessary to register the bases.

A

Anton, 2020-02-26
@anton99zel

I myself recently made a bunch of 1C + MSSQL on VPS for client-server and web work options.
This resource helped a lot:
tavalik.ru/ustanovka-microsoft-sql-server-2012

K

Konstantin Tsvetkov, 2020-02-26
@tsklab

If you have a 1C-Enterprise application server and MS SQL server on the same physical computer, then the latter needs to set the RAM usage limit according to a formula that can be found on the network.

M

Maxim Yaroshevich, 2020-03-05
@YMax

The most important thing is backup, with a database size of 100 GB, every working hour is differential, every night is full. In the morning of each working day - checking the integrity of the database - in order not to oversleep possible errors - I corrected it several times. Every two hours on a working day - defragmentation of indexes.
A good answer has already been given before:

start with info on tavalik and interface31

- very good sites, everything is perfectly painted.

M

Mikhail Lyalin, 2020-03-05
@mr_jok

start with info on tavalik and interface31