Viewing 15 posts - 136 through 150 (of 1,270 total)
There's no guarantee that reverting to the snapshot will work. I just tested it on a corrupt database (I have several laying around) where I created a snapshot, ran repair_allow_data_loss,...
November 4, 2012 at 4:20 pm
How quickly do you need to have it fixed? If there is enough time, I'd restore a backup to a test server and run repair there first to see how...
November 4, 2012 at 3:04 pm
What is your status for log backups? In order to do a page restore, you will need to bring those pages current with the rest of the database, and that...
November 4, 2012 at 1:58 pm
What if you reverse the configuration? If you change which server has multiple log files, does the performance on the servers stay the same or does it also switch to...
October 26, 2012 at 7:07 am
Process Monitor (ProcMon) from sysinternals may be able to kill the thread to backup file. Restarting SQL will definitely kill it and may be your only recourse if ProcMon doesn't...
October 23, 2012 at 3:15 pm
Hi Matt. There is actually a very high presence of Idera people on Twitter including product developers, members of R&D, sales, evangelists, and so forth.
Here are a few to get...
October 22, 2012 at 11:41 am
That's a common sentiment, Paul. Definitely, knowing what to expect makes a big difference. When I was the PM for the program, I wanted to create sample exams for people,...
October 22, 2012 at 10:26 am
Describe "disconnected principal server". The mirror thinks it is still connected.
October 10, 2012 at 10:20 pm
GilaMonster (10/8/2012)
But no data loss possible if the mirroring was synchronised at point of failure, and no possibility of data loss when failing back?
Correct. If it was synchronized, there will...
October 8, 2012 at 10:49 am
Perry is correct. If the principal is down and you don't have automatic failover configured, you have to use FORCE_SERVICE_ALLOW_DATA_LOSS to bring the mirror online.
After the principal comes back up,...
October 8, 2012 at 10:05 am
Your first line is right. It does depend. There is no single right answer. However, in general, I don't think anyone sets out to be a top expert in certain...
October 7, 2012 at 10:44 pm
I don't know if this is still an open issue or not, but if it is and you want help interviewing and identifying the right candidate, I know an independent...
October 7, 2012 at 10:26 pm
Good luck to both of you!
In case anyone didn't see this and is interested in taking one of the MCM exams at the SQL PASS Summit, take a look at...
October 6, 2012 at 8:52 am
Gail's point is important. There's probably a lot someone could get through on the lab exam by simply looking it up in BOL. But not with limited time. It's great...
October 5, 2012 at 11:59 am
Best of luck Paul! Get a good night's sleep the night before. That's more important than trying to get in a few more hours of studying.
October 5, 2012 at 8:37 am
Viewing 15 posts - 136 through 150 (of 1,270 total)