Hi All,
Just wondering if anyone can give me some general advice on the
practical differences between rebuilding and reorganizing indexes in
sql server 2000?
Basically, we have a database that occupies approx 28gb, of which
approximately 4gb is indexes. In the 2 or so years that our app has
been using this server, the indexes have never been rebuilt /
reoganized to the best of our knowledge.
In particular, we are hoping to minimize downtime while we see to this,
so I'm wondering if anyone has any advice to give about whether a
rebuild is generally quicker than a reorganize, or vice versa?
Any help / advice appreciated!
Much warmth,
planetthoughtful
--
"lost in thought"
http://www.planetthoughtful.orgAre you talking about the difference between DBCC INDEXDEFRAG and DBCC
REINDEX?
<planetthoughtful@.gmail.com> wrote in message
news:1151475743.435319.310670@.y41g2000cwy.googlegroups.com...
> Hi All,
> Just wondering if anyone can give me some general advice on the
> practical differences between rebuilding and reorganizing indexes in
> sql server 2000?
> Basically, we have a database that occupies approx 28gb, of which
> approximately 4gb is indexes. In the 2 or so years that our app has
> been using this server, the indexes have never been rebuilt /
> reoganized to the best of our knowledge.
> In particular, we are hoping to minimize downtime while we see to this,
> so I'm wondering if anyone has any advice to give about whether a
> rebuild is generally quicker than a reorganize, or vice versa?
> Any help / advice appreciated!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>|||This article is for 2000, but the essentials applies to 2005 as well. DBREINDEX is REBUILD and
INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE only).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<planetthoughtful@.gmail.com> wrote in message
news:1151475743.435319.310670@.y41g2000cwy.googlegroups.com...
> Hi All,
> Just wondering if anyone can give me some general advice on the
> practical differences between rebuilding and reorganizing indexes in
> sql server 2000?
> Basically, we have a database that occupies approx 28gb, of which
> approximately 4gb is indexes. In the 2 or so years that our app has
> been using this server, the indexes have never been rebuilt /
> reoganized to the best of our knowledge.
> In particular, we are hoping to minimize downtime while we see to this,
> so I'm wondering if anyone has any advice to give about whether a
> rebuild is generally quicker than a reorganize, or vice versa?
> Any help / advice appreciated!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>|||Uri Dimant wrote:
> Are you talking about the difference between DBCC INDEXDEFRAG and DBCC
> REINDEX?
Hmmm. According to BOL (admittedly the one that comes with SQL Server
Express 2005), I can use, for example:
ALTER INDEX PK_tReturns ON dbo.tReturns REORGANIZE;
or:
ALTER INDEX PK_tReturns ON dbo.tReturns REBUILD;
...to reoagnize or rebuild respectively.
Is this not the case? The server in question is a production SQL Server
2000 server.
Thanks for your reply!
Much warmth,
planetthoughtful
--
"lost in thought"
http://www.planetthoughtful.org|||Tibor Karaszi wrote:
> This article is for 2000, but the essentials applies to 2005 as well. DBREINDEX is REBUILD and
> INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE only).
Hi Tibor,
Sorry, which article, exactly? Were you intending to include a link?
Thanks for your reply!
Much warmth,
planetthoughtful
--
"Lost in thought"
http://www.planetthoughtful.org|||Sorry, here's the URL: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<planetthoughtful@.gmail.com> wrote in message
news:1151478465.492923.232660@.i40g2000cwc.googlegroups.com...
> Tibor Karaszi wrote:
>> This article is for 2000, but the essentials applies to 2005 as well. DBREINDEX is REBUILD and
>> INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE only).
> Hi Tibor,
> Sorry, which article, exactly? Were you intending to include a link?
> Thanks for your reply!
> Much warmth,
> planetthoughtful
> --
> "Lost in thought"
> http://www.planetthoughtful.org
>|||ALTER INDEX is not available in SQL 2000; it is new for SQL 2005.
USE DBCC REINDEX to rebuild and DBCC INDEXDEFRAG to reorganize, and then the
article Tibor provided is perfectly relevant.
--
HTH
Kalen Delaney, SQL Server MVP
<planetthoughtful@.gmail.com> wrote in message
news:1151478353.212906.225050@.i40g2000cwc.googlegroups.com...
> Uri Dimant wrote:
>> Are you talking about the difference between DBCC INDEXDEFRAG and DBCC
>> REINDEX?
> Hmmm. According to BOL (admittedly the one that comes with SQL Server
> Express 2005), I can use, for example:
> ALTER INDEX PK_tReturns ON dbo.tReturns REORGANIZE;
> or:
> ALTER INDEX PK_tReturns ON dbo.tReturns REBUILD;
> ...to reoagnize or rebuild respectively.
> Is this not the case? The server in question is a production SQL Server
> 2000 server.
> Thanks for your reply!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>|||Hi Tibor,
One quick question.
The option which is available on Maintenance plan (under
optimizations->Reorganize data and index pages), will it perform both rebuild
and reorganize...
Does this maintenence plan optimization activity replaces both DBREINDEX and
INDEXDEFRAG operations?
Regards,
Jaison
"Tibor Karaszi" wrote:
> Sorry, here's the URL: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <planetthoughtful@.gmail.com> wrote in message
> news:1151478465.492923.232660@.i40g2000cwc.googlegroups.com...
> >
> > Tibor Karaszi wrote:
> >> This article is for 2000, but the essentials applies to 2005 as well. DBREINDEX is REBUILD and
> >> INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE only).
> >
> > Hi Tibor,
> >
> > Sorry, which article, exactly? Were you intending to include a link?
> >
> > Thanks for your reply!
> >
> > Much warmth,
> >
> > planetthoughtful
> > --
> > "Lost in thought"
> > http://www.planetthoughtful.org
> >
>|||Maint plan in 2000 executes DBCC DBREINDEX. Doing both DBREINDEX and also INDEXDEFRAG isn't
necessary. Also, Maint Plan doesn't first check the fragmentation, so it is likely that it does a
whole lot of unnecessary rebuilds. In Books Online, DBCC SHOWCOINTIG, you have code that you can use
in a job which only defragments the indexed with a fragmentation level over a certain threshold.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jaison Jose" <JaisonJose@.discussions.microsoft.com> wrote in message
news:B1DF0D93-7F2F-4D74-B207-2879B91A85AB@.microsoft.com...
> Hi Tibor,
> One quick question.
> The option which is available on Maintenance plan (under
> optimizations->Reorganize data and index pages), will it perform both rebuild
> and reorganize...
> Does this maintenence plan optimization activity replaces both DBREINDEX and
> INDEXDEFRAG operations?
> Regards,
> Jaison
> "Tibor Karaszi" wrote:
>> Sorry, here's the URL:
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> <planetthoughtful@.gmail.com> wrote in message
>> news:1151478465.492923.232660@.i40g2000cwc.googlegroups.com...
>> >
>> > Tibor Karaszi wrote:
>> >> This article is for 2000, but the essentials applies to 2005 as well. DBREINDEX is REBUILD and
>> >> INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE only).
>> >
>> > Hi Tibor,
>> >
>> > Sorry, which article, exactly? Were you intending to include a link?
>> >
>> > Thanks for your reply!
>> >
>> > Much warmth,
>> >
>> > planetthoughtful
>> > --
>> > "Lost in thought"
>> > http://www.planetthoughtful.org
>> >
>>|||Thanks a lot Tibor...
"Tibor Karaszi" wrote:
> Maint plan in 2000 executes DBCC DBREINDEX. Doing both DBREINDEX and also INDEXDEFRAG isn't
> necessary. Also, Maint Plan doesn't first check the fragmentation, so it is likely that it does a
> whole lot of unnecessary rebuilds. In Books Online, DBCC SHOWCOINTIG, you have code that you can use
> in a job which only defragments the indexed with a fragmentation level over a certain threshold.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Jaison Jose" <JaisonJose@.discussions.microsoft.com> wrote in message
> news:B1DF0D93-7F2F-4D74-B207-2879B91A85AB@.microsoft.com...
> > Hi Tibor,
> > One quick question.
> >
> > The option which is available on Maintenance plan (under
> > optimizations->Reorganize data and index pages), will it perform both rebuild
> > and reorganize...
> > Does this maintenence plan optimization activity replaces both DBREINDEX and
> > INDEXDEFRAG operations?
> >
> > Regards,
> > Jaison
> >
> > "Tibor Karaszi" wrote:
> >
> >> Sorry, here's the URL:
> >> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> <planetthoughtful@.gmail.com> wrote in message
> >> news:1151478465.492923.232660@.i40g2000cwc.googlegroups.com...
> >> >
> >> > Tibor Karaszi wrote:
> >> >> This article is for 2000, but the essentials applies to 2005 as well. DBREINDEX is REBUILD and
> >> >> INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE only).
> >> >
> >> > Hi Tibor,
> >> >
> >> > Sorry, which article, exactly? Were you intending to include a link?
> >> >
> >> > Thanks for your reply!
> >> >
> >> > Much warmth,
> >> >
> >> > planetthoughtful
> >> > --
> >> > "Lost in thought"
> >> > http://www.planetthoughtful.org
> >> >
> >>
> >>
>|||planetthoughtful@.gmail.com wrote:
> Hi All,
> Just wondering if anyone can give me some general advice on the
> practical differences between rebuilding and reorganizing indexes in
> sql server 2000?
> Basically, we have a database that occupies approx 28gb, of which
> approximately 4gb is indexes. In the 2 or so years that our app has
> been using this server, the indexes have never been rebuilt /
> reoganized to the best of our knowledge.
> In particular, we are hoping to minimize downtime while we see to this,
> so I'm wondering if anyone has any advice to give about whether a
> rebuild is generally quicker than a reorganize, or vice versa?
> Any help / advice appreciated!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>
Have a look at the stored procedure I've posted here:
http://www.realsqlguy.com/?p=10
Schedule this to run nightly, or whenever you have quiet time in your
database that will permit reindexing activity.|||Tracy McKibben wrote:
> planetthoughtful@.gmail.com wrote:
>> Hi All,
>> Just wondering if anyone can give me some general advice on the
>> practical differences between rebuilding and reorganizing indexes in
>> sql server 2000?
>> Basically, we have a database that occupies approx 28gb, of which
>> approximately 4gb is indexes. In the 2 or so years that our app has
>> been using this server, the indexes have never been rebuilt /
>> reoganized to the best of our knowledge.
>> In particular, we are hoping to minimize downtime while we see to this,
>> so I'm wondering if anyone has any advice to give about whether a
>> rebuild is generally quicker than a reorganize, or vice versa?
>> Any help / advice appreciated!
>> Much warmth,
>> planetthoughtful
>> --
>> "lost in thought"
>> http://www.planetthoughtful.org
> Have a look at the stored procedure I've posted here:
> http://www.realsqlguy.com/?p=10
> Schedule this to run nightly, or whenever you have quiet time in your
> database that will permit reindexing activity.
>
Sorry, if you pulled down that script, there is a bug in it,
search/replace went awry... The correction is posted at the URL above...
Showing posts with label mssql2k. Show all posts
Showing posts with label mssql2k. Show all posts
Friday, March 9, 2012
mssql2k: rebuilding vs reorganizing indexes?
Are you talking about the difference between DBCC INDEXDEFRAG and DBCC
REINDEX?
<planetthoughtful@.gmail.com> wrote in message
news:1151475743.435319.310670@.y41g2000cwy.googlegroups.com...
> Hi All,
> Just wondering if anyone can give me some general advice on the
> practical differences between rebuilding and reorganizing indexes in
> sql server 2000?
> Basically, we have a database that occupies approx 28gb, of which
> approximately 4gb is indexes. In the 2 or so years that our app has
> been using this server, the indexes have never been rebuilt /
> reoganized to the best of our knowledge.
> In particular, we are hoping to minimize downtime while we see to this,
> so I'm wondering if anyone has any advice to give about whether a
> rebuild is generally quicker than a reorganize, or vice versa?
> Any help / advice appreciated!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>This article is for 2000, but the essentials applies to 2005 as well. DBREIN
DEX is REBUILD and
INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 20
05 (EE only).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<planetthoughtful@.gmail.com> wrote in message
news:1151475743.435319.310670@.y41g2000cwy.googlegroups.com...
> Hi All,
> Just wondering if anyone can give me some general advice on the
> practical differences between rebuilding and reorganizing indexes in
> sql server 2000?
> Basically, we have a database that occupies approx 28gb, of which
> approximately 4gb is indexes. In the 2 or so years that our app has
> been using this server, the indexes have never been rebuilt /
> reoganized to the best of our knowledge.
> In particular, we are hoping to minimize downtime while we see to this,
> so I'm wondering if anyone has any advice to give about whether a
> rebuild is generally quicker than a reorganize, or vice versa?
> Any help / advice appreciated!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>|||Uri Dimant wrote:
> Are you talking about the difference between DBCC INDEXDEFRAG and DBCC
> REINDEX?
Hmmm. According to BOL (admittedly the one that comes with SQL Server
Express 2005), I can use, for example:
ALTER INDEX PK_tReturns ON dbo.tReturns REORGANIZE;
or:
ALTER INDEX PK_tReturns ON dbo.tReturns REBUILD;
...to reoagnize or rebuild respectively.
Is this not the case? The server in question is a production SQL Server
2000 server.
Thanks for your reply!
Much warmth,
planetthoughtful
--
"lost in thought"
http://www.planetthoughtful.org|||Tibor Karaszi wrote:
> This article is for 2000, but the essentials applies to 2005 as well. DBRE
INDEX is REBUILD and
> INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE
only).
Hi Tibor,
Sorry, which article, exactly? Were you intending to include a link?
Thanks for your reply!
Much warmth,
planetthoughtful
--
"Lost in thought"
http://www.planetthoughtful.org|||Sorry, here's the URL: http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<planetthoughtful@.gmail.com> wrote in message
news:1151478465.492923.232660@.i40g2000cwc.googlegroups.com...
> Tibor Karaszi wrote:
> Hi Tibor,
> Sorry, which article, exactly? Were you intending to include a link?
> Thanks for your reply!
> Much warmth,
> planetthoughtful
> --
> "Lost in thought"
> http://www.planetthoughtful.org
>|||ALTER INDEX is not available in SQL 2000; it is new for SQL 2005.
USE DBCC REINDEX to rebuild and DBCC INDEXDEFRAG to reorganize, and then the
article Tibor provided is perfectly relevant.
HTH
Kalen Delaney, SQL Server MVP
<planetthoughtful@.gmail.com> wrote in message
news:1151478353.212906.225050@.i40g2000cwc.googlegroups.com...
> Uri Dimant wrote:
> Hmmm. According to BOL (admittedly the one that comes with SQL Server
> Express 2005), I can use, for example:
> ALTER INDEX PK_tReturns ON dbo.tReturns REORGANIZE;
> or:
> ALTER INDEX PK_tReturns ON dbo.tReturns REBUILD;
> ...to reoagnize or rebuild respectively.
> Is this not the case? The server in question is a production SQL Server
> 2000 server.
> Thanks for your reply!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>|||Hi All,
Just wondering if anyone can give me some general advice on the
practical differences between rebuilding and reorganizing indexes in
sql server 2000?
Basically, we have a database that occupies approx 28gb, of which
approximately 4gb is indexes. In the 2 or so years that our app has
been using this server, the indexes have never been rebuilt /
reoganized to the best of our knowledge.
In particular, we are hoping to minimize downtime while we see to this,
so I'm wondering if anyone has any advice to give about whether a
rebuild is generally quicker than a reorganize, or vice versa?
Any help / advice appreciated!
Much warmth,
planetthoughtful
--
"lost in thought"
http://www.planetthoughtful.org|||This article is for 2000, but the essentials applies to 2005 as well. DBREIN
DEX is REBUILD and
INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 20
05 (EE only).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<planetthoughtful@.gmail.com> wrote in message
news:1151475743.435319.310670@.y41g2000cwy.googlegroups.com...
> Hi All,
> Just wondering if anyone can give me some general advice on the
> practical differences between rebuilding and reorganizing indexes in
> sql server 2000?
> Basically, we have a database that occupies approx 28gb, of which
> approximately 4gb is indexes. In the 2 or so years that our app has
> been using this server, the indexes have never been rebuilt /
> reoganized to the best of our knowledge.
> In particular, we are hoping to minimize downtime while we see to this,
> so I'm wondering if anyone has any advice to give about whether a
> rebuild is generally quicker than a reorganize, or vice versa?
> Any help / advice appreciated!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>|||Uri Dimant wrote:
> Are you talking about the difference between DBCC INDEXDEFRAG and DBCC
> REINDEX?
Hmmm. According to BOL (admittedly the one that comes with SQL Server
Express 2005), I can use, for example:
ALTER INDEX PK_tReturns ON dbo.tReturns REORGANIZE;
or:
ALTER INDEX PK_tReturns ON dbo.tReturns REBUILD;
...to reoagnize or rebuild respectively.
Is this not the case? The server in question is a production SQL Server
2000 server.
Thanks for your reply!
Much warmth,
planetthoughtful
--
"lost in thought"
http://www.planetthoughtful.org|||Tibor Karaszi wrote:
> This article is for 2000, but the essentials applies to 2005 as well. DBRE
INDEX is REBUILD and
> INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE
only).
Hi Tibor,
Sorry, which article, exactly? Were you intending to include a link?
Thanks for your reply!
Much warmth,
planetthoughtful
--
"Lost in thought"
http://www.planetthoughtful.org
REINDEX?
<planetthoughtful@.gmail.com> wrote in message
news:1151475743.435319.310670@.y41g2000cwy.googlegroups.com...
> Hi All,
> Just wondering if anyone can give me some general advice on the
> practical differences between rebuilding and reorganizing indexes in
> sql server 2000?
> Basically, we have a database that occupies approx 28gb, of which
> approximately 4gb is indexes. In the 2 or so years that our app has
> been using this server, the indexes have never been rebuilt /
> reoganized to the best of our knowledge.
> In particular, we are hoping to minimize downtime while we see to this,
> so I'm wondering if anyone has any advice to give about whether a
> rebuild is generally quicker than a reorganize, or vice versa?
> Any help / advice appreciated!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>This article is for 2000, but the essentials applies to 2005 as well. DBREIN
DEX is REBUILD and
INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 20
05 (EE only).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<planetthoughtful@.gmail.com> wrote in message
news:1151475743.435319.310670@.y41g2000cwy.googlegroups.com...
> Hi All,
> Just wondering if anyone can give me some general advice on the
> practical differences between rebuilding and reorganizing indexes in
> sql server 2000?
> Basically, we have a database that occupies approx 28gb, of which
> approximately 4gb is indexes. In the 2 or so years that our app has
> been using this server, the indexes have never been rebuilt /
> reoganized to the best of our knowledge.
> In particular, we are hoping to minimize downtime while we see to this,
> so I'm wondering if anyone has any advice to give about whether a
> rebuild is generally quicker than a reorganize, or vice versa?
> Any help / advice appreciated!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>|||Uri Dimant wrote:
> Are you talking about the difference between DBCC INDEXDEFRAG and DBCC
> REINDEX?
Hmmm. According to BOL (admittedly the one that comes with SQL Server
Express 2005), I can use, for example:
ALTER INDEX PK_tReturns ON dbo.tReturns REORGANIZE;
or:
ALTER INDEX PK_tReturns ON dbo.tReturns REBUILD;
...to reoagnize or rebuild respectively.
Is this not the case? The server in question is a production SQL Server
2000 server.
Thanks for your reply!
Much warmth,
planetthoughtful
--
"lost in thought"
http://www.planetthoughtful.org|||Tibor Karaszi wrote:
> This article is for 2000, but the essentials applies to 2005 as well. DBRE
INDEX is REBUILD and
> INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE
only).
Hi Tibor,
Sorry, which article, exactly? Were you intending to include a link?
Thanks for your reply!
Much warmth,
planetthoughtful
--
"Lost in thought"
http://www.planetthoughtful.org|||Sorry, here's the URL: http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<planetthoughtful@.gmail.com> wrote in message
news:1151478465.492923.232660@.i40g2000cwc.googlegroups.com...
> Tibor Karaszi wrote:
> Hi Tibor,
> Sorry, which article, exactly? Were you intending to include a link?
> Thanks for your reply!
> Much warmth,
> planetthoughtful
> --
> "Lost in thought"
> http://www.planetthoughtful.org
>|||ALTER INDEX is not available in SQL 2000; it is new for SQL 2005.
USE DBCC REINDEX to rebuild and DBCC INDEXDEFRAG to reorganize, and then the
article Tibor provided is perfectly relevant.
HTH
Kalen Delaney, SQL Server MVP
<planetthoughtful@.gmail.com> wrote in message
news:1151478353.212906.225050@.i40g2000cwc.googlegroups.com...
> Uri Dimant wrote:
> Hmmm. According to BOL (admittedly the one that comes with SQL Server
> Express 2005), I can use, for example:
> ALTER INDEX PK_tReturns ON dbo.tReturns REORGANIZE;
> or:
> ALTER INDEX PK_tReturns ON dbo.tReturns REBUILD;
> ...to reoagnize or rebuild respectively.
> Is this not the case? The server in question is a production SQL Server
> 2000 server.
> Thanks for your reply!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>|||Hi All,
Just wondering if anyone can give me some general advice on the
practical differences between rebuilding and reorganizing indexes in
sql server 2000?
Basically, we have a database that occupies approx 28gb, of which
approximately 4gb is indexes. In the 2 or so years that our app has
been using this server, the indexes have never been rebuilt /
reoganized to the best of our knowledge.
In particular, we are hoping to minimize downtime while we see to this,
so I'm wondering if anyone has any advice to give about whether a
rebuild is generally quicker than a reorganize, or vice versa?
Any help / advice appreciated!
Much warmth,
planetthoughtful
--
"lost in thought"
http://www.planetthoughtful.org|||This article is for 2000, but the essentials applies to 2005 as well. DBREIN
DEX is REBUILD and
INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 20
05 (EE only).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<planetthoughtful@.gmail.com> wrote in message
news:1151475743.435319.310670@.y41g2000cwy.googlegroups.com...
> Hi All,
> Just wondering if anyone can give me some general advice on the
> practical differences between rebuilding and reorganizing indexes in
> sql server 2000?
> Basically, we have a database that occupies approx 28gb, of which
> approximately 4gb is indexes. In the 2 or so years that our app has
> been using this server, the indexes have never been rebuilt /
> reoganized to the best of our knowledge.
> In particular, we are hoping to minimize downtime while we see to this,
> so I'm wondering if anyone has any advice to give about whether a
> rebuild is generally quicker than a reorganize, or vice versa?
> Any help / advice appreciated!
> Much warmth,
> planetthoughtful
> --
> "lost in thought"
> http://www.planetthoughtful.org
>|||Uri Dimant wrote:
> Are you talking about the difference between DBCC INDEXDEFRAG and DBCC
> REINDEX?
Hmmm. According to BOL (admittedly the one that comes with SQL Server
Express 2005), I can use, for example:
ALTER INDEX PK_tReturns ON dbo.tReturns REORGANIZE;
or:
ALTER INDEX PK_tReturns ON dbo.tReturns REBUILD;
...to reoagnize or rebuild respectively.
Is this not the case? The server in question is a production SQL Server
2000 server.
Thanks for your reply!
Much warmth,
planetthoughtful
--
"lost in thought"
http://www.planetthoughtful.org|||Tibor Karaszi wrote:
> This article is for 2000, but the essentials applies to 2005 as well. DBRE
INDEX is REBUILD and
> INDEXDEFRAG is REORGANIZE. Also note that REBUILD has an ONLINE option in 2005 (EE
only).
Hi Tibor,
Sorry, which article, exactly? Were you intending to include a link?
Thanks for your reply!
Much warmth,
planetthoughtful
--
"Lost in thought"
http://www.planetthoughtful.org
mssql2k sqloledb.1 (re)connection failure
Hey all, 2 questions.
Is there a way to 'refresh' the value of adodb.connection.state? and When my ado class reconnects after a dropped connection i still get connection failure errors.
I'm trying to make the connection b/n the my work's app and mssql server more 'robust'.
Our ado class tests the connection in the 'execute' method ie if connect() execute db task
.connect() is
IF this.loConnection.State = adStateOpen
*-- The connection is already open.
ELSE
create connection
ENDIF
return (this.loConnection.State = adStateOpen)
Now, this works fine when starting up the app, and everything runs fine, but *in theory* it should be able re-establish the connection at any time. So i kill the connection @. on the sql server while the app is running and try to perform a task that requires a db connection.
problem is that 'this.loConnection.State' is still equal to 1 even though the connection is no longer there.
It gets changed to 0 when the .execute fails but the failure is less than graceful... and although it reconnects (sp_who shows a new connection), it seems like the ado object is trying to connect using the old connection rather than the new one. command.activeconnection is set to the new connection in the .connect method so i dunno what's up.
Any ideas?
If you look for DBPROP_CONNECTIONSTATUS you will see that the status can be
uninitialized, initialized, or communicationfailure.
You cannot get communicationfailure unless you execute something and it fails.|||I suspected that wouldn't be able to do anything with .State once the connection has been made.
Any tips re: the other problem? Is there anything else I need to recreate/reinitialise besides command.activeconnection when i open a new connection?
|||On a second thought the provider can actually check the connection when the property is requested by GetProperties. I think that SQLOLEDB might be doing this. I will have to check the code to see if this is the case, and also how ADO is refreshing the properties, unless of course somebody else does not come up with the answer sooner.|||Could you try checking "Connection Status" property of the ADO Connection?
I beleive that this is how DBPROP_CONNECTIONSTATUS is being exposed from a corresponding provider.
mssql2k sqloledb.1 (re)connection failure
Hey all, 2 questions.
Is there a way to 'refresh' the value of adodb.connection.state? and When my ado class reconnects after a dropped connection i still get connection failure errors.
I'm trying to make the connection b/n the my work's app and mssql server more 'robust'.
Our ado class tests the connection in the 'execute' method ie if connect() execute db task
.connect() is
IF this.loConnection.State = adStateOpen
*-- The connection is already open.
ELSE
create connection
ENDIF
return (this.loConnection.State = adStateOpen)
Now, this works fine when starting up the app, and everything runs fine, but *in theory* it should be able re-establish the connection at any time. So i kill the connection @. on the sql server while the app is running and try to perform a task that requires a db connection.
problem is that 'this.loConnection.State' is still equal to 1 even though the connection is no longer there.
It gets changed to 0 when the .execute fails but the failure is less than graceful... and although it reconnects (sp_who shows a new connection), it seems like the ado object is trying to connect using the old connection rather than the new one. command.activeconnection is set to the new connection in the .connect method so i dunno what's up.
Any ideas?
If you look for DBPROP_CONNECTIONSTATUS you will see that the status can be
uninitialized, initialized, or communicationfailure.
You cannot get communicationfailure unless you execute something and it fails.|||I suspected that wouldn't be able to do anything with .State once the connection has been made.
Any tips re: the other problem? Is there anything else I need to recreate/reinitialise besides command.activeconnection when i open a new connection?
|||On a second thought the provider can actually check the connection when the property is requested by GetProperties. I think that SQLOLEDB might be doing this. I will have to check the code to see if this is the case, and also how ADO is refreshing the properties, unless of course somebody else does not come up with the answer sooner.|||Could you try checking "Connection Status" property of the ADO Connection?
I beleive that this is how DBPROP_CONNECTIONSTATUS is being exposed from a corresponding provider.
MSSQL2k retrive data from xml
Hello
I have mssql 2k there database and few XML files. I try get data from XML
files and insert into database. How to do that using DTS'
AJAHello AJA,
> I have mssql 2k there database and few XML files. I try get data
> from XML
> files and insert into database. How to do that using DTS'
Here's about a dozen ideas:
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||>> I have mssql 2k there database and few XML files. I try get data
> Here's about a dozen ideas:
> http://www.perfectxml.com/articles/xml/importxmlsql.asp
Yes i watched there and:
OPENXML does not work because to big file 10+MB or maybe anyone have idea
how to prepare_document using text variable? code which i found opened max
1,5MB xml file
Microsoft Visual Basic no have so can no make project using VB
I was intrested to use this one "DTS ActiveX Script & MSXML 4.0 DOM". I
tried, installed MSXML and copied code but it does not work.
Succesfully execution but no records in destination tables.
I have no idea what was wrong :(
Best Regards
AJA|||Hello AJA,
One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
look seriously at SQL Server 2005's SSIS bits. Much better for working with
XML.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||> One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
> look seriously at SQL Server 2005's SSIS bits. Much better for working
> with XML.
The problem is I can no change MSSQL to 2005 because its not my software.
So i'm looking how to solve it in MSSQL 2k.
Best Regards
AJA|||Hello,
Check out SQLXML technology
:http://msdn2.microsoft.com/en-us/library/aa225763(SQL.80).aspx.
I hope this helps.
Regards,
--
Monica Frintu
"AJA" wrote:
> Hello
> I have mssql 2k there database and few XML files. I try get data from XM
L
> files and insert into database. How to do that using DTS'
>
> AJA
>
I have mssql 2k there database and few XML files. I try get data from XML
files and insert into database. How to do that using DTS'
AJAHello AJA,
> I have mssql 2k there database and few XML files. I try get data
> from XML
> files and insert into database. How to do that using DTS'
Here's about a dozen ideas:
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||>> I have mssql 2k there database and few XML files. I try get data
> Here's about a dozen ideas:
> http://www.perfectxml.com/articles/xml/importxmlsql.asp
Yes i watched there and:
OPENXML does not work because to big file 10+MB or maybe anyone have idea
how to prepare_document using text variable? code which i found opened max
1,5MB xml file
Microsoft Visual Basic no have so can no make project using VB
I was intrested to use this one "DTS ActiveX Script & MSXML 4.0 DOM". I
tried, installed MSXML and copied code but it does not work.
Succesfully execution but no records in destination tables.
I have no idea what was wrong :(
Best Regards
AJA|||Hello AJA,
One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
look seriously at SQL Server 2005's SSIS bits. Much better for working with
XML.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||> One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
> look seriously at SQL Server 2005's SSIS bits. Much better for working
> with XML.
The problem is I can no change MSSQL to 2005 because its not my software.
So i'm looking how to solve it in MSSQL 2k.
Best Regards
AJA|||Hello,
Check out SQLXML technology
:http://msdn2.microsoft.com/en-us/library/aa225763(SQL.80).aspx.
I hope this helps.
Regards,
--
Monica Frintu
"AJA" wrote:
> Hello
> I have mssql 2k there database and few XML files. I try get data from XM
L
> files and insert into database. How to do that using DTS'
>
> AJA
>
MSSQL2k retrive data from xml
Hello
I have mssql 2k there database and few XML files. I try get data from XML
files and insert into database. How to do that using DTS?
AJA
Hello AJA,
> I have mssql 2k there database and few XML files. I try get data
> from XML
> files and insert into database. How to do that using DTS?
Here's about a dozen ideas:
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||>> I have mssql 2k there database and few XML files. I try get data
> Here's about a dozen ideas:
> http://www.perfectxml.com/articles/xml/importxmlsql.asp
Yes i watched there and:
OPENXML does not work because to big file 10+MB or maybe anyone have idea
how to prepare_document using text variable? code which i found opened max
1,5MB xml file
Microsoft Visual Basic no have so can no make project using VB
I was intrested to use this one "DTS ActiveX Script & MSXML 4.0 DOM". I
tried, installed MSXML and copied code but it does not work.
Succesfully execution but no records in destination tables.
I have no idea what was wrong
Best Regards
AJA
|||Hello AJA,
One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
look seriously at SQL Server 2005's SSIS bits. Much better for working with
XML.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||> One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
> look seriously at SQL Server 2005's SSIS bits. Much better for working
> with XML.
The problem is I can no change MSSQL to 2005 because its not my software.
So i'm looking how to solve it in MSSQL 2k.
Best Regards
AJA
|||Hello,
Check out SQLXML technology
:http://msdn2.microsoft.com/en-us/library/aa225763(SQL.80).aspx.
I hope this helps.
Regards,
Monica Frintu
"AJA" wrote:
> Hello
> I have mssql 2k there database and few XML files. I try get data from XML
> files and insert into database. How to do that using DTS?
>
> AJA
>
I have mssql 2k there database and few XML files. I try get data from XML
files and insert into database. How to do that using DTS?
AJA
Hello AJA,
> I have mssql 2k there database and few XML files. I try get data
> from XML
> files and insert into database. How to do that using DTS?
Here's about a dozen ideas:
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||>> I have mssql 2k there database and few XML files. I try get data
> Here's about a dozen ideas:
> http://www.perfectxml.com/articles/xml/importxmlsql.asp
Yes i watched there and:
OPENXML does not work because to big file 10+MB or maybe anyone have idea
how to prepare_document using text variable? code which i found opened max
1,5MB xml file
Microsoft Visual Basic no have so can no make project using VB
I was intrested to use this one "DTS ActiveX Script & MSXML 4.0 DOM". I
tried, installed MSXML and copied code but it does not work.
Succesfully execution but no records in destination tables.
I have no idea what was wrong
Best Regards
AJA
|||Hello AJA,
One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
look seriously at SQL Server 2005's SSIS bits. Much better for working with
XML.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||> One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
> look seriously at SQL Server 2005's SSIS bits. Much better for working
> with XML.
The problem is I can no change MSSQL to 2005 because its not my software.
So i'm looking how to solve it in MSSQL 2k.
Best Regards
AJA
|||Hello,
Check out SQLXML technology
:http://msdn2.microsoft.com/en-us/library/aa225763(SQL.80).aspx.
I hope this helps.
Regards,
Monica Frintu
"AJA" wrote:
> Hello
> I have mssql 2k there database and few XML files. I try get data from XML
> files and insert into database. How to do that using DTS?
>
> AJA
>
MSSQL2K FOR XML Explicit help?
underprocessableHi Ian...
not quite understanding how the different attributes get calculated, here is
both a FOR XML EXPLICIT and FOR XML PATH solution (the later requires SQL
Server 2005, hint hint). You may need to change some of the formatting of
the values to get them to be completely consistent with your expected
results.
FOR XML EXPLICIT:
select 1 as tag, 0 as parent
, '1' as "ExternalProducts!1!AccountID"
, GETUTCDATE() as "ExternalProducts!1!TimeStamp"
, 0 as "ExternalProducts!1!UpdateType"
, '' as "ExternalProducts!1!DependantFilename"
, '07042001.EDN' as "ExternalProducts!1!SourceFilename"
, (select count(ProductID) from Products) as
"ExternalProducts!1!ProductCount"
, (select count(OuterBarcode) from Products)
as"ExternalProducts!1!BarcodeCount"
, NULL as "Products!2!ID!hide"
, NULL as "Products!2!OuterBarcode"
, NULL as "Products!2!Department"
, NULL as "Products!2!SubDepartment"
, NULL as "Products!2!Vat"
, NULL as "Products!2!PromotionType"
, NULL as "Products!2!DiscontinuedDate"
, NULL as "Supplier!3!Reference"
, NULL as "Supplier!3!PreviousReference"
, NULL as "Supplier!3!CostPrice"
, NULL as "Supplier!3!Units"
, NULL as "Supplier!3!MinOrder"
, NULL as "Supplier!3!FutureCostPrice"
, NULL as "Supplier!3!FutureCostPriceChangeDate"
, NULL as "Supplier!3!FutureCostPriceRevertDate"
, NULL as "ProductVariant!4!Barcode"
, NULL as "ProductVariant!4!Description"
, NULL as "ProductVariant!4!Receipt"
, NULL as "ProductVariant!4!RetailPrice"
, NULL as "ProductVariant!4!PriceMarked"
union all
select 2 , 1
, '1' , NULL, NULL, NULL, NULL, NULL, NULL /*ExternalProducts*/
, ProductID
, ISNULL(OuterBarcode, '')
, DepartmentID
, SubDepartmentID
, VatCode
, ''
, ISNULL(CAST(DiscontinuedDate as nvarchar(20)), '') /*Products*/
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL /*Supplier*/
, NULL, NULL, NULL, NULL, NULL /*ProductVariant*/
from Products
union all
select 3, 2
, '1' , NULL, NULL, NULL, NULL, NULL, NULL /*ExternalProducts*/
, Products.ProductID, NULL, NULL, NULL, NULL, NULL, NULL
/*Products*/
, CostPrices.Reference, '', CostPerOuter, UnitsPerOuter, MinOrderQty
, ISNULL(CAST(FutureCost as nvarchar(20)), '')
, ISNULL(CAST(FutureDate as nvarchar(20)), '')
, ISNULL(CAST(ReversionDate as nvarchar(20)), '') /*Supplier*/
, NULL, NULL, NULL, NULL, NULL /*ProductVariant*/
from CostPrices
join Products on CostPrices.ProductID = Products.ProductID
union all
select 4, 2
, '1' , NULL, NULL, NULL, NULL, NULL, NULL /*ExternalProducts*/
, Products.ProductID, NULL, NULL, NULL, NULL, NULL, NULL
/*Products*/
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL /*Supplier*/
, rp.BarcodeID, b.Description, b.Receipt, rp.Price
, ISNULL(CAST(rp.FuturePrice as nvarchar(20)), 'False')
/*ProductVariant*/
from RetailPrices rp
join Barcodes b on rp.BarcodeID = b.BarcodeID
join Products on b.ProductID = Products.ProductID
order by "ExternalProducts!1!AccountID", "Products!2!ID!hide", tag
for xml explicit
FOR XML PATH:
select '1' as "@.AccountID"
, GETUTCDATE() as "@.TimeStamp"
, 0 as "@.UpdateType"
, '' as "@.DependantFilename"
, '07042001.EDN' as "@.SourceFilename"
, (select count(ProductID) from Products) as "@.ProductCount"
, (select count(OuterBarcode) from Products) as"@.BarcodeCount"
, ( select ISNULL(OuterBarcode, '') as "@.OuterBarcode"
, DepartmentID as "@.Department"
, SubDepartmentID as "@.SubDepartment"
, VatCode as "@.Vat"
, '' as "@.PromotionType" -- what relational column?
, ISNULL(CAST(DiscontinuedDate as nvarchar(20)), '') as
"@.DiscontinuedDate"
, ( select Reference as "@.Reference"
, '' as "@.PreviousReference" -- how do you calculate
that?
, CostPerOuter as "@.CostPrice"
, UnitsPerOuter as "@.Units"
, MinOrderQty as "@.MinOrder"
, ISNULL(CAST(FutureCost as nvarchar(20)), '') as
"@.FutureCostPrice"
, ISNULL(CAST(FutureDate as nvarchar(20)), '') as
"@.FutureCostPriceChangeDate"
, ISNULL(CAST(ReversionDate as nvarchar(20)), '') as
"@.FutureCostPriceRevertDate"
from CostPrices
where CostPrices.ProductID = Products.ProductID
for xml path('Supplier'), type)
, ( select rp.BarcodeID as "@.Barcode"
, b.Description as "@.Description"
, b.Receipt as "@.Receipt"
, rp.Price as "@.RetailPrice"
, ISNULL(CAST(rp.FuturePrice as nvarchar(20)), 'False') as
"@.PriceMarked" -- how is it calculated?
from RetailPrices rp
join Barcodes b on rp.BarcodeID = b.BarcodeID
where b.ProductID = Products.ProductID
for xml path('ProductVariant'), type)
from Products
for xml path('Products'),type)
for xml path('ExternalProducts')
I hope this helps
Michael
"Ian Ashworth" <spamcatch@.miragesoftware.co.uk> wrote in message
news:eTH0TszhHHA.208@.TK2MSFTNGP05.phx.gbl...
> Hey guys
> Currently Im pulling multiple recordsets back from SQL Server 2000 into
> VB6 and using text parsing techniques to create an XML file in the desired
> format. It does the job but is extremely slow and so I've been pointed in
> the direction of FOR XML EXPLICIT. Unfortunately this totally baffles me
> and I've been struggilng most of the day trying to get my head around it.
> I have attached a script to create the tables/example data and have
> included an example of the desired output in the comments so any help
> would be greatly appreciated.
> Thanks in advance for any assistance that you may provide.
> Ian Ashworth
>
>
not quite understanding how the different attributes get calculated, here is
both a FOR XML EXPLICIT and FOR XML PATH solution (the later requires SQL
Server 2005, hint hint). You may need to change some of the formatting of
the values to get them to be completely consistent with your expected
results.
FOR XML EXPLICIT:
select 1 as tag, 0 as parent
, '1' as "ExternalProducts!1!AccountID"
, GETUTCDATE() as "ExternalProducts!1!TimeStamp"
, 0 as "ExternalProducts!1!UpdateType"
, '' as "ExternalProducts!1!DependantFilename"
, '07042001.EDN' as "ExternalProducts!1!SourceFilename"
, (select count(ProductID) from Products) as
"ExternalProducts!1!ProductCount"
, (select count(OuterBarcode) from Products)
as"ExternalProducts!1!BarcodeCount"
, NULL as "Products!2!ID!hide"
, NULL as "Products!2!OuterBarcode"
, NULL as "Products!2!Department"
, NULL as "Products!2!SubDepartment"
, NULL as "Products!2!Vat"
, NULL as "Products!2!PromotionType"
, NULL as "Products!2!DiscontinuedDate"
, NULL as "Supplier!3!Reference"
, NULL as "Supplier!3!PreviousReference"
, NULL as "Supplier!3!CostPrice"
, NULL as "Supplier!3!Units"
, NULL as "Supplier!3!MinOrder"
, NULL as "Supplier!3!FutureCostPrice"
, NULL as "Supplier!3!FutureCostPriceChangeDate"
, NULL as "Supplier!3!FutureCostPriceRevertDate"
, NULL as "ProductVariant!4!Barcode"
, NULL as "ProductVariant!4!Description"
, NULL as "ProductVariant!4!Receipt"
, NULL as "ProductVariant!4!RetailPrice"
, NULL as "ProductVariant!4!PriceMarked"
union all
select 2 , 1
, '1' , NULL, NULL, NULL, NULL, NULL, NULL /*ExternalProducts*/
, ProductID
, ISNULL(OuterBarcode, '')
, DepartmentID
, SubDepartmentID
, VatCode
, ''
, ISNULL(CAST(DiscontinuedDate as nvarchar(20)), '') /*Products*/
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL /*Supplier*/
, NULL, NULL, NULL, NULL, NULL /*ProductVariant*/
from Products
union all
select 3, 2
, '1' , NULL, NULL, NULL, NULL, NULL, NULL /*ExternalProducts*/
, Products.ProductID, NULL, NULL, NULL, NULL, NULL, NULL
/*Products*/
, CostPrices.Reference, '', CostPerOuter, UnitsPerOuter, MinOrderQty
, ISNULL(CAST(FutureCost as nvarchar(20)), '')
, ISNULL(CAST(FutureDate as nvarchar(20)), '')
, ISNULL(CAST(ReversionDate as nvarchar(20)), '') /*Supplier*/
, NULL, NULL, NULL, NULL, NULL /*ProductVariant*/
from CostPrices
join Products on CostPrices.ProductID = Products.ProductID
union all
select 4, 2
, '1' , NULL, NULL, NULL, NULL, NULL, NULL /*ExternalProducts*/
, Products.ProductID, NULL, NULL, NULL, NULL, NULL, NULL
/*Products*/
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL /*Supplier*/
, rp.BarcodeID, b.Description, b.Receipt, rp.Price
, ISNULL(CAST(rp.FuturePrice as nvarchar(20)), 'False')
/*ProductVariant*/
from RetailPrices rp
join Barcodes b on rp.BarcodeID = b.BarcodeID
join Products on b.ProductID = Products.ProductID
order by "ExternalProducts!1!AccountID", "Products!2!ID!hide", tag
for xml explicit
FOR XML PATH:
select '1' as "@.AccountID"
, GETUTCDATE() as "@.TimeStamp"
, 0 as "@.UpdateType"
, '' as "@.DependantFilename"
, '07042001.EDN' as "@.SourceFilename"
, (select count(ProductID) from Products) as "@.ProductCount"
, (select count(OuterBarcode) from Products) as"@.BarcodeCount"
, ( select ISNULL(OuterBarcode, '') as "@.OuterBarcode"
, DepartmentID as "@.Department"
, SubDepartmentID as "@.SubDepartment"
, VatCode as "@.Vat"
, '' as "@.PromotionType" -- what relational column?
, ISNULL(CAST(DiscontinuedDate as nvarchar(20)), '') as
"@.DiscontinuedDate"
, ( select Reference as "@.Reference"
, '' as "@.PreviousReference" -- how do you calculate
that?
, CostPerOuter as "@.CostPrice"
, UnitsPerOuter as "@.Units"
, MinOrderQty as "@.MinOrder"
, ISNULL(CAST(FutureCost as nvarchar(20)), '') as
"@.FutureCostPrice"
, ISNULL(CAST(FutureDate as nvarchar(20)), '') as
"@.FutureCostPriceChangeDate"
, ISNULL(CAST(ReversionDate as nvarchar(20)), '') as
"@.FutureCostPriceRevertDate"
from CostPrices
where CostPrices.ProductID = Products.ProductID
for xml path('Supplier'), type)
, ( select rp.BarcodeID as "@.Barcode"
, b.Description as "@.Description"
, b.Receipt as "@.Receipt"
, rp.Price as "@.RetailPrice"
, ISNULL(CAST(rp.FuturePrice as nvarchar(20)), 'False') as
"@.PriceMarked" -- how is it calculated?
from RetailPrices rp
join Barcodes b on rp.BarcodeID = b.BarcodeID
where b.ProductID = Products.ProductID
for xml path('ProductVariant'), type)
from Products
for xml path('Products'),type)
for xml path('ExternalProducts')
I hope this helps
Michael
"Ian Ashworth" <spamcatch@.miragesoftware.co.uk> wrote in message
news:eTH0TszhHHA.208@.TK2MSFTNGP05.phx.gbl...
> Hey guys
> Currently Im pulling multiple recordsets back from SQL Server 2000 into
> VB6 and using text parsing techniques to create an XML file in the desired
> format. It does the job but is extremely slow and so I've been pointed in
> the direction of FOR XML EXPLICIT. Unfortunately this totally baffles me
> and I've been struggilng most of the day trying to get my head around it.
> I have attached a script to create the tables/example data and have
> included an example of the desired output in the comments so any help
> would be greatly appreciated.
> Thanks in advance for any assistance that you may provide.
> Ian Ashworth
>
>
MSSQL2K and WIN2K3 SP1
We have a Windows Server 2003 Standard with SQL Server 2000 Standard
edition serving as a development server. There are several DTS packages
hosted on the server and they connect to an entry from the local hosts
table. The reason for this is that each of the DEV, QA and PROD
servers in this group have an entry with the same name (ex. SVR_DBNAME)
but each of which point to their own IP address, allowing us to copy
the packages between servers without going back and changing all the
server name references.
Recently, WIN2K3 SP1 was installed on the machine and immediately, the
DTS packages - which use WIndows Authentication - failed with a message
indicating that the system could not authenticate against the local
Windows user:
Login failed for user '(null)'
Once SP1 was removed, the packages resumed working. What setting does
the service pack change that is causing this?
thanks
mark
Hi
A couple of questions
Does the server/s have Mixed authentication mode or windows only?
Did you try ( If I understood correctly) to add an owner of DTS Packages to
the group of Admin of WIN2K3?
<markfcook@.gmail.com> wrote in message
news:1161054855.189750.67760@.m73g2000cwd.googlegro ups.com...
> We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> edition serving as a development server. There are several DTS packages
> hosted on the server and they connect to an entry from the local hosts
> table. The reason for this is that each of the DEV, QA and PROD
> servers in this group have an entry with the same name (ex. SVR_DBNAME)
> but each of which point to their own IP address, allowing us to copy
> the packages between servers without going back and changing all the
> server name references.
> Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> DTS packages - which use WIndows Authentication - failed with a message
> indicating that the system could not authenticate against the local
> Windows user:
> Login failed for user '(null)'
> Once SP1 was removed, the packages resumed working. What setting does
> the service pack change that is causing this?
> thanks
> mark
>
|||Q1) mixed mode authentication is used
Q2) the windows account is a member of the local administrators group
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> A couple of questions
> Does the server/s have Mixed authentication mode or windows only?
> Did you try ( If I understood correctly) to add an owner of DTS Packages to
> the group of Admin of WIN2K3?
>
>
>
> <markfcook@.gmail.com> wrote in message
> news:1161054855.189750.67760@.m73g2000cwd.googlegro ups.com...
edition serving as a development server. There are several DTS packages
hosted on the server and they connect to an entry from the local hosts
table. The reason for this is that each of the DEV, QA and PROD
servers in this group have an entry with the same name (ex. SVR_DBNAME)
but each of which point to their own IP address, allowing us to copy
the packages between servers without going back and changing all the
server name references.
Recently, WIN2K3 SP1 was installed on the machine and immediately, the
DTS packages - which use WIndows Authentication - failed with a message
indicating that the system could not authenticate against the local
Windows user:
Login failed for user '(null)'
Once SP1 was removed, the packages resumed working. What setting does
the service pack change that is causing this?
thanks
mark
Hi
A couple of questions
Does the server/s have Mixed authentication mode or windows only?
Did you try ( If I understood correctly) to add an owner of DTS Packages to
the group of Admin of WIN2K3?
<markfcook@.gmail.com> wrote in message
news:1161054855.189750.67760@.m73g2000cwd.googlegro ups.com...
> We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> edition serving as a development server. There are several DTS packages
> hosted on the server and they connect to an entry from the local hosts
> table. The reason for this is that each of the DEV, QA and PROD
> servers in this group have an entry with the same name (ex. SVR_DBNAME)
> but each of which point to their own IP address, allowing us to copy
> the packages between servers without going back and changing all the
> server name references.
> Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> DTS packages - which use WIndows Authentication - failed with a message
> indicating that the system could not authenticate against the local
> Windows user:
> Login failed for user '(null)'
> Once SP1 was removed, the packages resumed working. What setting does
> the service pack change that is causing this?
> thanks
> mark
>
|||Q1) mixed mode authentication is used
Q2) the windows account is a member of the local administrators group
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> A couple of questions
> Does the server/s have Mixed authentication mode or windows only?
> Did you try ( If I understood correctly) to add an owner of DTS Packages to
> the group of Admin of WIN2K3?
>
>
>
> <markfcook@.gmail.com> wrote in message
> news:1161054855.189750.67760@.m73g2000cwd.googlegro ups.com...
MSSQL2K and WIN2K3 SP1
We have a Windows Server 2003 Standard with SQL Server 2000 Standard
edition serving as a development server. There are several DTS packages
hosted on the server and they connect to an entry from the local hosts
table. The reason for this is that each of the DEV, QA and PROD
servers in this group have an entry with the same name (ex. SVR_DBNAME)
but each of which point to their own IP address, allowing us to copy
the packages between servers without going back and changing all the
server name references.
Recently, WIN2K3 SP1 was installed on the machine and immediately, the
DTS packages - which use WIndows Authentication - failed with a message
indicating that the system could not authenticate against the local
Windows user:
Login failed for user '(null)'
Once SP1 was removed, the packages resumed working. What setting does
the service pack change that is causing this?
thanks
markHi
A couple of questions
Does the server/s have Mixed authentication mode or windows only?
Did you try ( If I understood correctly) to add an owner of DTS Packages to
the group of Admin of WIN2K3?
<markfcook@.gmail.com> wrote in message
news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
> We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> edition serving as a development server. There are several DTS packages
> hosted on the server and they connect to an entry from the local hosts
> table. The reason for this is that each of the DEV, QA and PROD
> servers in this group have an entry with the same name (ex. SVR_DBNAME)
> but each of which point to their own IP address, allowing us to copy
> the packages between servers without going back and changing all the
> server name references.
> Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> DTS packages - which use WIndows Authentication - failed with a message
> indicating that the system could not authenticate against the local
> Windows user:
> Login failed for user '(null)'
> Once SP1 was removed, the packages resumed working. What setting does
> the service pack change that is causing this?
> thanks
> mark
>|||Q1) mixed mode authentication is used
Q2) the windows account is a member of the local administrators group
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> A couple of questions
> Does the server/s have Mixed authentication mode or windows only?
> Did you try ( If I understood correctly) to add an owner of DTS Packages
to
> the group of Admin of WIN2K3?
>
>
>
> <markfcook@.gmail.com> wrote in message
> news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
edition serving as a development server. There are several DTS packages
hosted on the server and they connect to an entry from the local hosts
table. The reason for this is that each of the DEV, QA and PROD
servers in this group have an entry with the same name (ex. SVR_DBNAME)
but each of which point to their own IP address, allowing us to copy
the packages between servers without going back and changing all the
server name references.
Recently, WIN2K3 SP1 was installed on the machine and immediately, the
DTS packages - which use WIndows Authentication - failed with a message
indicating that the system could not authenticate against the local
Windows user:
Login failed for user '(null)'
Once SP1 was removed, the packages resumed working. What setting does
the service pack change that is causing this?
thanks
markHi
A couple of questions
Does the server/s have Mixed authentication mode or windows only?
Did you try ( If I understood correctly) to add an owner of DTS Packages to
the group of Admin of WIN2K3?
<markfcook@.gmail.com> wrote in message
news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
> We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> edition serving as a development server. There are several DTS packages
> hosted on the server and they connect to an entry from the local hosts
> table. The reason for this is that each of the DEV, QA and PROD
> servers in this group have an entry with the same name (ex. SVR_DBNAME)
> but each of which point to their own IP address, allowing us to copy
> the packages between servers without going back and changing all the
> server name references.
> Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> DTS packages - which use WIndows Authentication - failed with a message
> indicating that the system could not authenticate against the local
> Windows user:
> Login failed for user '(null)'
> Once SP1 was removed, the packages resumed working. What setting does
> the service pack change that is causing this?
> thanks
> mark
>|||Q1) mixed mode authentication is used
Q2) the windows account is a member of the local administrators group
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> A couple of questions
> Does the server/s have Mixed authentication mode or windows only?
> Did you try ( If I understood correctly) to add an owner of DTS Packages
to
> the group of Admin of WIN2K3?
>
>
>
> <markfcook@.gmail.com> wrote in message
> news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
MSSQL2K and WIN2K3 SP1
We have a Windows Server 2003 Standard with SQL Server 2000 Standard
edition serving as a development server. There are several DTS packages
hosted on the server and they connect to an entry from the local hosts
table. The reason for this is that each of the DEV, QA and PROD
servers in this group have an entry with the same name (ex. SVR_DBNAME)
but each of which point to their own IP address, allowing us to copy
the packages between servers without going back and changing all the
server name references.
Recently, WIN2K3 SP1 was installed on the machine and immediately, the
DTS packages - which use WIndows Authentication - failed with a message
indicating that the system could not authenticate against the local
Windows user:
Login failed for user '(null)'
Once SP1 was removed, the packages resumed working. What setting does
the service pack change that is causing this?
thanks
markHi
A couple of questions
Does the server/s have Mixed authentication mode or windows only?
Did you try ( If I understood correctly) to add an owner of DTS Packages to
the group of Admin of WIN2K3?
<markfcook@.gmail.com> wrote in message
news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
> We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> edition serving as a development server. There are several DTS packages
> hosted on the server and they connect to an entry from the local hosts
> table. The reason for this is that each of the DEV, QA and PROD
> servers in this group have an entry with the same name (ex. SVR_DBNAME)
> but each of which point to their own IP address, allowing us to copy
> the packages between servers without going back and changing all the
> server name references.
> Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> DTS packages - which use WIndows Authentication - failed with a message
> indicating that the system could not authenticate against the local
> Windows user:
> Login failed for user '(null)'
> Once SP1 was removed, the packages resumed working. What setting does
> the service pack change that is causing this?
> thanks
> mark
>|||Q1) mixed mode authentication is used
Q2) the windows account is a member of the local administrators group
Uri Dimant wrote:
> Hi
> A couple of questions
> Does the server/s have Mixed authentication mode or windows only?
> Did you try ( If I understood correctly) to add an owner of DTS Packages to
> the group of Admin of WIN2K3?
>
>
>
> <markfcook@.gmail.com> wrote in message
> news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
> > We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> > edition serving as a development server. There are several DTS packages
> > hosted on the server and they connect to an entry from the local hosts
> > table. The reason for this is that each of the DEV, QA and PROD
> > servers in this group have an entry with the same name (ex. SVR_DBNAME)
> > but each of which point to their own IP address, allowing us to copy
> > the packages between servers without going back and changing all the
> > server name references.
> >
> > Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> > DTS packages - which use WIndows Authentication - failed with a message
> > indicating that the system could not authenticate against the local
> > Windows user:
> >
> > Login failed for user '(null)'
> >
> > Once SP1 was removed, the packages resumed working. What setting does
> > the service pack change that is causing this?
> >
> > thanks
> >
> > mark
> >
edition serving as a development server. There are several DTS packages
hosted on the server and they connect to an entry from the local hosts
table. The reason for this is that each of the DEV, QA and PROD
servers in this group have an entry with the same name (ex. SVR_DBNAME)
but each of which point to their own IP address, allowing us to copy
the packages between servers without going back and changing all the
server name references.
Recently, WIN2K3 SP1 was installed on the machine and immediately, the
DTS packages - which use WIndows Authentication - failed with a message
indicating that the system could not authenticate against the local
Windows user:
Login failed for user '(null)'
Once SP1 was removed, the packages resumed working. What setting does
the service pack change that is causing this?
thanks
markHi
A couple of questions
Does the server/s have Mixed authentication mode or windows only?
Did you try ( If I understood correctly) to add an owner of DTS Packages to
the group of Admin of WIN2K3?
<markfcook@.gmail.com> wrote in message
news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
> We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> edition serving as a development server. There are several DTS packages
> hosted on the server and they connect to an entry from the local hosts
> table. The reason for this is that each of the DEV, QA and PROD
> servers in this group have an entry with the same name (ex. SVR_DBNAME)
> but each of which point to their own IP address, allowing us to copy
> the packages between servers without going back and changing all the
> server name references.
> Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> DTS packages - which use WIndows Authentication - failed with a message
> indicating that the system could not authenticate against the local
> Windows user:
> Login failed for user '(null)'
> Once SP1 was removed, the packages resumed working. What setting does
> the service pack change that is causing this?
> thanks
> mark
>|||Q1) mixed mode authentication is used
Q2) the windows account is a member of the local administrators group
Uri Dimant wrote:
> Hi
> A couple of questions
> Does the server/s have Mixed authentication mode or windows only?
> Did you try ( If I understood correctly) to add an owner of DTS Packages to
> the group of Admin of WIN2K3?
>
>
>
> <markfcook@.gmail.com> wrote in message
> news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
> > We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> > edition serving as a development server. There are several DTS packages
> > hosted on the server and they connect to an entry from the local hosts
> > table. The reason for this is that each of the DEV, QA and PROD
> > servers in this group have an entry with the same name (ex. SVR_DBNAME)
> > but each of which point to their own IP address, allowing us to copy
> > the packages between servers without going back and changing all the
> > server name references.
> >
> > Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> > DTS packages - which use WIndows Authentication - failed with a message
> > indicating that the system could not authenticate against the local
> > Windows user:
> >
> > Login failed for user '(null)'
> >
> > Once SP1 was removed, the packages resumed working. What setting does
> > the service pack change that is causing this?
> >
> > thanks
> >
> > mark
> >
MSSQL2K and MSSQL side by side in clustered environment
I haven't been able to find any publications on Internet regarding my concern.
We have a MS SQL2K installation in a clustered environment, and would like
to migrate to MS SQL2K5 using a side-by-side installation. To my knowledge,
this should be possible. Could you please direct me to any documents
describing how to perform this task. Is it as easy as creating two new
resource groups (we're using two instances for the MS SQL2K installation
today), create the necessary resources (sql name, sql ip, services and
disks), and installing MS SQL2K5 to a different location than the current
installation? The operative system on the servers are Windows 2003 Enterprise
Edition and the MS SQL 2K5 Server edition we intend to use is the Enterprise
edition.
Yes, you can do this. You need to create a new group which has disks which
have not been used for any other SQL Server Virtual. Then install a new SQL
Server 2005 Virtual. (It will need a new name and new IP address.) Once
installed, you can finish the migration by using either attach/detach or
backup/restore. You can also minimize the amount of time the migration
takes by implementing either log shipping or replication from SQL Server
2000 to 2005 and then cutting over where they are synchronized.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:CF3CA7C9-DEE9-41DF-9C0C-FBF48B93156E@.microsoft.com...
>I haven't been able to find any publications on Internet regarding my
>concern.
> We have a MS SQL2K installation in a clustered environment, and would like
> to migrate to MS SQL2K5 using a side-by-side installation. To my
> knowledge,
> this should be possible. Could you please direct me to any documents
> describing how to perform this task. Is it as easy as creating two new
> resource groups (we're using two instances for the MS SQL2K installation
> today), create the necessary resources (sql name, sql ip, services and
> disks), and installing MS SQL2K5 to a different location than the current
> installation? The operative system on the servers are Windows 2003
> Enterprise
> Edition and the MS SQL 2K5 Server edition we intend to use is the
> Enterprise
> edition.
|||Thanks for your answer :D
I've successfully managed to create a new cluster resource group, and have
created a disk resource, an ip address resource and a network name resource
(is this what you referring to as SQL Server Virtual?). I manage to
failover/move group resources to the other node and back again. I am able to
ping the Network Name which responds well and translates to the correct IP
address, so the cluster seems to be fine. When I run the SQL Server 2005
Enterprise Edition setup program, I am required to install ASP .Net 2.0, SQL
Native Client + Setup Component files, this works fine. When I click next and
the installation program performs a system check, the application seem to
work for a while, and then I get the following error message:
There was an unexpected failure during the setup wizard. You may review the
setup logs and/or click the help button for more information.
For help, click:
http://go.microsoft.com/fwlink?LinkI...d Disks%400x2
The bootstrap log files contain some error messages, listed below:
Error: Action "LaunchLocalBootstrapAction" threw an exception during
execution. Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe"
finished and returned: 3221225477
Aborting queue processing as nested installer has completed
Message pump returning: 3221225477
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Exception record 0
Exception Code 0xc0000005
Exception Flags 0
Exception Address 0x498E4A04
Number of parameters 2
Parameter 0: 0x0
Parameter 1: 0x4
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\DbgHelp.dll Version:6.5.3.7
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0.log" to cab
file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0 LangPack.log"
to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade
Advisor.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade Advisor
LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
Installer.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows Installer
LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_SCC.log" to cab file :
"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 32
Running: UploadDrWatsonLogAction at: 2006/0/4 9:56:22
Message pump returning: 3221225477
Does any of you have experienced the setup program experiencing a unexpected
failure? Any ideas that can solve my installation problems are welcome.
Thanks,
Bj?rn
"Michael Hotek" skrev:
> Yes, you can do this. You need to create a new group which has disks which
> have not been used for any other SQL Server Virtual. Then install a new SQL
> Server 2005 Virtual. (It will need a new name and new IP address.) Once
> installed, you can finish the migration by using either attach/detach or
> backup/restore. You can also minimize the amount of time the migration
> takes by implementing either log shipping or replication from SQL Server
> 2000 to 2005 and then cutting over where they are synchronized.
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Bj?rn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
> message news:CF3CA7C9-DEE9-41DF-9C0C-FBF48B93156E@.microsoft.com...
>
>
|||You need to start out with a disk resource in its own resource group. The
Network Name and IP address resource for the clustered SQL instance are
created by the installer. It appears that the installer sees a complete
virtual server, although without SQL, and is having problems installing to
that resource group.
Also, the installer will crash if there is any clustered resource currently
offline.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...[vbcol=seagreen]
> Thanks for your answer :D
> I've successfully managed to create a new cluster resource group, and have
> created a disk resource, an ip address resource and a network name
> resource
> (is this what you referring to as SQL Server Virtual?). I manage to
> failover/move group resources to the other node and back again. I am able
> to
> ping the Network Name which responds well and translates to the correct IP
> address, so the cluster seems to be fine. When I run the SQL Server 2005
> Enterprise Edition setup program, I am required to install ASP .Net 2.0,
> SQL
> Native Client + Setup Component files, this works fine. When I click next
> and
> the installation program performs a system check, the application seem to
> work for a while, and then I get the following error message:
> There was an unexpected failure during the setup wizard. You may review
> the
> setup logs and/or click the help button for more information.
> For help, click:
> http://go.microsoft.com/fwlink?LinkI...d Disks%400x2
> The bootstrap log files contain some error messages, listed below:
> Error: Action "LaunchLocalBootstrapAction" threw an exception during
> execution. Error information reported during run:
> "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe"
> finished and returned: 3221225477
> Aborting queue processing as nested installer has completed
> Message pump returning: 3221225477
> Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\sqlsval.dll Version:2005.90.1399.0
> Error: Action "InvokeSqlSetupDllAction" threw an exception during
> execution.
> Exception record 0
> Exception Code 0xc0000005
> Exception Flags 0
> Exception Address 0x498E4A04
> Number of parameters 2
> Parameter 0: 0x0
> Parameter 1: 0x4
> Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\DbgHelp.dll Version:6.5.3.7
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0.log" to cab
> file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0
> LangPack.log"
> to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade
> Advisor.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade Advisor
> LangPack.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
> Installer.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
> Installer
> LangPack.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_SCC.log" to cab file :
> "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 32
> Running: UploadDrWatsonLogAction at: 2006/0/4 9:56:22
> Message pump returning: 3221225477
> Does any of you have experienced the setup program experiencing a
> unexpected
> failure? Any ideas that can solve my installation problems are welcome.
> Thanks,
> Bjrn
> "Michael Hotek" skrev:
|||You also want to run the .Net Framework 2.0 install on all nodes in the
cluster. It will REALLY speed up the install.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...[vbcol=seagreen]
> Thanks for your answer :D
> I've successfully managed to create a new cluster resource group, and have
> created a disk resource, an ip address resource and a network name
> resource
> (is this what you referring to as SQL Server Virtual?). I manage to
> failover/move group resources to the other node and back again. I am able
> to
> ping the Network Name which responds well and translates to the correct IP
> address, so the cluster seems to be fine. When I run the SQL Server 2005
> Enterprise Edition setup program, I am required to install ASP .Net 2.0,
> SQL
> Native Client + Setup Component files, this works fine. When I click next
> and
> the installation program performs a system check, the application seem to
> work for a while, and then I get the following error message:
> There was an unexpected failure during the setup wizard. You may review
> the
> setup logs and/or click the help button for more information.
> For help, click:
> http://go.microsoft.com/fwlink?LinkI...d Disks%400x2
> The bootstrap log files contain some error messages, listed below:
> Error: Action "LaunchLocalBootstrapAction" threw an exception during
> execution. Error information reported during run:
> "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe"
> finished and returned: 3221225477
> Aborting queue processing as nested installer has completed
> Message pump returning: 3221225477
> Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\sqlsval.dll Version:2005.90.1399.0
> Error: Action "InvokeSqlSetupDllAction" threw an exception during
> execution.
> Exception record 0
> Exception Code 0xc0000005
> Exception Flags 0
> Exception Address 0x498E4A04
> Number of parameters 2
> Parameter 0: 0x0
> Parameter 1: 0x4
> Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\DbgHelp.dll Version:6.5.3.7
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0.log" to cab
> file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0
> LangPack.log"
> to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade
> Advisor.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade Advisor
> LangPack.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
> Installer.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
> Installer
> LangPack.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_SCC.log" to cab file :
> "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 32
> Running: UploadDrWatsonLogAction at: 2006/0/4 9:56:22
> Message pump returning: 3221225477
> Does any of you have experienced the setup program experiencing a
> unexpected
> failure? Any ideas that can solve my installation problems are welcome.
> Thanks,
> Bjrn
> "Michael Hotek" skrev:
|||We have 3 disk resources in a cluster group dedicated to the SQL Server 2005
installation.
We did try the installation without having sql network name and ip address
preconfigured as resources, same result.
Does the installation crashing apply to other cluster groups (other
instances) having offline resources?
"Geoff N. Hiten" skrev:
> You need to start out with a disk resource in its own resource group. The
> Network Name and IP address resource for the clustered SQL instance are
> created by the installer. It appears that the installer sees a complete
> virtual server, although without SQL, and is having problems installing to
> that resource group.
> Also, the installer will crash if there is any clustered resource currently
> offline.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Bj?rn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
> message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...
>
>
|||Ok, I thought the installation would take care of this for me. I will try
installing ASP .Net on the other node,
would it be a good thing to install the SQL native client on the other node
too?
Thanks,
Bj?rn
"Michael Hotek" skrev:
> You also want to run the .Net Framework 2.0 install on all nodes in the
> cluster. It will REALLY speed up the install.
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Bj?rn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
> message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...
>
>
|||Yes. If the cluster has any resource or resource group offline, the SQL
installer will crash. The SQL installer tries to enumerate resources and
properties during a cluster install and fails badly if anything is offline.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:F16A596E-7B06-47F9-B416-CF4FD897B0A8@.microsoft.com...[vbcol=seagreen]
> We have 3 disk resources in a cluster group dedicated to the SQL Server
> 2005
> installation.
> We did try the installation without having sql network name and ip address
> preconfigured as resources, same result.
> Does the installation crashing apply to other cluster groups (other
> instances) having offline resources?
> "Geoff N. Hiten" skrev:
|||I have installed the following environment:
MS Windows 2003 EE + MS SQL Server 2005 EE
Services not installed:
Analysis services
Reporting services
At the end of the first named instance installation I get the same
error/alert messages.
I have tried some SQL Server operations and tested the fail-over
cluster and everything seems to be working fine.
I will carry some more tests but If I didn't get any operational
errors I will passed to production environment at the end of the week.
We have a MS SQL2K installation in a clustered environment, and would like
to migrate to MS SQL2K5 using a side-by-side installation. To my knowledge,
this should be possible. Could you please direct me to any documents
describing how to perform this task. Is it as easy as creating two new
resource groups (we're using two instances for the MS SQL2K installation
today), create the necessary resources (sql name, sql ip, services and
disks), and installing MS SQL2K5 to a different location than the current
installation? The operative system on the servers are Windows 2003 Enterprise
Edition and the MS SQL 2K5 Server edition we intend to use is the Enterprise
edition.
Yes, you can do this. You need to create a new group which has disks which
have not been used for any other SQL Server Virtual. Then install a new SQL
Server 2005 Virtual. (It will need a new name and new IP address.) Once
installed, you can finish the migration by using either attach/detach or
backup/restore. You can also minimize the amount of time the migration
takes by implementing either log shipping or replication from SQL Server
2000 to 2005 and then cutting over where they are synchronized.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:CF3CA7C9-DEE9-41DF-9C0C-FBF48B93156E@.microsoft.com...
>I haven't been able to find any publications on Internet regarding my
>concern.
> We have a MS SQL2K installation in a clustered environment, and would like
> to migrate to MS SQL2K5 using a side-by-side installation. To my
> knowledge,
> this should be possible. Could you please direct me to any documents
> describing how to perform this task. Is it as easy as creating two new
> resource groups (we're using two instances for the MS SQL2K installation
> today), create the necessary resources (sql name, sql ip, services and
> disks), and installing MS SQL2K5 to a different location than the current
> installation? The operative system on the servers are Windows 2003
> Enterprise
> Edition and the MS SQL 2K5 Server edition we intend to use is the
> Enterprise
> edition.
|||Thanks for your answer :D
I've successfully managed to create a new cluster resource group, and have
created a disk resource, an ip address resource and a network name resource
(is this what you referring to as SQL Server Virtual?). I manage to
failover/move group resources to the other node and back again. I am able to
ping the Network Name which responds well and translates to the correct IP
address, so the cluster seems to be fine. When I run the SQL Server 2005
Enterprise Edition setup program, I am required to install ASP .Net 2.0, SQL
Native Client + Setup Component files, this works fine. When I click next and
the installation program performs a system check, the application seem to
work for a while, and then I get the following error message:
There was an unexpected failure during the setup wizard. You may review the
setup logs and/or click the help button for more information.
For help, click:
http://go.microsoft.com/fwlink?LinkI...d Disks%400x2
The bootstrap log files contain some error messages, listed below:
Error: Action "LaunchLocalBootstrapAction" threw an exception during
execution. Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe"
finished and returned: 3221225477
Aborting queue processing as nested installer has completed
Message pump returning: 3221225477
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Exception record 0
Exception Code 0xc0000005
Exception Flags 0
Exception Address 0x498E4A04
Number of parameters 2
Parameter 0: 0x0
Parameter 1: 0x4
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\DbgHelp.dll Version:6.5.3.7
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0.log" to cab
file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0 LangPack.log"
to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade
Advisor.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade Advisor
LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
Installer.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows Installer
LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_SCC.log" to cab file :
"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 32
Running: UploadDrWatsonLogAction at: 2006/0/4 9:56:22
Message pump returning: 3221225477
Does any of you have experienced the setup program experiencing a unexpected
failure? Any ideas that can solve my installation problems are welcome.
Thanks,
Bj?rn
"Michael Hotek" skrev:
> Yes, you can do this. You need to create a new group which has disks which
> have not been used for any other SQL Server Virtual. Then install a new SQL
> Server 2005 Virtual. (It will need a new name and new IP address.) Once
> installed, you can finish the migration by using either attach/detach or
> backup/restore. You can also minimize the amount of time the migration
> takes by implementing either log shipping or replication from SQL Server
> 2000 to 2005 and then cutting over where they are synchronized.
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Bj?rn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
> message news:CF3CA7C9-DEE9-41DF-9C0C-FBF48B93156E@.microsoft.com...
>
>
|||You need to start out with a disk resource in its own resource group. The
Network Name and IP address resource for the clustered SQL instance are
created by the installer. It appears that the installer sees a complete
virtual server, although without SQL, and is having problems installing to
that resource group.
Also, the installer will crash if there is any clustered resource currently
offline.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...[vbcol=seagreen]
> Thanks for your answer :D
> I've successfully managed to create a new cluster resource group, and have
> created a disk resource, an ip address resource and a network name
> resource
> (is this what you referring to as SQL Server Virtual?). I manage to
> failover/move group resources to the other node and back again. I am able
> to
> ping the Network Name which responds well and translates to the correct IP
> address, so the cluster seems to be fine. When I run the SQL Server 2005
> Enterprise Edition setup program, I am required to install ASP .Net 2.0,
> SQL
> Native Client + Setup Component files, this works fine. When I click next
> and
> the installation program performs a system check, the application seem to
> work for a while, and then I get the following error message:
> There was an unexpected failure during the setup wizard. You may review
> the
> setup logs and/or click the help button for more information.
> For help, click:
> http://go.microsoft.com/fwlink?LinkI...d Disks%400x2
> The bootstrap log files contain some error messages, listed below:
> Error: Action "LaunchLocalBootstrapAction" threw an exception during
> execution. Error information reported during run:
> "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe"
> finished and returned: 3221225477
> Aborting queue processing as nested installer has completed
> Message pump returning: 3221225477
> Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\sqlsval.dll Version:2005.90.1399.0
> Error: Action "InvokeSqlSetupDllAction" threw an exception during
> execution.
> Exception record 0
> Exception Code 0xc0000005
> Exception Flags 0
> Exception Address 0x498E4A04
> Number of parameters 2
> Parameter 0: 0x0
> Parameter 1: 0x4
> Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\DbgHelp.dll Version:6.5.3.7
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0.log" to cab
> file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0
> LangPack.log"
> to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade
> Advisor.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade Advisor
> LangPack.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
> Installer.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
> Installer
> LangPack.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_SCC.log" to cab file :
> "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 32
> Running: UploadDrWatsonLogAction at: 2006/0/4 9:56:22
> Message pump returning: 3221225477
> Does any of you have experienced the setup program experiencing a
> unexpected
> failure? Any ideas that can solve my installation problems are welcome.
> Thanks,
> Bjrn
> "Michael Hotek" skrev:
|||You also want to run the .Net Framework 2.0 install on all nodes in the
cluster. It will REALLY speed up the install.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...[vbcol=seagreen]
> Thanks for your answer :D
> I've successfully managed to create a new cluster resource group, and have
> created a disk resource, an ip address resource and a network name
> resource
> (is this what you referring to as SQL Server Virtual?). I manage to
> failover/move group resources to the other node and back again. I am able
> to
> ping the Network Name which responds well and translates to the correct IP
> address, so the cluster seems to be fine. When I run the SQL Server 2005
> Enterprise Edition setup program, I am required to install ASP .Net 2.0,
> SQL
> Native Client + Setup Component files, this works fine. When I click next
> and
> the installation program performs a system check, the application seem to
> work for a while, and then I get the following error message:
> There was an unexpected failure during the setup wizard. You may review
> the
> setup logs and/or click the help button for more information.
> For help, click:
> http://go.microsoft.com/fwlink?LinkI...d Disks%400x2
> The bootstrap log files contain some error messages, listed below:
> Error: Action "LaunchLocalBootstrapAction" threw an exception during
> execution. Error information reported during run:
> "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe"
> finished and returned: 3221225477
> Aborting queue processing as nested installer has completed
> Message pump returning: 3221225477
> Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\sqlsval.dll Version:2005.90.1399.0
> Error: Action "InvokeSqlSetupDllAction" threw an exception during
> execution.
> Exception record 0
> Exception Code 0xc0000005
> Exception Flags 0
> Exception Address 0x498E4A04
> Number of parameters 2
> Parameter 0: 0x0
> Parameter 1: 0x4
> Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\DbgHelp.dll Version:6.5.3.7
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0.log" to cab
> file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0
> LangPack.log"
> to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade
> Advisor.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade Advisor
> LangPack.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
> Installer.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
> Installer
> LangPack.log" to cab file : "C:\Program Files\Microsoft SQL
> Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
> Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_SCC.log" to cab file :
> "C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\SqlSetup0016.cab" Error Code : 32
> Running: UploadDrWatsonLogAction at: 2006/0/4 9:56:22
> Message pump returning: 3221225477
> Does any of you have experienced the setup program experiencing a
> unexpected
> failure? Any ideas that can solve my installation problems are welcome.
> Thanks,
> Bjrn
> "Michael Hotek" skrev:
|||We have 3 disk resources in a cluster group dedicated to the SQL Server 2005
installation.
We did try the installation without having sql network name and ip address
preconfigured as resources, same result.
Does the installation crashing apply to other cluster groups (other
instances) having offline resources?
"Geoff N. Hiten" skrev:
> You need to start out with a disk resource in its own resource group. The
> Network Name and IP address resource for the clustered SQL instance are
> created by the installer. It appears that the installer sees a complete
> virtual server, although without SQL, and is having problems installing to
> that resource group.
> Also, the installer will crash if there is any clustered resource currently
> offline.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Bj?rn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
> message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...
>
>
|||Ok, I thought the installation would take care of this for me. I will try
installing ASP .Net on the other node,
would it be a good thing to install the SQL native client on the other node
too?
Thanks,
Bj?rn
"Michael Hotek" skrev:
> You also want to run the .Net Framework 2.0 install on all nodes in the
> cluster. It will REALLY speed up the install.
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Bj?rn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
> message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...
>
>
|||Yes. If the cluster has any resource or resource group offline, the SQL
installer will crash. The SQL installer tries to enumerate resources and
properties during a cluster install and fails badly if anything is offline.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:F16A596E-7B06-47F9-B416-CF4FD897B0A8@.microsoft.com...[vbcol=seagreen]
> We have 3 disk resources in a cluster group dedicated to the SQL Server
> 2005
> installation.
> We did try the installation without having sql network name and ip address
> preconfigured as resources, same result.
> Does the installation crashing apply to other cluster groups (other
> instances) having offline resources?
> "Geoff N. Hiten" skrev:
|||I have installed the following environment:
MS Windows 2003 EE + MS SQL Server 2005 EE
Services not installed:
Analysis services
Reporting services
At the end of the first named instance installation I get the same
error/alert messages.
I have tried some SQL Server operations and tested the fail-over
cluster and everything seems to be working fine.
I will carry some more tests but If I didn't get any operational
errors I will passed to production environment at the end of the week.
Subscribe to:
Posts (Atom)