Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql database recovery? Expand / Collapse
Author
Message
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


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 42,466, Visits: 35,530
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 2008, MVP
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 11:13 AM
Points: 15,527, Visits: 27,909
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

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

Add to briefcase

Permissions Expand / Collapse