Viewing 15 posts - 226 through 240 (of 497 total)
Oracle_91 (2/27/2014)
Can anybody help me understand why do one go combination of Database Mirroring + Replication.
Why can't I just have Database mirroring for high availability of my database. What...
February 27, 2014 at 2:49 am
Phew! Thought I was going mad for a minute. :crazy:
February 27, 2014 at 2:20 am
Thanks for the replies folks. As JustMarie and EricEyster made opposing arguments, I guess the most important point is to be consistent!
Jeff, I don't see it as much of a...
February 27, 2014 at 2:14 am
You are trying to drop the table; that's not modifying it. The OP wanted to add a field (column)...that's what I did in my test. It's also possible to modify...
February 26, 2014 at 9:59 am
sqldba725 (2/26/2014)
You can not alter the table with out dropping and re-adding them , having distribution job running or not is irrelevant .
Err...yes you can, I've tested that scenario...
February 26, 2014 at 9:06 am
Ok, I think it must be the Distribution Agent that is set to run continuously because i've just gone through setting up Snapshot Replication between a couple of Test databases...
February 26, 2014 at 7:59 am
So is it the Distribution Agent that is running continuously? Your are definitely using Snapshot Replication and not Transactional Replication, right? How often do you generate a snapshot?
February 26, 2014 at 7:21 am
VIII (2/26/2014)
GilaMonster (2/26/2014)
Restore from a clean backup (backup taken before the corruption occurred)
I don't have clean backup. For some reason, my customer stopped weekly backup and the last backup is...
February 26, 2014 at 4:12 am
kommagoni (2/26/2014)
User databases running on the server..
Well in that case I would just live with the current install path.
Otherwise you are going to have to install a new instance...
February 26, 2014 at 4:07 am
For a snapshot publication, locks are held on the published tables for the duration of the snapshot generation process so you would not be able to modify the tables during...
February 26, 2014 at 3:49 am
As far as I know, the only way is to uninstall the instance and reinstall it in the 'correct' place, i.e. your desired filepath. Have you created user databases on...
February 26, 2014 at 3:40 am
Wow! You've certainly made some progress! I was going to take things step by step hence my initial reply, but you've done things pretty much the way I would.
As to...
February 26, 2014 at 2:57 am
Am I right to assume that you've got BIDS open and have created a new Project and now you have a blank canvas similar to what is shown in the...
February 25, 2014 at 2:17 am
ms-techie (2/23/2014)
These Jobs are INDEPENDENT of each other.
Are you sure about that?
"The process cannot access the file because it is being used by another process " and then the...
February 24, 2014 at 4:01 am
Luis Cazares (2/21/2014)
To be fair, (s)he might be in a different time zone.
True. I wasn't referring to this particular post, just making a general observation.
February 21, 2014 at 8:58 am
Viewing 15 posts - 226 through 240 (of 497 total)