File name length limit?

[RobertT687]

Am I running up against some file name length limit in SQLServer2000?
Here is my job step to backup the transaction log:
EXECUTE master.dbo.xp_sqlmaint '-D timberscale_mgr -Rpt "E:\SQLData\MSSQL\Backup\timberscale_mgr\Maint_Rpt\LogBackup.txt" -DelTxtRpt 2DAYS -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia DISK -BkUpLog "E:\SQLData\MSSQL\Backup\timberscale_mgr" -DelBkUps 2DAYS -BkExt "TRN" '

The filename it generates is:
timberscale_mgr_tlog_200408111649.T not .TRN
The same thing happens to the database backup. The file extension is 'B' rather than 'BAK'.

What's happening? I haven't seen this on any other of my databases.

 

[JayKusch]

Check your MaintPlan again and be sure the extension set for the TLog and Data backups are TRN and BAK respectively. They may just be set to T and B.

Thanks

J. Kusch

 

[SQLBill]

First, SQL Server doesn't limit the length of the file name. That's the Operating System.

Second, let's try a test. Right click on My Computer icon and select Search. Then enter the search option *.trn
That will search for any file with the extension of trn.

Is your file listed? If so, then it really does have the extension of trn and not just t. It's just that Windows isn't displaying the full name.

-SQLBill