backup, SQL 7.0 servers, BSOD, BLOCKSIZE etc - solution

backup, SQL 7.0 servers, BSOD, BLOCKSIZE etc - solution

Post by Tomasz Kopa » Sat, 08 Jan 2000 04:00:00

Few deys ago, I post a message about BLOCKSIZE=2048 (in backup
command) and* the server. When I set up BLOCKSIZE=512, backup
work correctly.

Error was probably inside UDMA33 drivers on test server (it was
probably HP drivers, which allow to access to EIDE hard disks grater
than 8GB)
After removing those drivers backup work always correctly.

Exactly description of the drivers, and short info about hardware:
HP Kayak XV-03xx, 2.05 Production release 2.05, date=12-7-98
Hard disk Fujitsu 10,2 GB + Caviar 3.2 GB
MotherBoard ASUS P2B + PII 266
Maybe it will help to someone else....
Tomasz Kopacz


1. recommended Blocksize for SQL Server 7.0

Hello NG,
after intense investigation in the online manual I am still confused about
the recommended Blocksize for the database partition.

I use an Escalade 6000 raid controller (raid 10) with four 307045 DTLA IBMs.
The raid array has been set to a block size of 64KB. Now I have to format
the drive with Windows 2000. Should I also select 64KB blocks or a smaller
size like 32KB or 8KB? Just from the performance perspective...

Thank you

2. PDXWIN-Memory-errors

3. Backup/restore from SQL 7.0 Server to SQL 7.0 SP1 Server

4. Checking available free space

5. DTS from SQL Server 6.5 to SQL Server 7.0 does not bring over keys, etc

6. SQL for both JET and SQL Server

7. Restoring msdb database from SQL Server 7.0 backup to SQL Server 2000

8. Chicago Consulting -- Oracle DBA

9. Help - restore backup file from SQL server 2000 on SQL server 7.0 failed

10. Problems backup up SQL Server 7.0 with Backup Exec

11. Installing SQl Server 7 OLAP Services will cause BSOD in Win2k Pro

12. NT Blocksize Vs Oracle Blocksize

13. setting db blocksize and vxfs blocksize