\\.\Tape0 is not a vaild Microsoft Tape format backup set

hi all
I am using Sql server 2000 with sp3 on Win 2003. Recently all of my nightly
sql server backups have started failing. Here is the error message I get wit
h
it
The file on device '\\.\Tape0' is not a vaild Microsoft Tape format backup
set. Backup Database is terminating abnormally.
I am using HP dds-4 cartridges (40 GB)
How can I fix that?
Also how do I format my tapes?
regards,
AndreHi
Have you tried dropping the backup device and re-creating it? Will the NT
Backup recognise this tape device?
John
"Andre Gibson" wrote:

> hi all
> I am using Sql server 2000 with sp3 on Win 2003. Recently all of my nightl
y
> sql server backups have started failing. Here is the error message I get w
ith
> it
> The file on device '\\.\Tape0' is not a vaild Microsoft Tape format backup
> set. Backup Database is terminating abnormally.
> I am using HP dds-4 cartridges (40 GB)
> How can I fix that?
> Also how do I format my tapes?
> regards,
> Andre|||No NT Backup doesn't recognize the tape. How do I drop and re-create the
device?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you tried dropping the backup device and re-creating it? Will the NT
> Backup recognise this tape device?
> John
> "Andre Gibson" wrote:
>|||Hi Andre
If the NT backup does not recognise the tape, then it may not be SQL Server
that is the problem. Have you tried different tapes or re-installing the tap
e
drive?
John
"Andre Gibson" wrote:
[vbcol=seagreen]
> No NT Backup doesn't recognize the tape. How do I drop and re-create the
> device?
> "John Bell" wrote:
>|||John,
You were correct. It was my tapes.
Thanks so much for your assistance.
regards,
Andre
"John Bell" wrote:
[vbcol=seagreen]
> Hi Andre
> If the NT backup does not recognise the tape, then it may not be SQL Serve
r
> that is the problem. Have you tried different tapes or re-installing the t
ape
> drive?
> John
> "Andre Gibson" wrote:
>

[Ugent] attach Database error in SQL 7.0

Dear All
I have try to detach and re-attach database from SQL7.0 (Production Server).
The detach process was success, but re-attach database occur a error. There
is a Error message show on my screen.
Changed Language setting to us_english.
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:3882
Expression: pPage->GetLsn () == lp -> GetPrevPageLsn ()
SPID: 9
Process ID: 148
Connection Broken
Do anyone got experience to fix it ? Thanks very much
Gary
Hi Gary
"Gary" wrote:

> Dear All
> I have try to detach and re-attach database from SQL7.0 (Production Server).
> The detach process was success, but re-attach database occur a error. There
> is a Error message show on my screen.
> ----
> Changed Language setting to us_english.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: pageref.cpp:3882
> Expression: pPage->GetLsn () == lp -> GetPrevPageLsn ()
> SPID: 9
> Process ID: 148
> Connection Broken
> ----
> Do anyone got experience to fix it ? Thanks very much
I have not seen the error, but you may want to try renaming the log file and
using sp_attach_single_file_db. I would also check that this disc if fine
(CHKDSK or similar) and that no errors are being reported in the System Event
log.

> Gary
>
John

[Ugent] attach Database error in SQL 7.0

Dear All
I have try to detach and re-attach database from SQL7.0 (Production Server).
The detach process was success, but re-attach database occur a error. There
is a Error message show on my screen.
----
--
Changed Language setting to us_english.
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:3882
Expression: pPage->GetLsn () == lp -> GetPrevPageLsn ()
SPID: 9
Process ID: 148
Connection Broken
----
--
Do anyone got experience to fix it ? Thanks very much
GaryHi Gary
"Gary" wrote:

> Dear All
> I have try to detach and re-attach database from SQL7.0 (Production Server
).
> The detach process was success, but re-attach database occur a error. Ther
e
> is a Error message show on my screen.
> ----
--
> Changed Language setting to us_english.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: pageref.cpp:3882
> Expression: pPage->GetLsn () == lp -> GetPrevPageLsn ()
> SPID: 9
> Process ID: 148
> Connection Broken
> ----
--
> Do anyone got experience to fix it ? Thanks very much
I have not seen the error, but you may want to try renaming the log file and
using sp_attach_single_file_db. I would also check that this disc if fine
(CHKDSK or similar) and that no errors are being reported in the System Even
t
log.

> Gary
>
John

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead(recv())DId you enable remote con

Dear All

I am using sql server 2000 SP4. Os is win2003 server. I was able to register sql server from my server using Enterprise manager. but i am not able to register the same from any client machine. pls help me

raffi

Hi,

DId you enable remote connections yet ? Have a look at my screencast on my site. You will find a tutorial to enable remote connections for your SQL Server 2005. By default this is turned off.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead(recv())

Dear All

I am using sql server 2000 SP4. Os is win2003 server. I was able to register sql server from my server using Enterprise manager. but i am not able to register the same from any client machine. pls help me

raffi

Hi,

