By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,101 Members | 1,416 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,101 IT Pros & Developers. It's quick & easy.

Database sql server2000 very slow

P: n/a
I have a database that had worked under msde 1.0 until reached the 2GB
of dimension and the dB was blocked. To make possible the work i had
deleted old data from some table. The database restart, but the
answers from server become very slow. So i decided to pass to Sql
Server 2000 without success. May i perform a check of this database?
if is a indexs problem there is a way to rebuild them?
Thanks in advance
Andy Wet
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Andy Wet" <an******@yahoo.it> wrote in message
news:cb**************************@posting.google.c om...
I have a database that had worked under msde 1.0 until reached the 2GB
of dimension and the dB was blocked. To make possible the work i had
deleted old data from some table. The database restart, but the
answers from server become very slow. So i decided to pass to Sql
Server 2000 without success. May i perform a check of this database?
if is a indexs problem there is a way to rebuild them?
Thanks in advance
Andy Wet


Can you explain what you mean by 'passing to SQL Server 2000'? Did you try
to upgrade MSDE to Standard Edition, did you backup/restore your MSDE
database on another version, etc.?

It might be worth using sp_updatestats to update the statstics in the
database, and also DBCC CHECKDB, if you think the database may be corrupted.

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.