Advertisement
- Home
- Microsoft
- Development
- MS SQL Server
- SQL Server 2005
- SQL Server 2005 DBCC error
Advertisement
- 1. chapmandew 2,641,401
- 2. angelIII 2,084,960
- 3. mark_wills 686,867
- 4. BrandonG... 591,589
- 5. aneeshatti... 573,576
- 6. momi_sa... 420,024
- 7. mwvisa1 377,662
- 8. ee_rlee 324,111
- 9. dtodd 272,111
- 10. acperkins 267,108
- 11. brejk 265,744
- 12. EugeneZ 246,710
- 13. DanielWilson 236,044
- 14. rickchild 212,240
- 15. PedroCGD 190,659
- 16. bashka_... 188,518
- 17. ptjcb 180,291
- 18. dqmq 175,638
- 19. dportas 171,917
- 20. tedbilly 166,515
- 21. ScottPletc... 164,033
- 22. appari 162,877
- 23. Thomasian 157,542
- 24. matthews... 153,429
- 25. sbagireddi 148,982
- 1. angelIII 3,365,151
- 2. chapmandew 2,641,401
- 3. aneeshatti... 1,138,681
- 4. mark_wills 686,867
- 5. BrandonG... 591,589
- 6. ptjcb 545,683
- 7. Yveau 539,545
- 8. dtodd 483,116
- 9. dqmq 446,986
- 10. momi_sa... 421,724
- 11. PFrog 404,802
- 12. appari 399,024
- 13. mwvisa1 377,662
- 14. acperkins 362,447
- 15. imitchie 350,938
- 16. ee_rlee 324,111
- 17. DanielWilson 301,834
- 18. EugeneZ 283,419
- 19. matthews... 283,096
- 20. ScottPletc... 267,700
- 21. brejk 265,744
- 22. Lowfatsp... 235,725
- 23. tedbilly 234,854
- 24. nmcdermaid 220,973
- 25. dportas 215,882
| 06.26.2008 at 03:40PM PDT, ID: 23520089 | Points: 500 |
|
[x]
Attachment Details
|
||
SQL Server 2005 DBCC error
Asked by jnsimex in SQL Server 2005, MS SQL Server, Server Software
There are two SQL servers, the production (P) and the backup (B).
At night, there is a job that backs up P, copy the backed up file to B and B get restored.
As far as the backup and restore scripts are concerned,they both show the successful executions.
However, when I run the SQL statements with WHERE conditions, some tables returned the huge errors as shown in the attachment.
Start Free Trial
At night, there is a job that backs up P, copy the backed up file to B and B get restored.
As far as the backup and restore scripts are concerned,they both show the successful executions.
However, when I run the SQL statements with WHERE conditions, some tables returned the huge errors as shown in the attachment.
Start Free Trial
Attachments:
Loading Advertisement...
20081112-EE-VQP-42 / EE_QW_2_20070628
