May 30, 2002 at 4:15 am
I was away last week and sql crashed due to a strange power failure.
Anyway I want to do a full system sweep checking that all data was recovered and all the system is in working order.
Can anyone put me onto some general practices to make sure all is good as we have an accoutning system running off sql that may be acting a bit strange..
Thanks
scott
May 30, 2002 at 5:30 am
DBCC Checkdb on each db should do it, along with maybe a disk check by NT. Other than that I'd double check that backups are good and try to find a way to prevent the power problem from happening again!
Andy
May 30, 2002 at 6:58 am
Thanks Andy
Have run this routine and all seems ok
Scott
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply