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.
>
>

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.
>
>

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.
>
>

Analysis Services Migration Wizard

I backedup an SQL2K OLAP database. Learned that I can not use the cab file to restore it to an SQL2005. So I've restored it to another SQL2K. Now I am trying to migrate this to my 2005. Here are my tests and results.

1. Welcome screen works fine. :)

2. I have severel SQL2K servers here which have their OLAP services running.

a.) SQL 2000 Source Server: xxxxxxxxx (no such server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

b.) SQL 2000 Source Server: SABRI (right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

c.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: ActiveX component can't create object

d.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: xxxxxxxxx (no such server)
Error: Source server: ActiveX component can't create object

e.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: (local) (got bored of typing AATIK)
Error: Source server: ActiveX component can't create object

I've also tried "localhost", ".", "aatik", "aatik\aatik" etc. for destination server.

Is it a bug in Turkish for letters I and i ?

By the way SP1 is installed.

Thanks.

You can take destination out of the picture by specifying script file as a destination.

Looks like you are having problem connecting to AS2000 source server.

Take a look if you can access AS2000 sever remotely. Can you access it from Analysis Manager running on another machine?

You also have an option of running AS2000 and AS2005 on the same machine.
You can rename your AS2005 sever to become a named instance. Install AS2000 locally, restore your databases and then migrate a databases.
Uninstall AS2000 and then rename back AS2005 to be a default instance.

To rename AS2005 instance you can use ASInstanceRename.exe located in your C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE folder.

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

|||

Thanks Edward.

Tried the scriptfile option but again got the same ActiveX error message.

Analysis Services Migration Wizard

I backedup an SQL2K OLAP database. Learned that I can not use the cab file to restore it to an SQL2005. So I've restored it to another SQL2K. Now I am trying to migrate this to my 2005. Here are my tests and results.

1. Welcome screen works fine. :)

2. I have severel SQL2K servers here which have their OLAP services running.

a.) SQL 2000 Source Server: xxxxxxxxx (no such server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

b.) SQL 2000 Source Server: SABRI (right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

c.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: ActiveX component can't create object

d.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: xxxxxxxxx (no such server)
Error: Source server: ActiveX component can't create object

e.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: (local) (got bored of typing AATIK)
Error: Source server: ActiveX component can't create object

I've also tried "localhost", ".", "aatik", "aatik\aatik" etc. for destination server.

Is it a bug in Turkish for letters I and i ?

By the way SP1 is installed.

Thanks.

You can take destination out of the picture by specifying script file as a destination.

Looks like you are having problem connecting to AS2000 source server.

Take a look if you can access AS2000 sever remotely. Can you access it from Analysis Manager running on another machine?

You also have an option of running AS2000 and AS2005 on the same machine.
You can rename your AS2005 sever to become a named instance. Install AS2000 locally, restore your databases and then migrate a databases.
Uninstall AS2000 and then rename back AS2005 to be a default instance.

To rename AS2005 instance you can use ASInstanceRename.exe located in your C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE folder.

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

|||

Thanks Edward.

Tried the scriptfile option but again got the same ActiveX error message.

Analysis services backup and restore problem.

I'm backing up an analysis services database to an abf file and then restoring it to another database, with a different name, on the same server. However, when I process the database that I originally backed up, the cubes in the restored database are deleted?

I can only think that the objects in the database have a unique identifier and these are the same in both databases, and when I process the original database it's deleting both sets of cubes, but only rebuilding the ones in the database I'm processing.

The only way that I can think of out of this is to restore the database to another server, which I don't want to do.

Any ideas would be much appreciated.

This sounds like a bug. There is a special code during restore which is supposed to change the unique ids you refer to in order for them to stay unique. Sounds like for whatever reason in your scenario this code doesn't work.