another table corruption question

sql2k sp3
Is there a way to just narrow down the rows of data that are corrupted and
delete them as opposed to the other alternatives? (Restore, CheckTable with
Repair%, etc.)
TIA, ChrisR.There are many types of corruption. The page could be bad. So it is not
always possible to delete the bad row.
--
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"ChrisR" <noemail@.bla.com> wrote in message
news:eDCAX%23nSFHA.576@.TK2MSFTNGP15.phx.gbl...
> sql2k sp3
> Is there a way to just narrow down the rows of data that are corrupted and
> delete them as opposed to the other alternatives? (Restore, CheckTable
> with Repair%, etc.)
>
> TIA, ChrisR.
>
>

Anonymous Pull using FTP - still insists on using original UNC for file share

I've been trying to set up an anonymous pull subscription for merge
replication - SQL 2000 on both sides, post SP3 & same on both machines.
However, when I set up the replication and try to do the initial sync, the
subscription insists on trying to use the original UNC path where I stored the
files from the publisher. Copying the files locally doesn't seem to help as
it still tries to access the UNC. Same with FTP - I set up the site &
specified to use it, but it still tries to access the UNC that way. I
verified that it can access the files via FTP and even copied the files
locally to specify a local path.
I tried reading through the BOL, but didn't come up with much to guide me on
what to try next to get it to read the local files. Any suggestions? This is
the only subscriber I'll have, but it's not on the domain and in our DMZ.
Thanks for any ideas you may have.
-Pete Schott
the connection information on how the subscriber connects with the publisher
to pull the subscription is stored on the publisher.
Do a sp_helpmergepublication 'PublicationName' in your publication database
to verify the publication is 1) enabled for the internet 2) has an alternate
snapshot folder that maps to the root or a virtual directory on your ftp
server, 30 has an ftp address
I take it when you created your pull subscription you chose to download your
files using ftp?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Peter A. Schott" <pschott@.no.spamm.hear.drivefinancial.com> wrote in
message news:1qrpc01577kh0g5vsfcvl7r00ioc4d6scg@.4ax.com...
> I've been trying to set up an anonymous pull subscription for merge
> replication - SQL 2000 on both sides, post SP3 & same on both machines.
> However, when I set up the replication and try to do the initial sync, the
> subscription insists on trying to use the original UNC path where I stored
the
> files from the publisher. Copying the files locally doesn't seem to help
as
> it still tries to access the UNC. Same with FTP - I set up the site &
> specified to use it, but it still tries to access the UNC that way. I
> verified that it can access the files via FTP and even copied the files
> locally to specify a local path.
> I tried reading through the BOL, but didn't come up with much to guide me
on
> what to try next to get it to read the local files. Any suggestions?
This is
> the only subscriber I'll have, but it's not on the domain and in our DMZ.
> Thanks for any ideas you may have.
> -Pete Schott
|||Well, I did that - it's enabled for Internet, has an alternate snapshot
folder, and the folder maps to the root of the virtual/ftp directory. It's
able to pull several of the files, but then dies trying to get to the full UNC
path.
It does the same thing if I specify to use an alternate/local path instead. I
can't seem to get away from that UNC. at all.
Any ideas? Has anyone got some steps that work all of the time to apply an
initial snapshot anonymously over FTP?
TIA,
-pete
"Hilary Cotter" <hilaryk@.att.net> wrote:

> the connection information on how the subscriber connects with the publisher
> to pull the subscription is stored on the publisher.
> Do a sp_helpmergepublication 'PublicationName' in your publication database
> to verify the publication is 1) enabled for the internet 2) has an alternate
> snapshot folder that maps to the root or a virtual directory on your ftp
> server, 30 has an ftp address
> I take it when you created your pull subscription you chose to download your
> files using ftp?
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Peter A. Schott" <pschott@.no.spamm.hear.drivefinancial.com> wrote in
> message news:1qrpc01577kh0g5vsfcvl7r00ioc4d6scg@.4ax.com...
> the
> as
> on
> This is
>

Analysis Services Cube Processing Timing

We are currently using Analysis Services 2000 sp3 on Windows 2003 sp1. We have a large cube that is partitioned and is processed nightly using Parallel Processing utility.

It takes over 4 hours to process that cube, however if the processing is killed after first few minutes and then Olap server is restarted and the cube processing is restarted it only takes 55 minutes.

Has anybody encountered similar situation?

Thank you,

Alex

Looks like you are hitting a timing issue. Try changing number of partitions you process in parallel.

You can also try and upgrade to the latest service pack ( SP4 ).

If still doesn't help, please open a case with Customer Support.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.