Hi
Does anybody have any thoughts on this as it has happened twice now and i'm a little bit concerned
We are using SQL 2000
Basically, I leave it running, used and backed up etc.
Very occasionally, we have the need to create a new database - this highlights the problem
The last 2 times i've done this (6 months apart), i've found that spt_values on the master database is blank (only this table)
Consequently, I can't create the database
What I have also found is that a restoration does not work as the issue seems to occur (at some point?) within around a month of the previous issue - so the backup also has a blank spt_values table
Searching around I can't find anybody who has had a similar problem
We have virus scanned it and this is ongoing
Thanks
Damian.
Does anybody have any thoughts on this as it has happened twice now and i'm a little bit concerned
We are using SQL 2000
Basically, I leave it running, used and backed up etc.
Very occasionally, we have the need to create a new database - this highlights the problem
The last 2 times i've done this (6 months apart), i've found that spt_values on the master database is blank (only this table)
Consequently, I can't create the database
What I have also found is that a restoration does not work as the issue seems to occur (at some point?) within around a month of the previous issue - so the backup also has a blank spt_values table
Searching around I can't find anybody who has had a similar problem
We have virus scanned it and this is ongoing
Thanks
Damian.