Viewing 15 posts - 211 through 225 (of 268 total)
To add to the already useful info on this thread...........
On EM if you click on Management ...
Current activity locks Process id that will
give you who is sitting on what...
November 24, 2003 at 7:49 am
Would be good .I believe if your database is configured to automatically update stats which is supposed to be a good config.
Then you may not have to worry too much...
November 24, 2003 at 7:33 am
Can tell you how I do it hope that helps in the littlest of ways
OS backup is done to tape daily and that lives for a defined amount...
November 21, 2003 at 1:04 pm
May be a lot more than the jobs could need taken care of at some time.Not trying to be persimistic
Mike
November 21, 2003 at 12:57 pm
select @@version will have a 64 in it else it is a 32 bit
Mike
November 21, 2003 at 12:54 pm
Another option might be google groups
comp databases oracle oracle server.
It is pretty organized too
Mike
November 21, 2003 at 12:52 pm
Again did you check the OS?Torn pages (When a partial page write to disk has occured) is an indication that your data is corrupt.
You may want to investigate more...
November 19, 2003 at 11:59 am
Could it be an OS issue?
Drop/recreate objects with 0 rows and run
checkdb again
Mike
November 19, 2003 at 8:28 am
Sounds like you got some corruption.
If dbcc checkdb is stuck before you get any better ideas what I have in mind would be to create a new
database, then...
November 19, 2003 at 8:10 am
To add a little to the much that has been said in response to your question.
Good and "tested" backup/recovery cannot be over-emphasized "DBA" work finally comes pretty...
November 19, 2003 at 7:54 am
Would the authors like to make available some pages of the SQLserver Standard on this forum?So whoever is interested can assess before subscribing for a year?
Mike
November 18, 2003 at 12:53 pm
It will be nice to know if the students in question need to be able to learn and be taught about sql server...
You could have a special lab in...
November 17, 2003 at 1:17 pm
I will say YES because we got caught by a bug lately and all we had to do was move to sp3a .
Mike
November 17, 2003 at 12:05 pm
Not had the exact same problem but happened to have come across similar situations and stayed with what worked while following up
with the vendor and they came out with...
November 17, 2003 at 12:02 pm
Are you doing nightly backups and have you configured files to be kept for a period of 24 hours?
If you have, is the available disk space able to succesfully...
November 17, 2003 at 11:51 am
Viewing 15 posts - 211 through 225 (of 268 total)