Oops, sorry. I meant the MDF had been restored from a tape backup which was generated by veritas.
I did the type thing and it was a bunch of gobbledeegook. The .mdf is about 400 MB. The reason why we think it might be sql7, is because in one of their folders, there is a folder C:\mssql7, but we don't know if this is a legacy thing or the current version. This has been a very messy process from the start and I appreciate your help Tim. Charles > -----Original Message----- > From: Raster, Tim [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 23, 2004 11:14 AM > To: SQL > Subject: RE: .mdf file - please help this rookie > > > If it's an .MDF, then it's not a Veritas file. How big is the .MDF > file? Also, try using a DOS prompt (yes, old fashioned), and do a "type > TheFile.MDF" and see what comes out. > > Is it possible that it's because they gave you a SQL7 MDF, and SQL2k > doesn't like it? (speaks to the backup/restore discussion earlier, > which translates as it goes) > > > -----Original Message----- > From: Charles Nahm [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 23, 2004 10:06 > To: SQL > Subject: RE: .mdf file - please help this rookie > > Thank you Jacob. I tried this and I got a pop up that says, "this file > is > not a valid SQL database". I have a feeling the data we received is a > Veritas backup of their full system. I don't think they would have > stopped > SQL server to make this backup. Does that make a difference and is > there > anything we can do? > > Thanks very much Tim and Jacob for the quick replies, > Charles > > > -----Original Message----- > > From: Jacob Cameron [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 23, 2004 10:39 AM > > To: SQL > > Subject: RE: .mdf file - please help this rookie > > > > > > Copy to your SQL server, right click in enterprise manager (on the > word > > database) and try to attach (under all tasks) the database to your > server. > > If it is SQL 7 or 2000, it will be imported. You may have to change > where > > the files point though. > > > > I have transferred files many times. As long as SQL Server was > stopped on > > their end when they copied the file the file should be fine. Try > > attaching > > it, then let us know if that worked. > > > > Jacob > > > > Jacob Cameron > > Blue Lantern, Inc. > > (972) 226-9595 > > [EMAIL PROTECTED] > > http://www.blue-lantern.com > > > > -----Original Message----- > > From: Raster, Tim [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 23, 2004 9:25 AM > > To: SQL > > Subject: RE: .mdf file - please help this rookie > > > > Yikes. MDFs are the data files in their native format. It is not > advised > > to try to move those from server to server. It would be better > > for them to > > create a backup of the database, which copies the contents into a > > (usually) > > .BAK file. Then you would "restore" this .BAK file to an empty > > database on > > your server. SQL2k can read SQL7 .BAK files just fine. > > > > All he has to do is right-click on the database in his Enterprise > Manager, > > hit Backup, and tell it where to put the .BAK file. Simple. > > > > > > -----Original Message----- > > From: Charles Nahm [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 23, 2004 09:34 > > To: SQL > > Subject: .mdf file - please help this rookie > > > > Hello, I am an SQL rookie. We have received an .mdf file from a > > client that > > is used in conjuction with a photo hosting website. Judging from data > we > > received, we think it could be MSSql7. We are using MS Sql 2000. > > We cannot > > be sure of the version as the client doesn't know either. > > > > Are there any conversion tools available, or in the case of a > > possible file > > corruption, are there any SQL database recovery specialists that > > we can hire > > to get at this data? > > > > Thank you very much, > > Charles Nahm > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2082 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
