Viewing 15 posts - 1 through 15 (of 35 total)
Found out that rolling upgrade is not supported within Windows Cluster for different versions of OS, So this is not an option.
Please do let me know if you guys have...
October 30, 2014 at 11:34 am
One error noticed when the article was removed & added manually on the 2 servers was...
the concurrent snapshot for the publication '' is not available because it has not been...
January 28, 2013 at 5:43 pm
I have had posted the same question on MSDB hoping for some moderators to reply. Received reply, however still not resolved totally as it says
"grant write permissions to the COM...
October 26, 2012 at 10:29 am
The ghost record not getting deleted issue is resolved. We opened a case with Microsoft and below are a brief description of what we did. Please do not be surprised...
July 26, 2012 at 10:57 pm
We have opened a case with MSFT. I will update one we have a finding. In the meanwhile please do let me know if you guys have any other suggestion...
July 23, 2012 at 11:28 am
All the 5 servers are running Win 2008 R2 Virtual on VmWare, with similar hardware i..e 8 CPU, 16 GB RAM & similar (data, log, teampdb) disks on same SAN...
July 20, 2012 at 11:20 pm
All the SQL Instances are 9.0.5266, The result of DBCC TRACESTATUS (-1) is the same on all i.e. no global trace flags set.
July 20, 2012 at 3:45 pm
- I confirm from the behavior i see that running the select alone does not reduce the number of ghost records at all. running it with update stats helps once.
-...
July 20, 2012 at 4:00 am
Simple test would be to try connecting to sql i..e if your server name is SQLSSCSRV, then try connecting from SSMS using "SQLSSCSRV,5678" & "SQLSSCSRV,2932".
- When sql is using dynamic...
July 19, 2012 at 7:22 pm
The size of the DB from sp_helpdb is quite different from the actual size i..e the size being used which would be the main consideration for backup's.
- Please compare...
July 19, 2012 at 7:15 pm
Anyone, Please even if you do not know whats causing this, please throw out ideas on what might be causing this and what else would we need to check for....
July 19, 2012 at 7:01 pm
Here is what I found from the information you provided.
Running update stats on the table does help in decreasing the number of ghost rows, however its temporary i.e. the rowcount...
July 19, 2012 at 5:24 pm
I am pretty sure its not working as expected, as the other 4 servers with same configuration do not seem to have this issue. The clustered index on this table...
July 19, 2012 at 2:55 pm
I think i found the issue. The below article describes the same to also execute sp_articleview and sp_articlefilter
"Is the stored procedure (created with FOR REPLICATION) used to filter the table...
November 11, 2011 at 12:04 pm
Has anyone seen this issue earlier, waiting for a reply.
November 11, 2011 at 9:31 am
Viewing 15 posts - 1 through 15 (of 35 total)