New SQL Server 2000 Install - Backup of Empty Database never compl

We installed SQL Server 2000 SP3 and created a number of databases. However
after a while the backups of these databases appear to hang forever and
required a reboot to clear. We then created a brand new empty database and
tried backing this up, but had the same problem.
Looking in the Event Viewer the following errors:
The device, \Device\Scsi\aarich1, did not respond within the timeout period.
We mirrored disks set, so we tried splitting the mirror both ways and
running the backups, but had the same problem.
Looking at the Event Viewer messages for MSSQLSERVER there ar a number:
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
18204 :
BackupDiskFile::CreateMedia: Backup device 'w:\tmp\tst1.bak' failed to
create. Operating system error = 3(error not found).
When the backup hangs the CPU on the server drops off to zero and the
server becomes very unresponsive.
The Operating sytem is Windows 2003
Anyone any ideas?
Regards Mike Kimber
mikekimber1,
That looks like a hardware problem to me. Have you changed the drivers
recently? If so, it could be a driver problem.
Also check that the location you are backing up to really exists. I know, an
obvious point, but there may be a type somewhere in your code.
Mark.
"mikekimber1" wrote:

> We installed SQL Server 2000 SP3 and created a number of databases. However
> after a while the backups of these databases appear to hang forever and
> required a reboot to clear. We then created a brand new empty database and
> tried backing this up, but had the same problem.
> Looking in the Event Viewer the following errors:
> The device, \Device\Scsi\aarich1, did not respond within the timeout period.
> We mirrored disks set, so we tried splitting the mirror both ways and
> running the backups, but had the same problem.
> Looking at the Event Viewer messages for MSSQLSERVER there ar a number:
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> 18204 :
> BackupDiskFile::CreateMedia: Backup device 'w:\tmp\tst1.bak' failed to
> create. Operating system error = 3(error not found).
> When the backup hangs the CPU on the server drops off to zero and the
> server becomes very unresponsive.
> The Operating sytem is Windows 2003
> Anyone any ideas?
> Regards Mike Kimber
>
|||Is drive W: a mapped drive? Try using UNC (i.e. \\server\share) instead of
mapped drives.
SCSI timeouts are significant enough and they could indicate that there is a
serious H/W problem. You should address them first and then check your
databases for corruption. Use CHECKPOINT, DBCC DROPCLEANBUFFERS and DBCC
CHECKDB to ensure that you are loading clean database pages from the disk.
Microsoft has several hotfixes for 17805 errors, but they are probably not
related to your backups.
Adrian
"mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
news:C73D1ABA-7494-440E-812A-365647D51A9D@.microsoft.com...
> We installed SQL Server 2000 SP3 and created a number of databases.
> However
> after a while the backups of these databases appear to hang forever and
> required a reboot to clear. We then created a brand new empty database and
> tried backing this up, but had the same problem.
> Looking in the Event Viewer the following errors:
> The device, \Device\Scsi\aarich1, did not respond within the timeout
> period.
> We mirrored disks set, so we tried splitting the mirror both ways and
> running the backups, but had the same problem.
> Looking at the Event Viewer messages for MSSQLSERVER there ar a number:
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> 18204 :
> BackupDiskFile::CreateMedia: Backup device 'w:\tmp\tst1.bak' failed to
> create. Operating system error = 3(error not found).
> When the backup hangs the CPU on the server drops off to zero and the
> server becomes very unresponsive.
> The Operating sytem is Windows 2003
> Anyone any ideas?
> Regards Mike Kimber
>

New SQL Server 2000 Install - Backup of Empty Database never compl

