May 19, 2006 at 8:44 am
Hello,
I normally look into Backup folder every time I visit a server for any reason. (This action does not replace daily automated check)
Yesterday on one of the servers I found the following, same for all backup files, I am showing only one line. Look at the File Type:
Name Size Type Modified
master_db_200605160200.BAK 14,875 1698105090 5/16/2006 2 AM
This numeric file type was the same for ALL BAK file for all days. If I map a share from another computer and look into the same folder, the file type is back to normal BAK File. In the File Association (Tools->Optios->File Types) the BAK extention is associated with this number 1698105090 on this server.
This number does look familiar and when I went into Master Sysobjects there was an object with the exact ID, some SP. But I guess that this is just the numbering scheme.
I wonder how it could happen?
Regards,Yelena Varsha
May 19, 2006 at 9:11 am
That's strange. I've never seen that, but I'd suspect that it's a Windows issue with mapping types than a SQL one.
May 19, 2006 at 11:22 am
Steve,
Thanks. I think it is not the Windows issue by itself but an application issue. Maybe a Microsoft Application issue. Something reset the BAK files association to something related to Microsoft numbering scheme. The last thing I did on this machine for the web / database application running there is to enable and use Indexing Server while configuring and testing SQL Server Full-Text Search for Files using Indexing Server provider. Additionally WebLogic is running on the machine.
Regards,Yelena Varsha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply