to do a database repair on SQL server v7.
This is what I did
dbcc checkdb ('mydatabase', REPAIR_REBUILD) with estimateonly
It gave me error ...
estimateonly is not an option.
What did I do wrong? Thank you for your help!!!!!!!!!!It depends!|||What I want to do is to repair the database, but I want to
know ahead of time how long it will take.
Is there another way to do this?|||The ESTIMATEONLY clause was introduced in SQL-2000. If you are running SQL 7.0, that isn't a choice for you.
-PatP|||Thank you. Is there any way to estimate how long it
will take?|||There are ways, but the process usually runs very quickly and has zero impact on active users. I wouldn't worry about the time it will take because it isn't really significant... At least in my experience no one will realize you are running it, much less care.
-PatP|||It thought I have to change it to single-user mode in order to run dbcc checkdb
If I change it to single-user mode, only one user can use it.|||You CAN run it while database is in use, you'll just get a warning about "spureous" errors (check spelling, I am not sure).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment