1

Topic: Scheduled outswapping MSSQL 2008 does not work

Good afternoon experts SQL!!!
Here such problem is.
I create the plan of service of basis with outswapping during certain time all perfectly forms, but at sanity check through
Agent SQL in Jobs - to Launch the job for a step writes an error (an attachment 1 file), we look log the following screen I apply.
Who can faced such trouble?

2

Re: Scheduled outswapping MSSQL 2008 does not work

Too big screen, make more small.

3

Re: Scheduled outswapping MSSQL 2008 does not work

Malayez, select basis on which the step in  should be fulfilled.

4

Re: Scheduled outswapping MSSQL 2008 does not work

Minamoto and as on another I also select it

5

Re: Scheduled outswapping MSSQL 2008 does not work

Gavrilenko Sergey Alekseevich;
Here so?

6

Re: Scheduled outswapping MSSQL 2008 does not work

Buttons Ctrl+C/Ctrl+V master, aha.
What to you it is not clear in the message? That basis in which you adjusted performance, it is inaccessible.

7

Re: Scheduled outswapping MSSQL 2008 does not work

Malayez wrote:

Minamoto and as on another I also select it

You do not select, and launch. She is selected from plan adjustments. Show adjustments of the plan and a screenshot of the list of bases.

8

Re: Scheduled outswapping MSSQL 2008 does not work

Gavrilenko Sergey Alekseevich and how it is inaccessible? Bases are twisted all works.

9

Re: Scheduled outswapping MSSQL 2008 does not work

Minamoto, all the same it is impossible

10

Re: Scheduled outswapping MSSQL 2008 does not work

Malayez;
Here here your problem with SA  directly in pictures. Study, repair smile

11

Re: Scheduled outswapping MSSQL 2008 does not work

Andy_OLAP;
And in my opinion this problem "UNCHECK the Enforce password policy checkbox" is called...

12

Re: Scheduled outswapping MSSQL 2008 does not work

Andy_OLAP wrote:

Andy_OLAP;
And in my opinion this problem "UNCHECK the Enforce password policy checkbox" is called...

Aha, certainly.
Time in that subject under the link was Password did not match that for the login provided ;
And in this Failed to open the explicitly specified database ;
That the tablet from a diarrhea (UNCHECK the Enforce password policy checkbox) prevents nobody and even cures

13

Re: Scheduled outswapping MSSQL 2008 does not work

The moderator: Malayez, all following screenshots will be erased on a place. Learn to copy the text.

14

Re: Scheduled outswapping MSSQL 2008 does not work

Yasha123 wrote:

it is passed...
Aha, certainly.
Time in that subject under the link was Password did not match that for the login provided ;
And in this Failed to open the explicitly specified database ;
That the tablet from a diarrhea (UNCHECK the Enforce password policy checkbox) prevents nobody and even cures

The colleague if you it is attentive look at all article it is doubtless on one of screenshots see default database = master, it is assured that at the author of a subject the missing DB there is written down.
But to it to correct at once everything, as to usage  sa. Therefore it needs all article entirely. But you certainly can not read it . I will not object.

15

Re: Scheduled outswapping MSSQL 2008 does not work

Yasha123 wrote:

that the tablet from a diarrhea prevents nobody

! Here see, how quickly you began to change the relation from rigid requirements to is exceptional true information in given links on more liberal and humane when it is possible for the author of a subject and it is necessary not to chew food, and to give  in the necessary direction, in advance whenever possible specifying to it and in nuances accompanying its problem which he can soon come across and again come on a forum with a new subject.
And here we  kill two kosher hares.

16

Re: Scheduled outswapping MSSQL 2008 does not work

Andy_OLAP wrote:

it is passed...
! Here see, how quickly you began to change the relation from rigid requirements to is exceptional true information in given links on more liberal and humane when it is possible for the author of a subject and it is necessary not to chew food, and to give  in the necessary direction, in advance whenever possible specifying to it and in nuances accompanying its problem which he can soon come across and again come on a forum with a new subject.
And here we  kill two kosher hares.

Everything, my forces are not present.
But when the HARDWARE comes running again and tells that instead of two kosher hares at it a hose from a vest and ears of a dead donkey in addition, I will answer it: it is time to distinguish already made answers from a hole from a donut