We installed SQL Server 2000 SP3 and created a number of databases. However
after a while the backups of these databases appear to hang forever and
required a reboot to clear. We then created a brand new empty database and
tried backing this up, but had the same problem.
Looking in the Event Viewer the following errors:
The device, \Device\Scsi\aarich1, did not respond within the timeout period.
We mirrored disks set, so we tried splitting the mirror both ways and
running the backups, but had the same problem.
Looking at the Event Viewer messages for MSSQLSERVER there ar a number:
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
18204 :
BackupDiskFile::CreateMedia: Backup device 'w:\tmp\tst1.bak' failed to
create. Operating system error = 3(error not found).
When the backup hangs the CPU on the server drops off to zero and the
server becomes very unresponsive.
The Operating sytem is Windows 2003
Anyone any ideas?
Regards Mike Kimbermikekimber1,
That looks like a hardware problem to me. Have you changed the drivers
recently? If so, it could be a driver problem.
Also check that the location you are backing up to really exists. I know, an
obvious point, but there may be a type somewhere in your code.
Mark.
"mikekimber1" wrote:
> We installed SQL Server 2000 SP3 and created a number of databases. However
> after a while the backups of these databases appear to hang forever and
> required a reboot to clear. We then created a brand new empty database and
> tried backing this up, but had the same problem.
> Looking in the Event Viewer the following errors:
> The device, \Device\Scsi\aarich1, did not respond within the timeout period.
> We mirrored disks set, so we tried splitting the mirror both ways and
> running the backups, but had the same problem.
> Looking at the Event Viewer messages for MSSQLSERVER there ar a number:
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> 18204 :
> BackupDiskFile::CreateMedia: Backup device 'w:\tmp\tst1.bak' failed to
> create. Operating system error = 3(error not found).
> When the backup hangs the CPU on the server drops off to zero and the
> server becomes very unresponsive.
> The Operating sytem is Windows 2003
> Anyone any ideas?
> Regards Mike Kimber
>|||Is drive W: a mapped drive? Try using UNC (i.e. \\server\share) instead of
mapped drives.
SCSI timeouts are significant enough and they could indicate that there is a
serious H/W problem. You should address them first and then check your
databases for corruption. Use CHECKPOINT, DBCC DROPCLEANBUFFERS and DBCC
CHECKDB to ensure that you are loading clean database pages from the disk.
Microsoft has several hotfixes for 17805 errors, but they are probably not
related to your backups.
Adrian
"mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
news:C73D1ABA-7494-440E-812A-365647D51A9D@.microsoft.com...
> We installed SQL Server 2000 SP3 and created a number of databases.
> However
> after a while the backups of these databases appear to hang forever and
> required a reboot to clear. We then created a brand new empty database and
> tried backing this up, but had the same problem.
> Looking in the Event Viewer the following errors:
> The device, \Device\Scsi\aarich1, did not respond within the timeout
> period.
> We mirrored disks set, so we tried splitting the mirror both ways and
> running the backups, but had the same problem.
> Looking at the Event Viewer messages for MSSQLSERVER there ar a number:
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> 18204 :
> BackupDiskFile::CreateMedia: Backup device 'w:\tmp\tst1.bak' failed to
> create. Operating system error = 3(error not found).
> When the backup hangs the CPU on the server drops off to zero and the
> server becomes very unresponsive.
> The Operating sytem is Windows 2003
> Anyone any ideas?
> Regards Mike Kimber
>

New Server

I have a win2000 server that is in need of replacement, we
have built a new server and now need to configure sql 2000.
From backups I retored all the databases including msdb.
How do I restore the Master database, as this has lots of
extra system SP that need on the new server.
I tried putting the Instance in single user mode and doing
a restore, which said it worked OK but when trying to
restart SQL it fail to start. Any ideas what I am doing
wrongWhat's the error in the SQL Server error log?
See if this helps too: http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
I have a win2000 server that is in need of replacement, we
have built a new server and now need to configure sql 2000.
From backups I retored all the databases including msdb.
How do I restore the Master database, as this has lots of
extra system SP that need on the new server.
I tried putting the Instance in single user mode and doing
a restore, which said it worked OK but when trying to
restart SQL it fail to start. Any ideas what I am doing
wrong|||What was the reason to backup/restore the system DB instead of generating
the script for the SPs (extra system SP)
and running the script on the new server ?
If they are system SPs they should be common across all master DBs, right ?
Gopi
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
>I have a win2000 server that is in need of replacement, we
> have built a new server and now need to configure sql 2000.
> From backups I retored all the databases including msdb.
> How do I restore the Master database, as this has lots of
> extra system SP that need on the new server.
> I tried putting the Instance in single user mode and doing
> a restore, which said it worked OK but when trying to
> restart SQL it fail to start. Any ideas what I am doing
> wrong
>|||Allan
From my experience i have learned that first of all script out all logins
(there are two SP provided by MS) and then jobs as well
There is no need to restore master,msdb databases , instead restore all user
databases and run the script generated by these SP's.
In the same way you can move all DTS packages (to save the as files). You
will not lost anything.
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
> I have a win2000 server that is in need of replacement, we
> have built a new server and now need to configure sql 2000.
> From backups I retored all the databases including msdb.
> How do I restore the Master database, as this has lots of
> extra system SP that need on the new server.
> I tried putting the Instance in single user mode and doing
> a restore, which said it worked OK but when trying to
> restart SQL it fail to start. Any ideas what I am doing
> wrong
>

