No announcements
Found 2207279 threads
-
3 VotesRecover a Shift+Deleted SQL mdf File
MDF files get damaged due to slow running of SQL Server, virus codes, accidental deletion of files and other factors.Answered | 7 Replies | 13619 Views | Created by Alexandre_M - Thursday, December 27, 2012 3:20 PM | Last reply by - Monday, August 11, 2014 11:44 AM
-
1 Votes
How to recover .mdf file database?
Update=1 http://www.techrepublic.com/forums/questions/how-to-recover-mdf-file-database/ http://answers.oreilly.com/topic/22717-how-to-Answered | 5 Replies | 3457 Views | Created by Tomas Travolta - Thursday, May 8, 2014 4:18 PM | Last reply by Markwillium - Thursday, May 15, 2014 5:40 AM -
5 Votes
Restore MDF file only from bak file
Had the same issue with a 250GB backup DB probible only taking 50GB and log taking 200GB.Answered | 10 Replies | 29982 Views | Created by Everest1980 - Tuesday, August 10, 2010 5:10 PM | Last reply by Giovanni Lucasta Bekker - Friday, January 6, 2012 12:37 PM -
0 Votes
How To Recover Data From A Corrupt Mdf File?
Then use some third-party tools to recover data from the disk image file.Answered | 6 Replies | 4752 Views | Created by Simonwel - Monday, September 22, 2014 7:33 AM | Last reply by retracement - Thursday, October 9, 2014 3:07 PM -
0 Votes
Recover database from .mdf and .ldf only in SQL2008
Also check the MDF/LDF file-level permissions and make sure the account running SQL Server Database Engine has read/write permissions.Answered | 1 Replies | 6789 Views | Created by coastaldamage - Friday, October 30, 2009 4:42 AM | Last reply by Varsham Papikian - Friday, October 30, 2009 5:34 AM -
0 Votes
Recovery with out mdf file
You have two options to recover your .mdf file, first one is to recover from latest backup that you have n't then you can try an advanced .Answered | 3 Replies | 8868 Views | Created by SQLdisciple - Monday, March 15, 2010 8:53 AM | Last reply by Markwillium - Monday, February 14, 2011 7:28 AM -
0 Votes
Revcover Data base from .mdf file only
Make sure that the file isn't read-only.Answered | 12 Replies | 990 Views | Created by Syed Faizan ur Rehman - Tuesday, December 6, 2016 10:22 AM | Last reply by Nani K - Tuesday, January 17, 2017 6:26 AM -
0 Votes
Recovering available data from corrupted .MDF file (MSSQL 2005)
Data from corrupt mdf file can be recovered by following methods: Repair MDF file with DBCC CHECKDB: Microsoft offers a command that is ...Answered | 4 Replies | 6734 Views | Created by KishoreKumar - Monday, June 14, 2010 1:42 PM | Last reply by MatthewOFarrell - Sunday, August 7, 2016 1:14 PM -
0 Votes
accidentally deleted mdf file
It recovers & restores lost, deleted, or formatted files from inaccessible drives such as hard drives, external hard drives, pen drives, etc.Answered | 6 Replies | 5434 Views | Created by Stan210 - Friday, January 6, 2012 12:16 AM | Last reply by Markwillium - Monday, January 9, 2012 4:05 AM -
0 Votes
MDF crashed
Hi Joseph, First thing, what made you think that your database mdf file is corrupted?Answered | 4 Replies | 3322 Views | Created by josephjoshua78 - Wednesday, July 20, 2011 12:06 PM | Last reply by Satya Krovvidi - Wednesday, July 20, 2011 7:57 PM -
0 Votes
.MDF file issue.
A recovery tool may be able to recover data, but keep that basically they only do the same as DBCC CHECKDB REPAIR.Answered | 15 Replies | 3209 Views | Created by MSDN_12345 - Thursday, January 30, 2014 1:41 PM | Last reply by Shanky_621 - Wednesday, February 5, 2014 9:04 AM -
3 Votes
Restore SSIS Catalog from MDF and LDF files
My problem though is that I don't have the .dstx packages on-hand since they seem to be inside the SSISDB, and I only have the MDF and LDF files to work ...Answered | 6 Replies | 1524 Views | Created by OCS.New - Thursday, June 6, 2019 9:34 AM | Last reply by OCS.New - Thursday, June 6, 2019 3:51 PM -
1 Votes
Reduce the Size of the MDF File
Increasing the size of a file is quite an expensive operation so its a good idea to minimise this (by setting appropriate file sizes on db creation to allow for growth) and ...Answered | 5 Replies | 9672 Views | Created by BjZoe - Monday, March 22, 2010 1:34 PM | Last reply by BjZoe - Wednesday, March 24, 2010 6:27 PM -
1 Votes
Restoring a DB thru the log file.
It looks like you still have MDF file otherwise application should not be able to see tables.Answered | 3 Replies | 7751 Views | Created by AlexBB - Vista Ult64 SqlSer64 WinSer64 - Saturday, May 16, 2009 4:57 PM | Last reply by AlexBB - Vista Ult64 SqlSer64 WinSer64 - Monday, May 18, 2009 12:15 AM -
1 Votes
Query mdf file directly
are those SQL Server MDF file or Access MDF ?Answered | 11 Replies | 7603 Views | Created by inevg - Wednesday, October 16, 2013 5:29 AM | Last reply by inevg - Tuesday, October 22, 2013 6:02 AM -
7 Votes
Unexpected Growth of MDF file
With EXEC sp_spaceused you can check the used / free space in the database to see if really used data size has been increased or ...Answered | 9 Replies | 3621 Views | Created by miruan - Monday, March 17, 2014 4:44 AM | Last reply by tracycai - Tuesday, March 18, 2014 8:27 AM -
1 Votes
How to create DB back from .mdf and .ldf (data and log file)?
my mdf file is stored in c:\\db\db.mdf i want to attach db and keep it here...Answered | 5 Replies | 5432 Views | Created by Futurevision - Wednesday, April 22, 2009 11:46 AM | Last reply by JeremyClassic - Thursday, April 23, 2009 9:26 PM -
0 Votes
Attach database with only MDF file
Hi Sandy, Why do you only have the data file?Answered | 3 Replies | 1130 Views | Created by Sandy_SQL_Geeks - Saturday, February 16, 2019 12:35 PM | Last reply by Dedmon Dai - Monday, February 18, 2019 2:15 AM -
3 Votes
How to kill a recovering db .
If you intend to restore from a backup, then one option could be to stop your SQL Server and delete the database files.Answered | 3 Replies | 801 Views | Created by MS_Prog - Wednesday, June 1, 2016 8:59 AM | Last reply by TiborK - Wednesday, June 1, 2016 8:38 PM -
1 Votes
Recover data from ldf file
You cannot attach LDF file directly but you can repair the corrupted MDF file attach it without LDF file.Answered | 5 Replies | 3229 Views | Created by Curendra - Friday, August 23, 2019 8:58 AM | Last reply by Robin Shanab - Tuesday, February 4, 2020 7:12 AM - Items 1 to 20 of 2207279 Next ›
No announcements
