is it maintenance plan bug?

When I run Integrity check with option attempt to repair
minor problem seems like there is no integrity checking on
databases whic are not in single user mode.
If I disable that option seems that integrity checking is
running.
Also Inegrity Check jobs doesn't report any error but when
I run dbcc checkdb from analyzer I can see 2-3 2511 errors.
Is the Maintenance plan realy reliable or I should
schedule job to run dbcc checkdb. We are running SQL7 sp3
on W2000.
ThanksWe are running dbcc dbreindex on every table in the
database, after Integrity Checks, Is it possible that
index corruption is generated from reindexing command?
Thanks
>--Original Message--
>It is advisable not to have the attempt to repair minor
problems option set
>in the maintenance paln and this issue with it having to
be in single user
>mode is one of the main reasons. Generally it either
can't get it into
>single user mode and fails or leaves it in single user
mode after it
>finishes, neither of which is desirable. With regard to
your specific
>errors, have your tried dropping and creating the indexes
affected
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"milan" <mmirce01@.yahoo.ca> wrote in message
>news:034201c3507b$2a92a940$a101280a@.phx.gbl...
>When I run Integrity check with option attempt to repair
>minor problem seems like there is no integrity checking on
>databases whic are not in single user mode.
>If I disable that option seems that integrity checking is
>running.
>Also Inegrity Check jobs doesn't report any error but when
>I run dbcc checkdb from analyzer I can see 2-3 2511
errors.
>Is the Maintenance plan realy reliable or I should
>schedule job to run dbcc checkdb. We are running SQL7 sp3
>on W2000.
>Thanks
>
>.
>

Is it easy to upgrade from MSDE to Full blown SQL v2000

Hi,

Noob here....

Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it.

Also, don't remember getting a keycode with the CD - is this right?

Thanks for help :)

Kenny

(bump)

anyone?

|||

I have gone from 2000 msde to 2000 developers edition and never had a problem.

Do a backup of your databases and give it a try.

|||

I wish I had the same easy experience. So far my upgrade from MSDE 2k to full SQL never gives me the "Upgrade" option. I have to install a new instance.

This is in the course of migrating a SharePoint Services installation from the default MSDE database to SQL.

As this test server had SharePoint portal uninstalled and SQL 2k developer uninstalled, then SharePoint Services by themselves re installed, I wonder if the install wizard just somehow does not see the MSDE instance.

My co workers think I am making this up.. Any ideas as to why no upgrade?

Is it easy to upgrade from MSDE to Full blown SQL v2000

Hi,

Noob here....

Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it.

Also, don't remember getting a keycode with the CD - is this right?

Thanks for help :)

Kenny

(bump)

anyone?

|||

I have gone from 2000 msde to 2000 developers edition and never had a problem.

Do a backup of your databases and give it a try.

|||

I wish I had the same easy experience. So far my upgrade from MSDE 2k to full SQL never gives me the "Upgrade" option. I have to install a new instance.

This is in the course of migrating a SharePoint Services installation from the default MSDE database to SQL.

As this test server had SharePoint portal uninstalled and SQL 2k developer uninstalled, then SharePoint Services by themselves re installed, I wonder if the install wizard just somehow does not see the MSDE instance.

My co workers think I am making this up.. Any ideas as to why no upgrade?

Is it easy to upgrade from MSDE to Full blown SQL v2000

Hi,

Noob here....

Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it.

Also, don't remember getting a keycode with the CD - is this right?

Thanks for help :)

Kenny

(bump)

anyone?

|||

I have gone from 2000 msde to 2000 developers edition and never had a problem.

Do a backup of your databases and give it a try.

|||

I wish I had the same easy experience. So far my upgrade from MSDE 2k to full SQL never gives me the "Upgrade" option. I have to install a new instance.

This is in the course of migrating a SharePoint Services installation from the default MSDE database to SQL.

As this test server had SharePoint portal uninstalled and SQL 2k developer uninstalled, then SharePoint Services by themselves re installed, I wonder if the install wizard just somehow does not see the MSDE instance.

My co workers think I am making this up.. Any ideas as to why no upgrade?