Viewing 15 posts - 916 through 930 (of 1,157 total)
I like to compare DBA's to car mechanics. A car mechanic is responsible for the maintenance, performance and running of a car. He can spot design faults and...
June 28, 2011 at 1:18 am
I think you're mixed up. NO RECOVERY leaves a database in Restoring status and therefore inaccessible.
Specifying this option when restoring a backup with the NORECOVERY option is not...
June 27, 2011 at 8:24 am
mtassin (6/27/2011)
MysteryJimbo (6/25/2011)
4. Restore...
June 27, 2011 at 7:04 am
Jayanth_Kurup (6/27/2011)
The definition of high availability below hardly applies to replication I think.
A high-availability...
June 27, 2011 at 4:45 am
Chuck is right. You cant change this without rebuilding the publication.
June 27, 2011 at 4:07 am
I'd recommend at least having 3 instances installed somewhere (like your desktop) so you can have a play and test this.
I've do it fairly regularly, but I always have a...
June 27, 2011 at 4:06 am
Jayanth_Kurup (6/27/2011)
June 27, 2011 at 3:53 am
Are you going to backup/restore? Logship? Detach/Reattach?
In all methods, you will need a downtime slot to prevent any database updates.
You then need to:
1. script the drop replication scripts (subscribers/articles/publications/drop...
June 27, 2011 at 3:45 am
It's pretty different but not overly complicated
How do you plan on performing the upgrade?
June 26, 2011 at 10:09 am
in theory, provided you disable the log reader agent and allow the distribution agent(s) to complete its run before disabling them you could get away with this.
This is what I...
June 25, 2011 at 7:17 am
croberts 36762 (6/24/2011)
We use the custom counter feature in Idera DM, too. It can really add to the functionality for those things that may be specific to your site.
Thats an...
June 24, 2011 at 10:12 am
paul.corujo (6/24/2011)
June 24, 2011 at 10:06 am
I'm not sure why you would want to failover due to high resource consumption. This would terminate all existing SQL sessions.
You "could" setup a scheduled Powershell script to do...
June 24, 2011 at 9:23 am
I agree with Grant.
Agile done badly or misunderstood it can be a complete nightmare. Done correctly, it works like a dream and after the base schema is in place...
June 20, 2011 at 8:48 am
You can still add columns to articles with "replicate ddl" off using sp_repladdcolumn.
If you wish to change the primary key but not reinitialise the article, arrange an downtime slot with...
June 16, 2011 at 1:05 pm
Viewing 15 posts - 916 through 930 (of 1,157 total)