Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disappearing rows
Message
From
05/07/2017 18:30:06
 
General information
Forum:
Microsoft SQL Server
Category:
Troubleshooting
Miscellaneous
Thread ID:
01652445
Message ID:
01652451
Views:
55
>>>>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

used ssms backup
>
>2. In SSMS run the query that drives the report. Perhaps some parameters have changed.

same results from the query window.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform