Viewing 15 posts - 16 through 30 (of 89 total)
[font="Courier New"]I had to include the Partitioned column as part of the Primary Key the following changes to make the SWITCH work. I forgot to include the Partition Scheme as...
March 19, 2010 at 6:27 pm
[font="Courier New"]--XXXXXXXXXX Main table Creation --XXXXXXXXXXXXXX
USE [PRTNTST]
GO
DROP PARTITION SCHEME my_psch2
GO
DROP PARTITION FUNCTION my_pfn2
GO
CREATE PARTITION FUNCTION my_pfn2(datetime2)
AS RANGE RIGHT FOR VALUES
( '20100401' --Before Apr 2010
, '20100501' --May 2010
, '20100601'...
March 19, 2010 at 4:29 pm
[font="Courier New"][font="Courier New"]Thanks for all who responded to my earlier question.
This is what i was looking. It took me a while to come up with this script. I am...
March 10, 2010 at 3:25 pm
This only gives the name, function_id, type , type_desc , fanout, boundary_value_on_right etc. How do i regenerate partition function script from the database like the one i ran above?
Thanks
March 2, 2010 at 11:56 am
Found the solution. The trick is to use sp_add_article , sp_addsubscription with the latest LSN. It should not result in duplicates being geneated (-SkipError "2627" can then be used).
I am...
February 15, 2010 at 1:19 pm
<Check this>
If for some reason you would need to drop the publisher and recreate it , then you would need to go with 'Keep Existing Objects' in the Article properties...
February 11, 2010 at 11:27 am
I agree with George. You can configure your log shipping in such a way that
it first writes to the Local/Primary server; Mention another directory in
the Standby server where the Copy...
January 28, 2010 at 2:57 pm
I am too testing Transactional Replication Backup / Restore. What are the other options?
Scenario 1:
My publisher DB is running but for some reason i need to restore.
In this scenario, i...
January 28, 2010 at 2:51 pm
Fine, i am back to square one. The problem re-surfaced again. Have anyone tried pssdiag in SQL Server 2008? I am not seeing one available on line. Only for SS2005...
January 25, 2010 at 6:35 pm
Thanks for the script. When i cut and paste the first SQL
(SELECT @@ServerName AS ServerName, ...
...
...
WHERE DATEADD(SECOND,X.checkrun,A.next_run) < GETDATE()
...
January 25, 2010 at 2:37 pm
The retry option at the Pull Subscription agent seems to take care of this. The following articles might be of help.
PRB: Log Reader Agent Does Not Function and You Receive...
January 20, 2010 at 6:25 pm
Steve Jones - Editor (9/17/2009)
January 7, 2010 at 7:00 pm
I found this URL as a good reference point.
Thanks for all those who answered.
December 21, 2009 at 4:24 pm
Forgive my ignorance. I understand that the index is moved to the desired filegroup (index file group). But is the data also in the same index file group? I don't...
December 21, 2009 at 1:58 pm
Roy
Thanks for the ideas.The following needed to be done to over come the issue.
1. SkipError 2627
2. On the Publisher i had to run sp_addsubscription with @sync_type =...
November 9, 2009 at 12:32 pm
Viewing 15 posts - 16 through 30 (of 89 total)