Backup design

Hello, everyone:
I have a 1GB table that has to run in 24X7 environment. That means the users maybe use this table during backup. How should I design the backup strategy? Can users access the table when the backup is running?
Thanks
ZYTOriginally posted by yitongzhang
Hello, everyone:

I have a 1GB table that has to run in 24X7 environment. That means the users maybe use this table during backup. How should I design the backup strategy? Can users access the table when the backup is running?

Thanks

ZYT

yes

BackLinkLogBlockReadAheadAsync

Does anyone know what this error message means? Our
database keeps kicking into Suspect mode with severity
21. We use SQL Server 2000, running on Windows 2000. The
error message that appears is 'Operating system error 997
(Overlapped I/O operation is in progress.) on
device 'e:\logfiles\lwidwh01_log.ldf' during
BackLinkLogBlockReadAheadAsync.' Does anyone know what
this means, or has anyone dealt with this kind of
problem?
Thanks
.Sounds like a hardware issue. I would run a diagnostic tool to check if the
drives and RAID controller(s) are fine.
"Tracy" wrote:
> Does anyone know what this error message means? Our
> database keeps kicking into Suspect mode with severity
> 21. We use SQL Server 2000, running on Windows 2000. The
> error message that appears is 'Operating system error 997
> (Overlapped I/O operation is in progress.) on
> device 'e:\logfiles\lwidwh01_log.ldf' during
> BackLinkLogBlockReadAheadAsync.' Does anyone know what
> this means, or has anyone dealt with this kind of
> problem?
> Thanks
> ..
>
>

BackLinkLogBlockReadAheadAsync

Does anyone know what this error message means? Our
database keeps kicking into Suspect mode with severity
21. We use SQL Server 2000, running on Windows 2000. The
error message that appears is 'Operating system error 997
(Overlapped I/O operation is in progress.) on
device 'e:\logfiles\lwidwh01_log.ldf' during
BackLinkLogBlockReadAheadAsync.' Does anyone know what
this means, or has anyone dealt with this kind of
problem?
Thanks
..
Sounds like a hardware issue. I would run a diagnostic tool to check if the
drives and RAID controller(s) are fine.
"Tracy" wrote:

> Does anyone know what this error message means? Our
> database keeps kicking into Suspect mode with severity
> 21. We use SQL Server 2000, running on Windows 2000. The
> error message that appears is 'Operating system error 997
> (Overlapped I/O operation is in progress.) on
> device 'e:\logfiles\lwidwh01_log.ldf' during
> BackLinkLogBlockReadAheadAsync.' Does anyone know what
> this means, or has anyone dealt with this kind of
> problem?
> Thanks
> ..
>
>