Yeps, that was it. I have to flip it and flip it back.

Although it says it was enabled in the configuration, there were 2 traces with no...

Try to use this script to find out the logs that you may need to restore to the target. Looks like there is a backup job is running while...

No, they are...

Well not entirely no information. Not even tagged an Error, just an information. I would pretty much appreciate any additional information.

For now, this IS the information:

"Always On Availability Groups...

Nothing really. The dashboard just says Not Synchronizing. The error log is simply that message. No prior message of what it could've been. Space is all...

Has this been resolved? I am having same issue and I stumbled to this thread.

Same exact issue: LOG and BACKUPS occurring only on PRIMARY. 4...

I am seeing this same issue. I was trying to evaluate to make a switch from using Event Notification and going through Extended Events due to the "multiple-victim" scenario...

Here is a link related to Creating a database snapshot.

http://msdn.microsoft.com/en-us/library/ms175876(v=sql.105).aspx

You can go ahead a create a snapshot based on the Mirrored Database that you have (in...

That is correct, you cannot use the mirrored database *directly*.

However, you can create a snapshot of your mirrored database and have the report pointed to that Snapshot database (different...

Fantastic, great , excellent article! Great way of explaining normalization in a not-so-technical manner but in a way so easily understood even by beginners!

Thanks a lot!

I was already using that reference with regards to the Profiler use. The mistake I did was the application of filter. I was filtering the...

Temecula, California is where I'm at.

I'll send a message to 'TheSQLGuru' per your high recommendation.

Thanks a lot!

Thanks Gail,

Is the trigger necessary? Unfortunately, the answer is yes. And it's even cascading... (Cringes) 🙁

Currently, that's one of the goals I am hoping to accomplish, being...

fortunately (or unfortunately), i already have that flag turned on, and already have the deadlock graph ready to be posted here. Here goes (one of the many deadlocks...:( )

<deadlock-list>

...

What is the error you are getting? I have tried to use the -t"," doing a...