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
>
Showing posts with label empty. Show all posts
Showing posts with label empty. Show all posts
Friday, March 23, 2012
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
>
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
>
Wednesday, March 7, 2012
new index, catalog empty
I have created a FT Index on a varchar(200) col of my 'movies' table.
The table has about 2000 rows, so there is lots to index.
But even after forcing a catalog rebuild and full population, the catalog
remains empty.
(item count 0, unique key count 1, etc..)
Any ideas ?
Any error messages in the event log from MSSearch or MSSCI?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tony B." <Test@.spam.ca> wrote in message
news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>I have created a FT Index on a varchar(200) col of my 'movies' table.
> The table has about 2000 rows, so there is lots to index.
> But even after forcing a catalog rebuild and full population, the catalog
> remains empty.
> (item count 0, unique key count 1, etc..)
> Any ideas ?
>
>
|||sql server general "ERRORLOG" (all caps, no file extension)
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Any error messages in the event log from MSSearch or MSSCI?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Tony B." <Test@.spam.ca> wrote in message
> news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||I assume you are telling me the contents of the log directory. I want you to
look in the application log. At a command prompt type eventvwr, hit enter,
and drill down on application log. Look for messages from mssci, or mssearch
and post them back here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tony B." <Test@.spam.ca> wrote in message
news:%23aOiEMnDHHA.3212@.TK2MSFTNGP04.phx.gbl...
> sql server general "ERRORLOG" (all caps, no file extension)
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
>
The table has about 2000 rows, so there is lots to index.
But even after forcing a catalog rebuild and full population, the catalog
remains empty.
(item count 0, unique key count 1, etc..)
Any ideas ?
Any error messages in the event log from MSSearch or MSSCI?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tony B." <Test@.spam.ca> wrote in message
news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>I have created a FT Index on a varchar(200) col of my 'movies' table.
> The table has about 2000 rows, so there is lots to index.
> But even after forcing a catalog rebuild and full population, the catalog
> remains empty.
> (item count 0, unique key count 1, etc..)
> Any ideas ?
>
>
|||sql server general "ERRORLOG" (all caps, no file extension)
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Any error messages in the event log from MSSearch or MSSCI?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Tony B." <Test@.spam.ca> wrote in message
> news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||I assume you are telling me the contents of the log directory. I want you to
look in the application log. At a command prompt type eventvwr, hit enter,
and drill down on application log. Look for messages from mssci, or mssearch
and post them back here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tony B." <Test@.spam.ca> wrote in message
news:%23aOiEMnDHHA.3212@.TK2MSFTNGP04.phx.gbl...
> sql server general "ERRORLOG" (all caps, no file extension)
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
>
Saturday, February 25, 2012
New Empty database
i would like to know how to create a new instance of sql server. i am
using a program that i have to duplicate the database while it is
blank/emply and be able to connect to either database from
workstations. i dont know if i am using the correct terms but that is
what i need to accomplish, any help would be appreciated
Craig
you can create a database like this "create database test"
You can issue this command through ADO, or isql in a batch file.
You can also use SQLDMO for this:
set objServer = CreateObject("SQLDMO.SQLServer")
set objDatabase=CreateObject("SQLDMO.Database")
objServer.Connect "hilary2kp", "sa","se1cure#"
set objDatabases=objServer.Databases
objDatabase.Name="test123"
objDatabases.Add objDatabase
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"tcicraig" <craig@.tcicomputer.com> wrote in message
news:de60a738.0410272107.576c7432@.posting.google.c om...
> i would like to know how to create a new instance of sql server. i am
> using a program that i have to duplicate the database while it is
> blank/emply and be able to connect to either database from
> workstations. i dont know if i am using the correct terms but that is
> what i need to accomplish, any help would be appreciated
> Craig
using a program that i have to duplicate the database while it is
blank/emply and be able to connect to either database from
workstations. i dont know if i am using the correct terms but that is
what i need to accomplish, any help would be appreciated
Craig
you can create a database like this "create database test"
You can issue this command through ADO, or isql in a batch file.
You can also use SQLDMO for this:
set objServer = CreateObject("SQLDMO.SQLServer")
set objDatabase=CreateObject("SQLDMO.Database")
objServer.Connect "hilary2kp", "sa","se1cure#"
set objDatabases=objServer.Databases
objDatabase.Name="test123"
objDatabases.Add objDatabase
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"tcicraig" <craig@.tcicomputer.com> wrote in message
news:de60a738.0410272107.576c7432@.posting.google.c om...
> i would like to know how to create a new instance of sql server. i am
> using a program that i have to duplicate the database while it is
> blank/emply and be able to connect to either database from
> workstations. i dont know if i am using the correct terms but that is
> what i need to accomplish, any help would be appreciated
> Craig
Subscribe to:
Posts (Atom)