Win2K Server Tape Block Size

[cahonis]

Does anyone know how to find out what block size Windows 2000 is using for a tape drive attached to it?

Cheers :)

[Sfinkta]

(This is for SQL backups - might be the same for NTBackup). On W2k, the default block size is 65,536 (as opposed to NT where the default is governed by the tape device). To set to a value other than the default, use the BLOCKSIZE attribute of the BACKUP command :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_35ww.asp