I see.

If the application crashes or something you still need a response to the database whether a call to a customer is finished or not. Otherwise a customer could be...

hi,

now the situation is easier to understand 🙂

Question left for me: what is DR?

As I am new in the topic of "Always On" I summarize to be sure I understand...

another lesson learned 🙂

The only way I know is this: right click on one of the tabs and choose "new horizontal group" or "new vertial group". When having two or more "sectors" you...

Hi,

GilaMonster gave a very professional answer. As I think you are a beginner I add some aspects on using a very low level explanation:

Clustered Index:

A table is stored on...

hi,

I think it's NOT a good idea. I think you try to solve concurrency issues that are already part of the database engine of sql server. I think you did...

hi,

to be honest I don't understand your question...

Tell us the following:

What is your current target?

What was the situation you started from?

What was the way to achieve your target? Provide us...

You said you made a backup. Ok.

But what action exactly did raise your error? The backup-operation or something else?

Please provide your script too.

That's a very good point. Partitioning can...

All the jobs are running at the distributor.

First, have a look at the SQL-Jobs at the distributor via the "job activity monitor". There, in one of the columns, you can...

msdb is a database itself, it's one of the system databases.

There your have the tables dbo.sysjobs, db.sysjobsteps and dbo.sysjobhistory for getting information about jobs that run.

You are right. I did not even recognise this mistake. So the question is where the 54 minutes come from?

Seems that the SSIS package, that you use for backup, could not be loaded.

How do you save your SSIS-Packages, file system or msdb database? Was the file system or the...

I think you want to use transactional replication. In this case the replication only works in 1 direction (publisher to subscriber) unless you explicitly configure bidirectional replication.

Just a hint when using strings for using date values:

You should always use the format YYYYMMDD, so '20130601'. This format is not depending on the language setting.

If you write it...