Topic: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan
Is SQL 2014 64 bits, on it bases 1 are twisted. Plans of service from for errors in SQL do not work. It was not possible to solve.
As adjusted copying now. Costs Effector saver 3, does copies without compression, like works. But it would not be desirable it to trust completely.
Advise, can eat simple script SQL which can be made normal copies.bak, without compression or still something. That if something happens, it was possible to create pure basis, to push on it the right button, to select point to recover a copy and to load bak.
To do a copy it is necessary every day automatically, without a broad gull. It is desirable, that copying did not hinder users to work.
Bases 2, totally 30 Gb. It is a lot of Empty seat.