The basic statements you need are the following:

restore database xy from disk = 'g: c:\fullbackup\dec\fullbackup_dmmyyyy.bak' with norecovery

restore database xy from disk = 'g: D:\Difbackup\Dec\Diffbackup_ddmmyyyy.bak' with norecovery

restore database xy from disk...

I never saw this error before so I just can guess.

The error tells you the table syspublications not existing. This is a system table that gets created when marking the...

-- declare the variables

declare @custname is varchar(30)

,@custnumber is varchar(10)

,@custstate is varchar(02)

;

-- set values for the variables

set @custname = 'SomeName';

set @custnumber = '0012345';

set @custstate =...

For the job's I cannot say anything else, did not do it myself 😉

As for the PS, have a look at the section Log Reader Agent Modifications HERE

The LogReaderAgent is...

hi,

for adding the jobs i guess that this special procedure updates the user databases too. As on a secondary the databases of the availability group are write protected i guess...

I do have a natural PK. The only difficulty is: one of these columns is nullable. So I cannot create the PK constraint.

The question is: do I add a artificial...

I would not call it useless. I personally like to have a look at the columns "user_seeks" and "last_user_seek". High numbers are an indicator that I should have a look...

The apply-operator was introduced to "join" the result of a function to a resultset. That was not possible before the apply-operator.

When using a table expression for joining there is no...

Why do you need that at all?

The main difference between the join and the apply operator is that the apply operator can be used to "join" the result from a function.

If you use the apply-operator using...

I think "add poll" is the wrong command for you. It's for asking a question and let the people vote.

Try to use "add topic" and ask your question again. The...

Actually it does not really matter on which database you connect initially.

When referencing tables (or any other database objects) you can youse a 3-part-name where the first part defines the...

I cannot imagine the sense of this requirement.

Maybe you could deny the select permission to all tables and grant the select permission on the one that should be selected.

Depending on...

Be sure that the GUI of the management studio is refreshed.

Check that the database is not part of another availiability group.

Really? As far as I know the standard behavior is that an exception...