DId you enable remote connections yet ? Have a look at my screencast on my site. You will find a tutorial to enable remote connections for your SQL Server 2005. By default this is turned off.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

[help]:SQLServer 2000 setup fails!

Dear All:
I receive the error with _INS5576._MP.exe when i installed sqlserver 2000
pls help me to solve this problem
ThanksWhat is the version of MSSQL server you tried to install?
What is your operating system?
Can you post the error message you got?|||Originally posted by gyuan
What is the version of MSSQL server you tried to install?
What is your operating system?
Can you post the error message you got?

i wanna to install STANDARD version in my windows 2000 server
I receive the error with "application error in _INS5576._MP "

pls help me ,thanks|||In which step did you get the error message?|||Originally posted by gyuan
In which step did you get the error message?

The first step,i click the SETUPSQL.EXE|||What is the Service Pack on your windows 2000 server? When you tried to install the MSSQL server did you close any other applications?|||Did you log on windows using Administrator account?|||Originally posted by gyuan
What is the Service Pack on your windows 2000 server? When you tried to install the MSSQL server did you close any other applications?

I've installed sp3 ,i have closed any other applictions when i install the sqlserver and i use administrator installed it|||Is is solved ? If not, read the following link:

link (http://dbforums.com/arch/175/2002/3/331731)

Also, check your installation log files for more information- sqlstp.log, sqlsp.log, and setup.iss.|||Originally posted by rnealejr
Is is solved ? If not, read the following link:

link (http://dbforums.com/arch/175/2002/3/331731)

Also, check your installation log files for more information- sqlstp.log, sqlsp.log, and setup.iss.

but i didn't find ActiveSync in my computer

can you tell me where is the sqlstp.log ,sqlsp.log,and setup.iss?|||Originally posted by board
but i didn't find ActiveSync in my computer

can you tell me where is the sqlstp.log ,sqlsp.log,and setup.iss?

here is the sqlstp.log

15:23:58 Begin Setup
15:24:28 ?ɡ

15:24:28 End Action: Locked Connectivity Files Check
15:24:28 ??? Microsoft ? (MDAC) ...
15:24:28 D:\NET\SQLSER~1\ENTERP~1\x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
15:24:43 ExitCode: 0
15:24:43 ??? Microsoft ??_ (MSDTC) ...
15:24:43 C:\WINNT\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir "C:\WINNT\TEMP\SqlSetup\Bin" -DTCPkg "D:\NET\SQLSER~1\ENTERP~1\x86\Other\dtcsetup.exe" -LogFile "C:\WINNT\sqlstp.log"
15:24:43 Process Exit Code: (0)
15:24:43 InstallMSSearch instance: MSSQLSERVER
15:24:43 Software\Microsoft\Search\Install:Version : 9.107.5512
15:24:43 MSSearch 2.0 or greater version check returned 1
15:24:43 ??? Microsoft ??...
15:24:43 "D:\NET\SQLSER~1\ENTERP~1\x86\FullText\MSSearch\Sea rch\SearchStp.exe" /s /a:SQLServer
15:24:52 Process Exit Code: (0)
15:24:52 /Q:A /T:C:\WINNT\TEMP\ixp001.tmp
15:24:52 ??? HTML
15:24:52 HTML Help installer exit code: 0
15:25:14 End Action InstallPkgs
15:25:14 Begin Action MoveFileData:
15:25:14 Enabled SELFREGISTERBATCH
15:25:14 Enabled CORECOMPONENTHANDLING
15:25:47 Begin Action: MoveFileDataSpecial
15:25:47 End Action: MoveFileDataSpecial
15:25:47 End Action MoveFileData
15:25:47 Begin Action ProcessAfterDataMove:
15:25:47 D:\NET\SQLSER~1\ENTERP~1\x86\Binn\hhcol.exe C:\Program Files\Microsoft SQL Server\80\Tools\Books
15:25:49 End Action ProcessAfterDataMove
15:25:49 Begin Action BuildServer:
15:25:49 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath "C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
15:25:49 Process Exit Code: (0)
15:25:49 Begin Action: CreateRegistrySetSQL
15:25:49 End Action: CreateRegistrySetSQL
15:25:49 Begin Action: RegWriteSetupEntry
15:25:49 End Action: RegWriteSetupEntry
15:25:49 Begin Action: CreateSer
15:25:49 End Action: CreateSer
15:25:49 Begin Action: SkuIt
15:25:50 End Action: SkuIt
15:25:50 SetFileSecuritySQLAndAdmin for d:\Program Files\Microsoft SQL Server\MSSQL returned: 1350, 1350
15:25:50 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL Server\MSSQL returned: 1350, 1350
15:25:50 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
15:25:50 Begin Action: UpdateSystemPath
15:25:50 Path successfully updated.
15:25:50 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
15:25:50 End Action: UpdateSystemPath
15:25:51 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "Chinese_PRC_CI_AS" -H 1179808 -U sa -P
################################################## #############################

?

Chinese_PRC_CI_AS

-m -Q -T4022 -T3659

?

driver={sql server};server=google15;UID=sa;PWD=;database=maste r

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=google15;UID=sa;PWD=;database=maste r

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=google15;UID=sa;PWD=;database=maste r

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

SQL Server ?

################################################## #############################

15:28:02 Process Exit Code: (-1)|||It looks like it is failing when configuring the server. Please post the output from cnfgsvr.out.|||Also, what is the translation on these 2 lines:

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

SQL Server ?|||Originally posted by rnealejr
Also, what is the translation on these 2 lines:

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

SQL Server ?

The problem had solved , I installed the sp4 for my windows 2000 server
It's ok now!

Thanks

[ConnectionWrite (send()).]General network error

Hi All
I have a visual basic application, which uses SQL Server 2000(sp3a) as
the database, MDAC 2.8 library. I open one connection to the db on the
application start, and the applicaiton works fine for few days, then
suddenly it gives this error [DBNETLIB][ConnectionWrite
(send()).]General network error. -2147467259 .
I tried to close the connection and open again on this error, and I get
this error, [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
not exist or access denied. -2147467259. If the application is closed
and opened again, it works fine without any problems.
This applicaiton runs on at around 12 different sites.There is no
pattern to when this error
occurs and I really cannot replicate it.
I have checked the SQL server logs, application logs, system logs on
server and client machines, there is nothing useful I could find.
The client running the application, and the server and on the same LAN,
no firewall.
I already posted this message in SQLSERVER.Server group, but didnt get
any help.
Any help is highly appreciated.
Thanksi have seen faulty NICs do weird things. the error simply means the app
can't get to the server. this is definitely _connection_ problem.
-oj
<tech.support.b@.gmail.com> wrote in message
news:1150444943.918481.99820@.g10g2000cwb.googlegroups.com...
> Hi All
> I have a visual basic application, which uses SQL Server 2000(sp3a) as
> the database, MDAC 2.8 library. I open one connection to the db on the
> application start, and the applicaiton works fine for few days, then
> suddenly it gives this error [DBNETLIB][ConnectionWrite
> (send()).]General network error. -2147467259 .
> I tried to close the connection and open again on this error, and I get
> this error, [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
> not exist or access denied. -2147467259. If the application is closed
> and opened again, it works fine without any problems.
> This applicaiton runs on at around 12 different sites.There is no
> pattern to when this error
> occurs and I really cannot replicate it.
> I have checked the SQL server logs, application logs, system logs on
> server and client machines, there is nothing useful I could find.
> The client running the application, and the server and on the same LAN,
> no firewall.
> I already posted this message in SQLSERVER.Server group, but didnt get
> any help.
> Any help is highly appreciated.
> Thanks
>|||oj wrote:
> i have seen faulty NICs do weird things. the error simply means the app
> can't get to the server. this is definitely _connection_ problem.
> --
> -oj
Thanks for ur reply oj., but i certainly do not think this is a case of
faulty NIC's. One or two or three pcs getting this error, i would
understand., but this happens everywhere, but without a pattern.|||would you by any chance using windows authentication? unable to communicate
with the domain controller would cause issue.
-oj
<tech.support.b@.gmail.com> wrote in message
news:1150451691.161431.42480@.r2g2000cwb.googlegroups.com...
> oj wrote:
> Thanks for ur reply oj., but i certainly do not think this is a case of
> faulty NIC's. One or two or three pcs getting this error, i would
> understand., but this happens everywhere, but without a pattern.
>|||oj wrote:
> would you by any chance using windows authentication? unable to communicat
e
> with the domain controller would cause issue.
> --
> -oj
>
> <tech.support.b@.gmail.com> wrote in message
> news:1150451691.161431.42480@.r2g2000cwb.googlegroups.com...
No, I am not using Windows authentication, I am using SQL server
authentication. No Domain, its a workgroup. Funny part is, the moment
this error happens, if i kill the application and run the application
again, there is no problem., however, if at the time of the error, I
try to close and re-open the connection, it always fails.|||hmm...what is the value for @.@.max_connections. and @.@.version.
can you ping the server once an error occurs. can you connect via <ip,port>.
-oj
<tech.support.b@.gmail.com> wrote in message
news:1150483296.616430.109960@.h76g2000cwa.googlegroups.com...
> No, I am not using Windows authentication, I am using SQL server
> authentication. No Domain, its a workgroup. Funny part is, the moment
> this error happens, if i kill the application and run the application
> again, there is no problem., however, if at the time of the error, I
> try to close and re-open the connection, it always fails.
>|||oj wrote:
> hmm...what is the value for @.@.max_connections. and @.@.version.
> can you ping the server once an error occurs. can you connect via <ip,port
>.
>
> --
> -oj
>
> <tech.support.b@.gmail.com> wrote in message
> news:1150483296.616430.109960@.h76g2000cwa.googlegroups.com...
@.@.version returns
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 (Build 3790: )
@.@.max_connections is 32767
The server is pingable, and other users continue working without any
problems while this problem happens.