New Server

I have a win2000 server that is in need of replacement, we
have built a new server and now need to configure sql 2000.
From backups I retored all the databases including msdb.
How do I restore the Master database, as this has lots of
extra system SP that need on the new server.
I tried putting the Instance in single user mode and doing
a restore, which said it worked OK but when trying to
restart SQL it fail to start. Any ideas what I am doing
wrong
What's the error in the SQL Server error log?
See if this helps too: http://vyaskn.tripod.com/moving_sql_server.htm
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
I have a win2000 server that is in need of replacement, we
have built a new server and now need to configure sql 2000.
From backups I retored all the databases including msdb.
How do I restore the Master database, as this has lots of
extra system SP that need on the new server.
I tried putting the Instance in single user mode and doing
a restore, which said it worked OK but when trying to
restart SQL it fail to start. Any ideas what I am doing
wrong
|||What was the reason to backup/restore the system DB instead of generating
the script for the SPs (extra system SP)
and running the script on the new server ?
If they are system SPs they should be common across all master DBs, right ?
Gopi
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
>I have a win2000 server that is in need of replacement, we
> have built a new server and now need to configure sql 2000.
> From backups I retored all the databases including msdb.
> How do I restore the Master database, as this has lots of
> extra system SP that need on the new server.
> I tried putting the Instance in single user mode and doing
> a restore, which said it worked OK but when trying to
> restart SQL it fail to start. Any ideas what I am doing
> wrong
>
|||Allan
From my experience i have learned that first of all script out all logins
(there are two SP provided by MS) and then jobs as well
There is no need to restore master,msdb databases , instead restore all user
databases and run the script generated by these SP's.
In the same way you can move all DTS packages (to save the as files). You
will not lost anything.
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
> I have a win2000 server that is in need of replacement, we
> have built a new server and now need to configure sql 2000.
> From backups I retored all the databases including msdb.
> How do I restore the Master database, as this has lots of
> extra system SP that need on the new server.
> I tried putting the Instance in single user mode and doing
> a restore, which said it worked OK but when trying to
> restart SQL it fail to start. Any ideas what I am doing
> wrong
>

New Server

I have a win2000 server that is in need of replacement, we
have built a new server and now need to configure sql 2000.
From backups I retored all the databases including msdb.
How do I restore the Master database, as this has lots of
extra system SP that need on the new server.
I tried putting the Instance in single user mode and doing
a restore, which said it worked OK but when trying to
restart SQL it fail to start. Any ideas what I am doing
wrongWhat's the error in the SQL Server error log?
See if this helps too: http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
I have a win2000 server that is in need of replacement, we
have built a new server and now need to configure sql 2000.
From backups I retored all the databases including msdb.
How do I restore the Master database, as this has lots of
extra system SP that need on the new server.
I tried putting the Instance in single user mode and doing
a restore, which said it worked OK but when trying to
restart SQL it fail to start. Any ideas what I am doing
wrong|||What was the reason to backup/restore the system DB instead of generating
the script for the SPs (extra system SP)
and running the script on the new server ?
If they are system SPs they should be common across all master DBs, right ?
Gopi
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
>I have a win2000 server that is in need of replacement, we
> have built a new server and now need to configure sql 2000.
> From backups I retored all the databases including msdb.
> How do I restore the Master database, as this has lots of
> extra system SP that need on the new server.
> I tried putting the Instance in single user mode and doing
> a restore, which said it worked OK but when trying to
> restart SQL it fail to start. Any ideas what I am doing
> wrong
>|||Allan
From my experience i have learned that first of all script out all logins
(there are two SP provided by MS) and then jobs as well
There is no need to restore master,msdb databases , instead restore all user
databases and run the script generated by these SP's.
In the same way you can move all DTS packages (to save the as files). You
will not lost anything.
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
> I have a win2000 server that is in need of replacement, we
> have built a new server and now need to configure sql 2000.
> From backups I retored all the databases including msdb.
> How do I restore the Master database, as this has lots of
> extra system SP that need on the new server.
> I tried putting the Instance in single user mode and doing
> a restore, which said it worked OK but when trying to
> restart SQL it fail to start. Any ideas what I am doing
> wrong
>