Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 MDF database files and MTF backup format

Author  Topic 

roshana
Starting Member

31 Posts

Posted - 2010-03-12 : 07:21:03
Hi All,
We have one customer who is having MDF database files in MTF backup format.The MTF back file is corrupted ,how we can repair the MTF files.

Thanks,
Roshan

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2010-03-17 : 16:08:55
Google MTF files. It is most likely NOT a backp file, I found hits for a Motorola Theme file and recommendations to scan registry. Most sites I cannot hit at work, sorry. What leads you to believe the MTF is a backup of the mdf? Have you run a DBCC CheckDB on the database that you think is backed up to the MTF? How did you determine the MTF is corrupted?

- To plagarize Gail's favorite, first response: "run DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS" and post the results if errors exist.

Terry

-- The problem with socialism is that you eventually run out of other people’s money. -- Margaret Thatcher
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-03-17 : 17:29:47
MTF = Microsoft Tape Format?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2010-03-18 : 08:39:29
Hmm, wasn't in the top 10 on Google yesterday (using simply MTF file), and as stated, I am resticted a bit at work from getting in to certain sites so I gleened what I could from the notes on Google. Never thought of Microsoft tape format, never used it. I always go to disk and then to tape but, hey, I learned something new today!! And, perhaps BOL should be my first stop, eh? Right there, as plain as the nose on my face. Thanks Gail.

http://msdn.microsoft.com/en-us/library/ms178062.aspx
http://www.tapedatarecovery.net/tape-format.html


Terry

-- The problem with socialism is that you eventually run out of other people’s money. -- Margaret Thatcher
Go to Top of Page

rajesh singh
Starting Member

2 Posts

Posted - 2010-05-31 : 15:29:37
MTF is a Microsoft Tape Format reader. It will read tapes created with the Windows NT/2000 backup utility

rajesh_singh
Go to Top of Page
   

- Advertisement -