Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Disappearing rows
Message
 
 
À
05/07/2017 16:58:20
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Dépannage
Divers
Thread ID:
01652445
Message ID:
01652448
Vues:
52
>>>This server has been in use since 2008
>>>Suddenly today, rows disappear.
>>>It might be a coincidence, but the rows seem to be disappearing after a backup occurs.
>>>Many backups have been made before with no issues.
>>>Any ideas?
>>
>>The question is unclear. Did you find some table(s) missing rows? If yes, how did you find it? Is it possible that these rows were deleted? Do you have any audit in place?
>
>Run a report
>Rows are there
>Back up the system
>Run a report
>Rows are gone
>No audit

1. Examine the backup job

2. In SSMS run the query that drives the report. Perhaps some parameters have changed.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform