Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Sql database recovery? Expand / Collapse
Posted Thursday, February 13, 2014 10:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 10:54 AM
Points: 1, Visits: 0
Databases in my MS SQL Server 2014 have a condition - suspend, according to SQL Management Studio. I can't bring them into a work state through standard procedures. I used third-party tools, but they didn't give a result. Function "Database Utilities | Compact and Repair Database" doesn't work. How to extract data from corrupted databases?
Post #1541336
Posted Thursday, February 13, 2014 12:06 PM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
Compact and repair database is an MS Access feature, not a SQL Server one. It works on Access databases.

Can you be a little clearer about what you have (SQL Server or Access), what exactly is wrong, what the exact states things are in and all relevant errors?
Also, you're using a pre-release version of SQL Server 2014?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1541375
Posted Friday, February 14, 2014 4:28 AM



Group: General Forum Members
Last Login: Yesterday @ 4:52 AM
Points: 17,172, Visits: 32,134
Generally, this is when you go to your backups and restore the database to a point in time prior to the problem.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1541539
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse