1

Topic: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Good afternoon!
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.

2

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Roman_915 wrote:

Advise, can eat simple script SQL

SQL Server Maintenance Solution by Ola Hallengren

Roman_915 wrote:

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.

And than compression prevented?
Or at you not the server, and a zip presses close?

3

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Yasha123, I found earlier, the description as it is possible to make a script, and on Russian-speaking  is. I thought is at someone, ready and checked up that for certain it was possible to use.
Compression is not mandatory, since it is additional lines in a script, but is not critical if is.

4

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Roman_915 wrote:

I thought is at someone, ready and checked up that for certain it was possible to use.

Here it also is ready and checked up.
All over the world it use and "check",
But probably a script from uncle Vasi " and ,
+ For certain it was possible to use."

5

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

CREATE PROCEDURE [dbo]. [QWERTY_Backup]
AS
BEGIN
declare @DT datetime2 (0) = SYSDATETIME ();
-- @FilePath nvarchar (128) =N ' \\Srvbackup\............. ', - on network to a full-sphere
@FilePath nvarchar (128) =N'F:\BackUp\QWERTY \', - on a local disk
@FileExt nvarchar (4) =N'bak ';
@FileName nvarchar (128);
@BakName nvarchar (128);
@LastDate nvarchar (128)
set @LastDate=convert (nvarchar, DATEADD (DAY,-15,@DT), 126)
set @BakName=N'QWERTY_backup _ ' + convert (nvarchar, @DT, 112) + ' _ ' +replace (convert (nvarchar, @DT, 108), ': ', ")
set @FileName = FilePath + BakName + '. ' + FileExt
BACKUP DATABASE QWERTY
TO DISK = @FileName
WITH NOFORMAT, NOINIT,
NAME = @BakName,
SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10
EXECUTE master.dbo.xp_delete_file 0, @FilePath, @FileExt, @LastDate, 1
END

6

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Roman_915;
Is better solve a problem with work service plans. No Ola Helengrin tests the code how it do in Microsoft. Also, you can calculate for their support and warranties.
Besides, presence of problems in server operation in itself should guard. Whether only plans broke?!...

7

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Gladchenko wrote:

Roman_915;
Is better solve a problem with work service plans. No Ola Helengrin tests the code how it do in Microsoft.

not the left means  uses, and just MS-ovsky native BACKUP DATABASE.
And here the HARDWARE asks a script where too will be BACKUP DATABASE;
But written do not understand whom (it to write does not wish/not is able)

Gladchenko wrote:

Also, you can calculate for their support and warranties.

And what warranties gives MS in a case;
When, for example, bring down all  in one file;
And then  on ?
He asks not the link to description BACKUP DATABASE;
And a ready script which it is possible very even to write crookedly

wrote:

Besides, presence of problems in server operation in itself should guard Gladchenko. Whether only plans broke?!...

Yes  replaced the password at sa;
In the plan the old is hammered;
Nobody to find in a state, where it is necessary to change it

8

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Alexander Gladchenko, I too understand that nobody guarantees the correct code, but I allocated earlier a problem according to plan of service, and it ceased, without dared
http://www.sql.ru/forum/1277014/ne-rabo … et-nikakoy

9

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Yasha123, I described a problem with the service plan. Did not help up to the end with the decision. Passwords did not change, there all is described.
Yes, I am not able to write scripts on SQL. Today I will try on a test server.
I do not know about reliability of another's scripts. Considered that if SQL at all identical, and the decision of a normal problem, such as creation .bak, from normal basis without everyones , and automatically, at night, on time the typical decision here is necessary is necessary, and the normal script, as well as a dial-up of simple, general-purpose commands in CMD approaches.
If it is a forum SQL.ru and here I cannot find the decision what for me to write on infostart on 1. Whether to remain on Effector Sever that then?!
Then it is possible, here do not solve such simple questions.

10

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Gladchenko wrote:

No Ola Helengrin tests the code how it do in Microsoft.

Forgive, but too nobody tests your code as it you do in Microsoft, and it probably on  ? 8-o

11

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Roman_915 wrote:

Yasha123, I described a problem with the service plan. Did not help up to the end with the decision. Passwords did not change, there all is described.

Yes, I remember this subject.
You changed to the agent service account?
I more did not have a desire with you to communicate for if you tried, but did not unsubscribe, it simply egoism but even if did not try,  to you generally to advise?

12

Re: Advise a simple method of reserve copying of bases SQL of 2014 64 bits without the plan

Roman_915 wrote:

Yes, I am not able to write scripts on SQL.

Write on 1 then.