I have a big database of more than 20 GB running on SQL
2000 with SP1 on Win 2K SP2 Server. The Database is in
Raid 5. Every day I do a full backup and the backup
operation takes about a total of 40 minutes. Of this 40
minutes the first 30 minutes I am able to connect to the
server and there is no problem and in the last 10 minutes
there seems to be a lot of disk activity when it tries to
write the data in the disk and at this time none of the
application is able to connet and all my applications
fails or in the other words the server freezes. After that
everything works fine. Is there a way to avoid this. I
guess SQL Server should handle a large databases and 20 GB
is not that big and I do not know why there is a
connection failure when it is writing data into the disk.
The server has dual III 1 GHz processor with 2 GB ram.
Thanks,
Ray.
2000 with SP1 on Win 2K SP2 Server. The Database is in
Raid 5. Every day I do a full backup and the backup
operation takes about a total of 40 minutes. Of this 40
minutes the first 30 minutes I am able to connect to the
server and there is no problem and in the last 10 minutes
there seems to be a lot of disk activity when it tries to
write the data in the disk and at this time none of the
application is able to connet and all my applications
fails or in the other words the server freezes. After that
everything works fine. Is there a way to avoid this. I
guess SQL Server should handle a large databases and 20 GB
is not that big and I do not know why there is a
connection failure when it is writing data into the disk.
The server has dual III 1 GHz processor with 2 GB ram.
Thanks,
Ray.