September 26, 2017 at 12:42 pm
Our small company uses SQL Server 2008 during some years. Only some days ago we stumbled on a serious issue. Our general sql databases stopped showing data or information disappeared. We tried to apply backup, but it didn't help us.
I'm on2^.IpP
September 26, 2017 at 3:58 pm
The first thing I would do is a tail log backup and then restore your backups to a secondary system (if available) to see if there is any data in them.
If the secondary system has no data either, I'd run DBCC CHECKDB against the database to make sure it isn't corrupt.
I would also check the free space in the database to ensure that there is data in the database.
That being said, knowing what errors you get when you try to select data and when you tried to restore the backup would be beneficial.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 27, 2017 at 12:40 am
September 29, 2017 at 7:40 am
NabilAym - Tuesday, September 26, 2017 12:42 PMOur small company uses SQL Server 2008 during some years. Only some days ago we stumbled on a serious issue. Our general sql databases stopped showing data or information disappeared. We tried to apply backup, but it didn't help us.
I'm on2^.IpP
If you can’t open or repair .mdf via any method, in such case was created special instrument like repair ms sql database
Here are represented the models of sql recovery - https://www.mssqltips.com/sqlservertutorial/2/sql-server-recovery-models/
It is the address of the guide below: https://www.mssqltips.com/sqlservertutorial/112/recovering-a-database-that-is-in-the-restoring-state/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply