August 22, 2007 at 6:04 am
Hi there! Im having a kind of trouble here.
First, my ISP (my client's ISP) is going to change my SQL DB from one machine to another. The problem begins when the DBA simply dont copy the database; he simply states that I must on my own copy the data.
Second, I have requested an backup of the database. When you think of Databases in MS SQL server, you think BAK, even MDF. But the DBA is sending me an DAT File!!!!! Please, if someone knows anything about this being some kind of default behavior on DBA, tell me.
The DBA just stated that "DAT is the default kind of file SQL generates". I tried to just attach, and to restore from this file (considering that the extension maybe wrong). But nothing.
Is there some kind of chance that this file is to be used on DTS?
One day, when I asked permission for making backups, the same DBA stated that I Should use the 'import/export' tool. To do 1GB transfer over internet? Oh come on....
Sorry for all... but Im really pissed off with all this.
Thanks for any help.
August 22, 2007 at 6:36 am
Hi
get the dba to give you a proper backup.
you can try one more thing - rename the DAT file to .BAK. sometimes this works.
"Keep Trying"
August 22, 2007 at 6:44 am
I had already done this. The file isn't bak with an wrong extension.
God, why people put such morons on those jobs?
Anyway, Im keep trying to import. Will try now the DTS.
August 22, 2007 at 7:47 am
You might have a peak at the file by doing in a Command shell:
type name.bak | more
The few SQL Server 2000 backup files i quickly looked at all begin with the word 'TAPE'.
August 22, 2007 at 7:54 am
YES! It does have indeed. But Im not being able to use the backup. SQL says its not an backup file.
August 22, 2007 at 8:07 am
If you are using Enterprise Manager to restore, try Query Analyzer instead (or vice versa). The other tool might give you a better message.
Other than that, I can only say that the file may have become corrupt.
August 22, 2007 at 10:07 am
Hi there.
Thanks Michael, you do really helped me to guess the nature of the file. I got the file again and restored with query analyzer.
The problem was that I was trying to restore into an SQL 2000
with the 2005 xpress manager tool. The manager wasnt able to read correcly the file.
Thanks for the help.
PS: But this doesnt excuse the ISP to state that DAT is an SQL default file extension.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply