Viewing 8 posts - 1 through 8 (of 8 total)
I suggest looking at "SQLServer:Buffer Manager" in PerfMon to see how the buffer is doing. If there are buffers being flushed out you'll see it there. You'll also see the...
November 7, 2012 at 8:02 am
tried it, the results were:
Msg 3104, Level 16, State 1, Line 1
RESTORE cannot operate on database 'ifail2' because it is configured for database mirroring or has joined an availability group....
October 29, 2012 at 7:33 am
There's a free eBook available from Microsoft
October 28, 2012 at 5:30 am
Nope, not even that is working:
Msg 3743, Level 16, State 1, Line 1
The database 'ifail2' is enabled for database mirroring. Database mirroring must be removed before you drop the database.
October 28, 2012 at 5:21 am
I'm guessing the printing is initiated by a trigger? In that case include a condition inside the trigger which initiates the printing of a second letter in cases where the...
October 26, 2012 at 9:32 am
Well, I recreated the whole situation (as I've solved the first situation by adding drive M) and this is the state after adding the new datafile, which cause the mirroring...
October 26, 2012 at 9:08 am
Nope, mirroring was removed from the principal right after mirroring was suspended. Resuming mirroring (before disabling it on the principal) was also impossible (without adding drive M to the mirror),...
October 26, 2012 at 8:56 am
Every time I try to issue the SET PARTNER OFF this gets written to the log:
"2012-10-26 07:29:21.63 spid36s Error: 5123, Severity: 16, State: 1.
2012-10-26 07:29:21.63 spid36s...
October 26, 2012 at 8:36 am
Viewing 8 posts - 1 through 8 (of 8 total)