Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GRAYWOLF
Posting Yak Master
106 Posts |
 Posted - 2009-01-16 : 06:27:13
|
| Is there another way to test a DB besides "DBCC CHECKDB"?---------------------------Working until "the morning sun sets the midnight sky on fire"! |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-01-16 : 06:41:29
|
| Depends what you mean by "test", but CHECKDB will make sure that integrity of your data and index files are ok. But "testing a db" should also include testing connectivity, make sure backup/restore works fine, data integrity etc.- Lumbago |
 |
|
|
GRAYWOLF
Posting Yak Master
106 Posts |
Posted - 2009-01-16 : 07:02:45
|
| I have written a procedure to restore a DB, test it, and delete it. SQL Jobs seems to not like CHECKDB much. I was hoping there was another way to test the DB. This whole procedure is just supposed to do a simple check that the backups are good.---------------------------Working until "the morning sun sets the midnight sky on fire"! |
|
|
|
|
|
|
Testing a DB