September 1, 2017 at 8:43 am
Our small company uses SQL Server 2012 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.
September 1, 2017 at 9:04 am
HoneyMaliam - Friday, September 1, 2017 8:43 AMOur small company uses SQL Server 2012 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.
What do you mean the database stopped showing data or information disappeared? Is there still data in your tables? As it sits right now it is not at all clear what you need help with.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 6, 2017 at 8:49 pm
Looks like the data wasn't the only thing that disappeared. The OP has now gone missing.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 7, 2017 at 1:46 am
Jeff Moden - Wednesday, September 6, 2017 8:49 PMLooks like the data wasn't the only thing that disappeared. The OP has now gone missing.
Maybe they found their data hiding under the table ┌─â”. :hehe:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 9, 2017 at 7:47 am
If you can’t open or repair .mdf via any method, in such case was created special instrument like mssql repair 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/
Restore full backup WITH RECOVERY
As mentioned above this option is the default, but you can specify as follows.
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
WITH RECOVERY
GO
Recover a database that is in the "restoring" state
The following command will take a database that is in the "restoring" state and make it available for end users.
RESTORE DATABASE AdventureWorks WITH RECOVERY
GO
Restore multiple backups using WITH RECOVERY for last backup
The first restore uses the NORECOVERY option so additional restores can be done. The second command restores the transaction log and then brings the database online for end user use.
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
WITH NORECOVERY
GO
RESTORE LOG AdventureWorks FROM DISK = 'C:\AdventureWorks.TRN'
WITH RECOVERY
GO
September 13, 2017 at 10:51 am
ZalDastur - Saturday, September 9, 2017 7:47 AMIf you can’t open or repair .mdf via any method, in such case was created special instrument like mssql repair 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/Restore full backup WITH RECOVERY
As mentioned above this option is the default, but you can specify as follows.
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
WITH RECOVERY
GO
Recover a database that is in the "restoring" state
The following command will take a database that is in the "restoring" state and make it available for end users.
RESTORE DATABASE AdventureWorks WITH RECOVERY
GO
Restore multiple backups using WITH RECOVERY for last backup
The first restore uses the NORECOVERY option so additional restores can be done. The second command restores the transaction log and then brings the database online for end user use.
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
WITH NORECOVERY
GO
RESTORE LOG AdventureWorks FROM DISK = 'C:\AdventureWorks.TRN'
WITH RECOVERY
GO
This is surprisingly common, a new poster will post about data loss, and another new poster will reply with some options, typically one of them will link to a data recovery company's url.
I like the new presentable avatars in this one, its a nice touch!
September 13, 2017 at 12:18 pm
patrickmcginnis59 10839 - Wednesday, September 13, 2017 10:51 AMThis is surprisingly common, a new poster will post about data loss, and another new poster will reply with some options, typically one of them will link to a data recovery company's url.
I like the new presentable avatars in this one, its a nice touch!
Yeah it really seems like an elaborate spam to me.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply