Viewing 15 posts - 571 through 585 (of 1,158 total)
So you are adding an article to a publication where the object already exists on the subscriber?
You can change the default action on adding an article to something other than...
February 7, 2012 at 7:35 am
Best practice to backup to disk.
This keeps the most recent backup available for a speedy restore. How often do you need last weeks backup?
Tapes are also slower in general.
February 7, 2012 at 4:11 am
If I understand correctly, you mean the before and after scripts set in a publication.
I'm not 100% on the difference between a normal and not normal snapshot!
If you mean the...
February 7, 2012 at 4:09 am
Is this a Windows 2008 and SQL2008 (r2) server?
Do you know if the windows patch levels were the same between nodes?
Were the security policy changes mirrored such as enabling Lock...
February 6, 2012 at 11:10 am
I'm really confused by this. Is the question about replication now?
February 5, 2012 at 4:11 am
A few of my thoughts. I'm not sure which would be quicker without testing. I'd hazard a guess that a SSIS package could be tweaked to be the...
February 5, 2012 at 2:46 am
These services should not effect the running of SQL Server if stopped.
February 4, 2012 at 9:05 am
First question you need to ask yourself is which recovery model suits my needs? Do you need a point in time restore or will a daily backup suffice?
If a...
February 4, 2012 at 8:58 am
I dont think that this forum is the correct place for this question. I'll point you in the direction I would look before posting such a wide ranging question
http://lmgtfy.com/?q=how+to+create+a+web+content+management+system
February 4, 2012 at 8:10 am
MysteryJimbo (2/4/2012)
February 4, 2012 at 4:27 am
I should point out that (unless someone corrects me) there are still no 64-bit excel drivers for SSIS. You will need to execute the package using the 32-bit dtexec...
February 4, 2012 at 4:27 am
There is an aggregate component which should work for you. Alternatively you should look at a staging table which you can use to summarise the data.
February 4, 2012 at 4:24 am
If you setup CDC and do some digging you will see the guts of the code is in sp_replcmds.
It is therefore using identical code to replication to scan...
February 4, 2012 at 4:12 am
Viewing 15 posts - 571 through 585 (of 1,158 total)