Viewing 15 posts - 1 through 15 (of 31 total)
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...
October 28, 2016 at 12:05 am
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...
October 21, 2016 at 8:21 am
SQLKnowItAll (10/19/2016)Is all of the hardware and configurations between the nodes exactly the same? Down to disk level? Drive letters? Sector size, offset, allocation unit on each disk?
No, they are...
October 21, 2016 at 8:07 am
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...
October 19, 2016 at 5:23 am
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...
October 18, 2016 at 4:46 pm
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...
May 8, 2016 at 7:06 am
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...
March 5, 2013 at 3:32 pm
Here is a link related to Creating a database snapshot.
You can go ahead a create a snapshot based on the Mirrored Database that you have (in...
January 28, 2013 at 10:15 pm
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...
January 28, 2013 at 12:02 pm
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!
January 11, 2013 at 2:07 pm
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...
November 23, 2010 at 2:38 pm
Temecula, California is where I'm at.
I'll send a message to 'TheSQLGuru' per your high recommendation.
Thanks a lot!
November 17, 2010 at 2:01 pm
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...
November 17, 2010 at 1:01 pm
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...:( )
November 17, 2010 at 12:01 pm
In the bcp command, I have tried -t"," but this does not work.
What is the error you are getting? I have tried to use the -t"," doing a...
November 16, 2010 at 6:53 pm