When backup a database, then remove SQL Server and install SQL Server 2000. Then I restore database but I don't restore.
Error : "The media set for database 'dvbt' has 2 family members but only 1 are provided. All members must be provided. RESTORE DATABASE is terminating abnormally"
Can you help me!How did you do the backup? The resotre process is expecting another media family for restoring the db, and obviously it's missing. Did you use two tapes?|||it's also possible that if the backup was done to disk that there was more than 1 file in the destination... this will stripe the backup across both files... if you are missing one of them, you are pretty much screwed unless you can recover them (either through the Recycle bin or a recovery program)
The thing that sucks about that backup interface is that even if you only have 1 file highlighted (think selected) it will backup to whatever files are listed, you have to remove any extra files if you want to backup to a single file.
Seeing that you removed SQL Server you can't just open the backup dialog again to see which files it went to
If you didn't delete all of the files in the backup directory, you should be okay, just need to find the other file
Any chance that you backed up those directories to tape before blowing them away?
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Saturday, February 25, 2012
Backup and Restor MS SQL Server 2005
I have a community server running in a hiring host, and I also install it on localhost. I would like to know how to backup the database from hosting and restore it to the site running on my localhost so that two sites is the same and in case there is an error from the hosting I can recover my database.
I can connect to my hosting database easily using SQL server Studio 2005, but the hosting does not offer backup through control panel. Could you please instruct me how to backup and restore database by SQL Server Management Studio.
Thank you very much,
Use Microsoft SQL Server Management Studio->Management->Maintenance plans to backup you databases and then on localhost use a query like "restore database TESTfrom disk = 'c:\TEST.BAK'WITH MOVE 'TEST' TO 'C:\TEST\TEST.mdf'"|||Thank you Konan,
I'll try right now
Tuesday, February 14, 2012
backup
Hello,
OK. At this point, I'm almost convinced that something went wrong
during the install process for SQL 2000. No matter what I try, I can
not get SQl to listen on port 1433. I clearly see that named pipes and
tcp is set for the network setting. Port 1433 is the default.
I did a backup of all my databases (to c:\dbbackup) and am going to do
an un-install, reboot, then re-install SQL server.
Is there anything I'm forgetting?Nothing in the errorlog? Of some other service is using 1433, then you'd get
an error in the
errorlog...
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Won Lee" <noemail@.nospam.com> wrote in message news:ujvVGKm6DHA.2576@.TK2MSFTNGP11.phx.gbl...[QUOT
E]
> Hello,
> OK. At this point, I'm almost convinced that something went wrong
> during the install process for SQL 2000. No matter what I try, I can
> not get SQl to listen on port 1433. I clearly see that named pipes and
> tcp is set for the network setting. Port 1433 is the default.
> I did a backup of all my databases (to c:\dbbackup) and am going to do
> an un-install, reboot, then re-install SQL server.
> Is there anything I'm forgetting?
>[/QUOTE]|||Tibor,
Thanks for trying to help me out.
THis is the full cut and paste of my error log.
2004-02-03 09:28:32.10 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
2004-02-03 09:28:32.10 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-02-03 09:28:32.10 server All rights reserved.
2004-02-03 09:28:32.10 server Server Process ID is 1688.
2004-02-03 09:28:32.10 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-02-03 09:28:32.15 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2004-02-03 09:28:32.95 server SQL Server configured for thread mode
processing.
2004-02-03 09:28:32.96 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2004-02-03 09:28:33.01 server Attempting to initialize Distributed
Transaction Coordinator.
2004-02-03 09:28:35.34 spid2 Starting up database 'master'.
2004-02-03 09:28:35.82 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-02-03 09:28:35.82 spid5 Starting up database 'model'.
2004-02-03 09:28:35.87 spid2 Server name is 'WINBOX'.
2004-02-03 09:28:35.87 spid8 Starting up database 'msdb'.
2004-02-03 09:28:35.87 spid9 Starting up database 'equity'.
2004-02-03 09:28:35.87 spid10 Starting up database 'vwap'.
2004-02-03 09:28:36.48 spid5 Clearing tempdb database.
2004-02-03 09:28:38.12 server SQL server listening on Shared Memory,
Named Pipes.
2004-02-03 09:28:38.12 server SQL Server is ready for client connections
2004-02-03 09:28:40.56 spid5 Starting up database 'tempdb'.
2004-02-03 09:28:41.39 spid2 Recovery complete.
2004-02-03 09:31:19.40 spid51 Using 'xpstar.dll' version
I should see SQL server listening on Shared Memory, TCP, Named Pipes.
I'm missing the TCP in my error log though.
netstat -an shows that I'm not listening on port 1443.
C:\Documents and Settings\wlee>netstat -an
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1027 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 192.168.1.202:139 0.0.0.0:0 LISTENING
TCP 192.168.1.202:139 192.168.1.159:1934 ESTABLISHED
TCP 192.168.1.202:1031 192.168.1.201:139 ESTABLISHED
TCP 192.168.1.202:1033 192.168.1.200:139 ESTABLISHED
TCP 192.168.1.202:3389 192.168.1.159:1923 ESTABLISHED
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1034 *:*
UDP 0.0.0.0:1435 *:*
UDP 0.0.0.0:4500 *:*
UDP 127.0.0.1:123 *:*
UDP 192.168.1.202:123 *:*
UDP 192.168.1.202:137 *:*
UDP 192.168.1.202:138 *:*
C:\Documents and Settings\wlee>
I tried to change it to other ports via the Network Utility but I still
can't see the TCP in the error log.
Tibor Karaszi wrote:
2004-02-02 14:15:42.42 server SQL server listening on <IP hiddeen>
...
2004-02-02 14:16:13.95 server SQL server listening on TCP, Named Pipes.
Indeed, it seems like SQL Server doesn't even try to listen to IP. I'd check
the registry so there
isn't anything strange in the registry entry where this configuration is hel
d (compare against a
healthy SQL Server).
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Won Lee" <noemail@.nospam.com> wrote in message news:uFrXSkm6DHA.696@.tk2msftngp13.phx.gbl...[QUOTE
]
> Tibor,
> Thanks for trying to help me out.
> THis is the full cut and paste of my error log.
>
> 2004-02-03 09:28:32.10 server Microsoft SQL Server 2000 - 8.00.194
> (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
> 2004-02-03 09:28:32.10 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2004-02-03 09:28:32.10 server All rights reserved.
> 2004-02-03 09:28:32.10 server Server Process ID is 1688.
> 2004-02-03 09:28:32.10 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2004-02-03 09:28:32.15 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2004-02-03 09:28:32.95 server SQL Server configured for thread mode
> processing.
> 2004-02-03 09:28:32.96 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2004-02-03 09:28:33.01 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2004-02-03 09:28:35.34 spid2 Starting up database 'master'.
> 2004-02-03 09:28:35.82 server Using 'SSNETLIB.DLL' version '8.0.194'.
> 2004-02-03 09:28:35.82 spid5 Starting up database 'model'.
> 2004-02-03 09:28:35.87 spid2 Server name is 'WINBOX'.
> 2004-02-03 09:28:35.87 spid8 Starting up database 'msdb'.
> 2004-02-03 09:28:35.87 spid9 Starting up database 'equity'.
> 2004-02-03 09:28:35.87 spid10 Starting up database 'vwap'.
> 2004-02-03 09:28:36.48 spid5 Clearing tempdb database.
> 2004-02-03 09:28:38.12 server SQL server listening on Shared Memory,
> Named Pipes.
> 2004-02-03 09:28:38.12 server SQL Server is ready for client connection
s
> 2004-02-03 09:28:40.56 spid5 Starting up database 'tempdb'.
> 2004-02-03 09:28:41.39 spid2 Recovery complete.
> 2004-02-03 09:31:19.40 spid51 Using 'xpstar.dll' version
> I should see SQL server listening on Shared Memory, TCP, Named Pipes.
> I'm missing the TCP in my error log though.
> netstat -an shows that I'm not listening on port 1443.
> C:\Documents and Settings\wlee>netstat -an
> Active Connections
> Proto Local Address Foreign Address State
> TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1027 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
> TCP 192.168.1.202:139 0.0.0.0:0 LISTENING
> TCP 192.168.1.202:139 192.168.1.159:1934 ESTABLISHED
> TCP 192.168.1.202:1031 192.168.1.201:139 ESTABLISHED
> TCP 192.168.1.202:1033 192.168.1.200:139 ESTABLISHED
> TCP 192.168.1.202:3389 192.168.1.159:1923 ESTABLISHED
> UDP 0.0.0.0:445 *:*
> UDP 0.0.0.0:500 *:*
> UDP 0.0.0.0:1034 *:*
> UDP 0.0.0.0:1435 *:*
> UDP 0.0.0.0:4500 *:*
> UDP 127.0.0.1:123 *:*
> UDP 192.168.1.202:123 *:*
> UDP 192.168.1.202:137 *:*
> UDP 192.168.1.202:138 *:*
> C:\Documents and Settings\wlee>
>
> I tried to change it to other ports via the Network Utility but I still
> can't see the TCP in the error log.
>
>
>
> Tibor Karaszi wrote:
>
>[/QUOTE]|||Tibor,
What entry should I search for?
Tibor Karaszi wrote:
Does this make you think that something is wrong with the SQL server and
not the OS?|||You have to do some investigation yourself and compare a healthy and the pro
blematic machine. Here's
a place to start:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\SuperSocketNet
Lib
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Won Lee" <noemail@.nospam.com> wrote in message news:e3BY9tm6DHA.2568@.TK2MSFTNGP10.phx.gbl...[QUOT
E]
> Tibor,
> What entry should I search for?
>
> Tibor Karaszi wrote:
>
there
OK. At this point, I'm almost convinced that something went wrong
during the install process for SQL 2000. No matter what I try, I can
not get SQl to listen on port 1433. I clearly see that named pipes and
tcp is set for the network setting. Port 1433 is the default.
I did a backup of all my databases (to c:\dbbackup) and am going to do
an un-install, reboot, then re-install SQL server.
Is there anything I'm forgetting?Nothing in the errorlog? Of some other service is using 1433, then you'd get
an error in the
errorlog...
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Won Lee" <noemail@.nospam.com> wrote in message news:ujvVGKm6DHA.2576@.TK2MSFTNGP11.phx.gbl...[QUOT
E]
> Hello,
> OK. At this point, I'm almost convinced that something went wrong
> during the install process for SQL 2000. No matter what I try, I can
> not get SQl to listen on port 1433. I clearly see that named pipes and
> tcp is set for the network setting. Port 1433 is the default.
> I did a backup of all my databases (to c:\dbbackup) and am going to do
> an un-install, reboot, then re-install SQL server.
> Is there anything I'm forgetting?
>[/QUOTE]|||Tibor,
Thanks for trying to help me out.
THis is the full cut and paste of my error log.
2004-02-03 09:28:32.10 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
2004-02-03 09:28:32.10 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-02-03 09:28:32.10 server All rights reserved.
2004-02-03 09:28:32.10 server Server Process ID is 1688.
2004-02-03 09:28:32.10 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-02-03 09:28:32.15 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2004-02-03 09:28:32.95 server SQL Server configured for thread mode
processing.
2004-02-03 09:28:32.96 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2004-02-03 09:28:33.01 server Attempting to initialize Distributed
Transaction Coordinator.
2004-02-03 09:28:35.34 spid2 Starting up database 'master'.
2004-02-03 09:28:35.82 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-02-03 09:28:35.82 spid5 Starting up database 'model'.
2004-02-03 09:28:35.87 spid2 Server name is 'WINBOX'.
2004-02-03 09:28:35.87 spid8 Starting up database 'msdb'.
2004-02-03 09:28:35.87 spid9 Starting up database 'equity'.
2004-02-03 09:28:35.87 spid10 Starting up database 'vwap'.
2004-02-03 09:28:36.48 spid5 Clearing tempdb database.
2004-02-03 09:28:38.12 server SQL server listening on Shared Memory,
Named Pipes.
2004-02-03 09:28:38.12 server SQL Server is ready for client connections
2004-02-03 09:28:40.56 spid5 Starting up database 'tempdb'.
2004-02-03 09:28:41.39 spid2 Recovery complete.
2004-02-03 09:31:19.40 spid51 Using 'xpstar.dll' version
I should see SQL server listening on Shared Memory, TCP, Named Pipes.
I'm missing the TCP in my error log though.
netstat -an shows that I'm not listening on port 1443.
C:\Documents and Settings\wlee>netstat -an
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1027 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 192.168.1.202:139 0.0.0.0:0 LISTENING
TCP 192.168.1.202:139 192.168.1.159:1934 ESTABLISHED
TCP 192.168.1.202:1031 192.168.1.201:139 ESTABLISHED
TCP 192.168.1.202:1033 192.168.1.200:139 ESTABLISHED
TCP 192.168.1.202:3389 192.168.1.159:1923 ESTABLISHED
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1034 *:*
UDP 0.0.0.0:1435 *:*
UDP 0.0.0.0:4500 *:*
UDP 127.0.0.1:123 *:*
UDP 192.168.1.202:123 *:*
UDP 192.168.1.202:137 *:*
UDP 192.168.1.202:138 *:*
C:\Documents and Settings\wlee>
I tried to change it to other ports via the Network Utility but I still
can't see the TCP in the error log.
Tibor Karaszi wrote:
quote:|||Yes, my sever has entries such as:
> Nothing in the errorlog? Of some other service is using 1433, then you'd g
et an error in the
> errorlog...
>
2004-02-02 14:15:42.42 server SQL server listening on <IP hiddeen>
...
2004-02-02 14:16:13.95 server SQL server listening on TCP, Named Pipes.
Indeed, it seems like SQL Server doesn't even try to listen to IP. I'd check
the registry so there
isn't anything strange in the registry entry where this configuration is hel
d (compare against a
healthy SQL Server).
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Won Lee" <noemail@.nospam.com> wrote in message news:uFrXSkm6DHA.696@.tk2msftngp13.phx.gbl...[QUOTE
]
> Tibor,
> Thanks for trying to help me out.
> THis is the full cut and paste of my error log.
>
> 2004-02-03 09:28:32.10 server Microsoft SQL Server 2000 - 8.00.194
> (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
> 2004-02-03 09:28:32.10 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2004-02-03 09:28:32.10 server All rights reserved.
> 2004-02-03 09:28:32.10 server Server Process ID is 1688.
> 2004-02-03 09:28:32.10 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2004-02-03 09:28:32.15 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2004-02-03 09:28:32.95 server SQL Server configured for thread mode
> processing.
> 2004-02-03 09:28:32.96 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2004-02-03 09:28:33.01 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2004-02-03 09:28:35.34 spid2 Starting up database 'master'.
> 2004-02-03 09:28:35.82 server Using 'SSNETLIB.DLL' version '8.0.194'.
> 2004-02-03 09:28:35.82 spid5 Starting up database 'model'.
> 2004-02-03 09:28:35.87 spid2 Server name is 'WINBOX'.
> 2004-02-03 09:28:35.87 spid8 Starting up database 'msdb'.
> 2004-02-03 09:28:35.87 spid9 Starting up database 'equity'.
> 2004-02-03 09:28:35.87 spid10 Starting up database 'vwap'.
> 2004-02-03 09:28:36.48 spid5 Clearing tempdb database.
> 2004-02-03 09:28:38.12 server SQL server listening on Shared Memory,
> Named Pipes.
> 2004-02-03 09:28:38.12 server SQL Server is ready for client connection
s
> 2004-02-03 09:28:40.56 spid5 Starting up database 'tempdb'.
> 2004-02-03 09:28:41.39 spid2 Recovery complete.
> 2004-02-03 09:31:19.40 spid51 Using 'xpstar.dll' version
> I should see SQL server listening on Shared Memory, TCP, Named Pipes.
> I'm missing the TCP in my error log though.
> netstat -an shows that I'm not listening on port 1443.
> C:\Documents and Settings\wlee>netstat -an
> Active Connections
> Proto Local Address Foreign Address State
> TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1027 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
> TCP 192.168.1.202:139 0.0.0.0:0 LISTENING
> TCP 192.168.1.202:139 192.168.1.159:1934 ESTABLISHED
> TCP 192.168.1.202:1031 192.168.1.201:139 ESTABLISHED
> TCP 192.168.1.202:1033 192.168.1.200:139 ESTABLISHED
> TCP 192.168.1.202:3389 192.168.1.159:1923 ESTABLISHED
> UDP 0.0.0.0:445 *:*
> UDP 0.0.0.0:500 *:*
> UDP 0.0.0.0:1034 *:*
> UDP 0.0.0.0:1435 *:*
> UDP 0.0.0.0:4500 *:*
> UDP 127.0.0.1:123 *:*
> UDP 192.168.1.202:123 *:*
> UDP 192.168.1.202:137 *:*
> UDP 192.168.1.202:138 *:*
> C:\Documents and Settings\wlee>
>
> I tried to change it to other ports via the Network Utility but I still
> can't see the TCP in the error log.
>
>
>
> Tibor Karaszi wrote:
>
>[/QUOTE]|||Tibor,
What entry should I search for?
Tibor Karaszi wrote:
quote:|||Tibor,
> Yes, my sever has entries such as:
> 2004-02-02 14:15:42.42 server SQL server listening on <IP hiddeen>
> ...
> 2004-02-02 14:16:13.95 server SQL server listening on TCP, Named Pipes.
> Indeed, it seems like SQL Server doesn't even try to listen to IP. I'd che
ck the registry so there
> isn't anything strange in the registry entry where this configuration is h
eld (compare against a
> healthy SQL Server).
>
Does this make you think that something is wrong with the SQL server and
not the OS?|||You have to do some investigation yourself and compare a healthy and the pro
blematic machine. Here's
a place to start:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\SuperSocketNet
Lib
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Won Lee" <noemail@.nospam.com> wrote in message news:e3BY9tm6DHA.2568@.TK2MSFTNGP10.phx.gbl...[QUOT
E]
> Tibor,
> What entry should I search for?
>
> Tibor Karaszi wrote:
>
there
quote:
>
Sunday, February 12, 2012
backup
Hello,
OK. At this point, I'm almost convinced that something went wrong
during the install process for SQL 2000. No matter what I try, I can
not get SQl to listen on port 1433. I clearly see that named pipes and
tcp is set for the network setting. Port 1433 is the default.
I did a backup of all my databases (to c:\dbbackup) and am going to do
an un-install, reboot, then re-install SQL server.
Is there anything I'm forgetting?Nothing in the errorlog? Of some other service is using 1433, then you'd get an error in the
errorlog...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Won Lee" <noemail@.nospam.com> wrote in message news:ujvVGKm6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> Hello,
> OK. At this point, I'm almost convinced that something went wrong
> during the install process for SQL 2000. No matter what I try, I can
> not get SQl to listen on port 1433. I clearly see that named pipes and
> tcp is set for the network setting. Port 1433 is the default.
> I did a backup of all my databases (to c:\dbbackup) and am going to do
> an un-install, reboot, then re-install SQL server.
> Is there anything I'm forgetting?
>|||Tibor,
Thanks for trying to help me out.
THis is the full cut and paste of my error log.
2004-02-03 09:28:32.10 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
2004-02-03 09:28:32.10 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-02-03 09:28:32.10 server All rights reserved.
2004-02-03 09:28:32.10 server Server Process ID is 1688.
2004-02-03 09:28:32.10 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-02-03 09:28:32.15 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2004-02-03 09:28:32.95 server SQL Server configured for thread mode
processing.
2004-02-03 09:28:32.96 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2004-02-03 09:28:33.01 server Attempting to initialize Distributed
Transaction Coordinator.
2004-02-03 09:28:35.34 spid2 Starting up database 'master'.
2004-02-03 09:28:35.82 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-02-03 09:28:35.82 spid5 Starting up database 'model'.
2004-02-03 09:28:35.87 spid2 Server name is 'WINBOX'.
2004-02-03 09:28:35.87 spid8 Starting up database 'msdb'.
2004-02-03 09:28:35.87 spid9 Starting up database 'equity'.
2004-02-03 09:28:35.87 spid10 Starting up database 'vwap'.
2004-02-03 09:28:36.48 spid5 Clearing tempdb database.
2004-02-03 09:28:38.12 server SQL server listening on Shared Memory,
Named Pipes.
2004-02-03 09:28:38.12 server SQL Server is ready for client connections
2004-02-03 09:28:40.56 spid5 Starting up database 'tempdb'.
2004-02-03 09:28:41.39 spid2 Recovery complete.
2004-02-03 09:31:19.40 spid51 Using 'xpstar.dll' version
I should see SQL server listening on Shared Memory, TCP, Named Pipes.
I'm missing the TCP in my error log though.
netstat -an shows that I'm not listening on port 1443.
C:\Documents and Settings\wlee>netstat -an
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1027 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 192.168.1.202:139 0.0.0.0:0 LISTENING
TCP 192.168.1.202:139 192.168.1.159:1934 ESTABLISHED
TCP 192.168.1.202:1031 192.168.1.201:139 ESTABLISHED
TCP 192.168.1.202:1033 192.168.1.200:139 ESTABLISHED
TCP 192.168.1.202:3389 192.168.1.159:1923 ESTABLISHED
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1034 *:*
UDP 0.0.0.0:1435 *:*
UDP 0.0.0.0:4500 *:*
UDP 127.0.0.1:123 *:*
UDP 192.168.1.202:123 *:*
UDP 192.168.1.202:137 *:*
UDP 192.168.1.202:138 *:*
C:\Documents and Settings\wlee>
I tried to change it to other ports via the Network Utility but I still
can't see the TCP in the error log.
Tibor Karaszi wrote:
> Nothing in the errorlog? Of some other service is using 1433, then you'd get an error in the
> errorlog...
>|||Yes, my sever has entries such as:
2004-02-02 14:15:42.42 server SQL server listening on <IP hiddeen>
...
2004-02-02 14:16:13.95 server SQL server listening on TCP, Named Pipes.
Indeed, it seems like SQL Server doesn't even try to listen to IP. I'd check the registry so there
isn't anything strange in the registry entry where this configuration is held (compare against a
healthy SQL Server).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Won Lee" <noemail@.nospam.com> wrote in message news:uFrXSkm6DHA.696@.tk2msftngp13.phx.gbl...
> Tibor,
> Thanks for trying to help me out.
> THis is the full cut and paste of my error log.
>
> 2004-02-03 09:28:32.10 server Microsoft SQL Server 2000 - 8.00.194
> (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
> 2004-02-03 09:28:32.10 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2004-02-03 09:28:32.10 server All rights reserved.
> 2004-02-03 09:28:32.10 server Server Process ID is 1688.
> 2004-02-03 09:28:32.10 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2004-02-03 09:28:32.15 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2004-02-03 09:28:32.95 server SQL Server configured for thread mode
> processing.
> 2004-02-03 09:28:32.96 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2004-02-03 09:28:33.01 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2004-02-03 09:28:35.34 spid2 Starting up database 'master'.
> 2004-02-03 09:28:35.82 server Using 'SSNETLIB.DLL' version '8.0.194'.
> 2004-02-03 09:28:35.82 spid5 Starting up database 'model'.
> 2004-02-03 09:28:35.87 spid2 Server name is 'WINBOX'.
> 2004-02-03 09:28:35.87 spid8 Starting up database 'msdb'.
> 2004-02-03 09:28:35.87 spid9 Starting up database 'equity'.
> 2004-02-03 09:28:35.87 spid10 Starting up database 'vwap'.
> 2004-02-03 09:28:36.48 spid5 Clearing tempdb database.
> 2004-02-03 09:28:38.12 server SQL server listening on Shared Memory,
> Named Pipes.
> 2004-02-03 09:28:38.12 server SQL Server is ready for client connections
> 2004-02-03 09:28:40.56 spid5 Starting up database 'tempdb'.
> 2004-02-03 09:28:41.39 spid2 Recovery complete.
> 2004-02-03 09:31:19.40 spid51 Using 'xpstar.dll' version
> I should see SQL server listening on Shared Memory, TCP, Named Pipes.
> I'm missing the TCP in my error log though.
> netstat -an shows that I'm not listening on port 1443.
> C:\Documents and Settings\wlee>netstat -an
> Active Connections
> Proto Local Address Foreign Address State
> TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1027 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
> TCP 192.168.1.202:139 0.0.0.0:0 LISTENING
> TCP 192.168.1.202:139 192.168.1.159:1934 ESTABLISHED
> TCP 192.168.1.202:1031 192.168.1.201:139 ESTABLISHED
> TCP 192.168.1.202:1033 192.168.1.200:139 ESTABLISHED
> TCP 192.168.1.202:3389 192.168.1.159:1923 ESTABLISHED
> UDP 0.0.0.0:445 *:*
> UDP 0.0.0.0:500 *:*
> UDP 0.0.0.0:1034 *:*
> UDP 0.0.0.0:1435 *:*
> UDP 0.0.0.0:4500 *:*
> UDP 127.0.0.1:123 *:*
> UDP 192.168.1.202:123 *:*
> UDP 192.168.1.202:137 *:*
> UDP 192.168.1.202:138 *:*
> C:\Documents and Settings\wlee>
>
> I tried to change it to other ports via the Network Utility but I still
> can't see the TCP in the error log.
>
>
>
> Tibor Karaszi wrote:
> > Nothing in the errorlog? Of some other service is using 1433, then you'd get an error in the
> > errorlog...
> >
>|||Tibor,
What entry should I search for?
Tibor Karaszi wrote:
> Yes, my sever has entries such as:
> 2004-02-02 14:15:42.42 server SQL server listening on <IP hiddeen>
> ...
> 2004-02-02 14:16:13.95 server SQL server listening on TCP, Named Pipes.
> Indeed, it seems like SQL Server doesn't even try to listen to IP. I'd check the registry so there
> isn't anything strange in the registry entry where this configuration is held (compare against a
> healthy SQL Server).
>|||Tibor,
Does this make you think that something is wrong with the SQL server and
not the OS?|||You have to do some investigation yourself and compare a healthy and the problematic machine. Here's
a place to start:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Won Lee" <noemail@.nospam.com> wrote in message news:e3BY9tm6DHA.2568@.TK2MSFTNGP10.phx.gbl...
> Tibor,
> What entry should I search for?
>
> Tibor Karaszi wrote:
> > Yes, my sever has entries such as:
> >
> > 2004-02-02 14:15:42.42 server SQL server listening on <IP hiddeen>
> > ...
> > 2004-02-02 14:16:13.95 server SQL server listening on TCP, Named Pipes.
> >
> > Indeed, it seems like SQL Server doesn't even try to listen to IP. I'd check the registry so
there
> > isn't anything strange in the registry entry where this configuration is held (compare against a
> > healthy SQL Server).
> >
>
OK. At this point, I'm almost convinced that something went wrong
during the install process for SQL 2000. No matter what I try, I can
not get SQl to listen on port 1433. I clearly see that named pipes and
tcp is set for the network setting. Port 1433 is the default.
I did a backup of all my databases (to c:\dbbackup) and am going to do
an un-install, reboot, then re-install SQL server.
Is there anything I'm forgetting?Nothing in the errorlog? Of some other service is using 1433, then you'd get an error in the
errorlog...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Won Lee" <noemail@.nospam.com> wrote in message news:ujvVGKm6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> Hello,
> OK. At this point, I'm almost convinced that something went wrong
> during the install process for SQL 2000. No matter what I try, I can
> not get SQl to listen on port 1433. I clearly see that named pipes and
> tcp is set for the network setting. Port 1433 is the default.
> I did a backup of all my databases (to c:\dbbackup) and am going to do
> an un-install, reboot, then re-install SQL server.
> Is there anything I'm forgetting?
>|||Tibor,
Thanks for trying to help me out.
THis is the full cut and paste of my error log.
2004-02-03 09:28:32.10 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
2004-02-03 09:28:32.10 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-02-03 09:28:32.10 server All rights reserved.
2004-02-03 09:28:32.10 server Server Process ID is 1688.
2004-02-03 09:28:32.10 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-02-03 09:28:32.15 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2004-02-03 09:28:32.95 server SQL Server configured for thread mode
processing.
2004-02-03 09:28:32.96 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2004-02-03 09:28:33.01 server Attempting to initialize Distributed
Transaction Coordinator.
2004-02-03 09:28:35.34 spid2 Starting up database 'master'.
2004-02-03 09:28:35.82 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-02-03 09:28:35.82 spid5 Starting up database 'model'.
2004-02-03 09:28:35.87 spid2 Server name is 'WINBOX'.
2004-02-03 09:28:35.87 spid8 Starting up database 'msdb'.
2004-02-03 09:28:35.87 spid9 Starting up database 'equity'.
2004-02-03 09:28:35.87 spid10 Starting up database 'vwap'.
2004-02-03 09:28:36.48 spid5 Clearing tempdb database.
2004-02-03 09:28:38.12 server SQL server listening on Shared Memory,
Named Pipes.
2004-02-03 09:28:38.12 server SQL Server is ready for client connections
2004-02-03 09:28:40.56 spid5 Starting up database 'tempdb'.
2004-02-03 09:28:41.39 spid2 Recovery complete.
2004-02-03 09:31:19.40 spid51 Using 'xpstar.dll' version
I should see SQL server listening on Shared Memory, TCP, Named Pipes.
I'm missing the TCP in my error log though.
netstat -an shows that I'm not listening on port 1443.
C:\Documents and Settings\wlee>netstat -an
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1027 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 192.168.1.202:139 0.0.0.0:0 LISTENING
TCP 192.168.1.202:139 192.168.1.159:1934 ESTABLISHED
TCP 192.168.1.202:1031 192.168.1.201:139 ESTABLISHED
TCP 192.168.1.202:1033 192.168.1.200:139 ESTABLISHED
TCP 192.168.1.202:3389 192.168.1.159:1923 ESTABLISHED
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1034 *:*
UDP 0.0.0.0:1435 *:*
UDP 0.0.0.0:4500 *:*
UDP 127.0.0.1:123 *:*
UDP 192.168.1.202:123 *:*
UDP 192.168.1.202:137 *:*
UDP 192.168.1.202:138 *:*
C:\Documents and Settings\wlee>
I tried to change it to other ports via the Network Utility but I still
can't see the TCP in the error log.
Tibor Karaszi wrote:
> Nothing in the errorlog? Of some other service is using 1433, then you'd get an error in the
> errorlog...
>|||Yes, my sever has entries such as:
2004-02-02 14:15:42.42 server SQL server listening on <IP hiddeen>
...
2004-02-02 14:16:13.95 server SQL server listening on TCP, Named Pipes.
Indeed, it seems like SQL Server doesn't even try to listen to IP. I'd check the registry so there
isn't anything strange in the registry entry where this configuration is held (compare against a
healthy SQL Server).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Won Lee" <noemail@.nospam.com> wrote in message news:uFrXSkm6DHA.696@.tk2msftngp13.phx.gbl...
> Tibor,
> Thanks for trying to help me out.
> THis is the full cut and paste of my error log.
>
> 2004-02-03 09:28:32.10 server Microsoft SQL Server 2000 - 8.00.194
> (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
> 2004-02-03 09:28:32.10 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2004-02-03 09:28:32.10 server All rights reserved.
> 2004-02-03 09:28:32.10 server Server Process ID is 1688.
> 2004-02-03 09:28:32.10 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2004-02-03 09:28:32.15 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2004-02-03 09:28:32.95 server SQL Server configured for thread mode
> processing.
> 2004-02-03 09:28:32.96 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2004-02-03 09:28:33.01 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2004-02-03 09:28:35.34 spid2 Starting up database 'master'.
> 2004-02-03 09:28:35.82 server Using 'SSNETLIB.DLL' version '8.0.194'.
> 2004-02-03 09:28:35.82 spid5 Starting up database 'model'.
> 2004-02-03 09:28:35.87 spid2 Server name is 'WINBOX'.
> 2004-02-03 09:28:35.87 spid8 Starting up database 'msdb'.
> 2004-02-03 09:28:35.87 spid9 Starting up database 'equity'.
> 2004-02-03 09:28:35.87 spid10 Starting up database 'vwap'.
> 2004-02-03 09:28:36.48 spid5 Clearing tempdb database.
> 2004-02-03 09:28:38.12 server SQL server listening on Shared Memory,
> Named Pipes.
> 2004-02-03 09:28:38.12 server SQL Server is ready for client connections
> 2004-02-03 09:28:40.56 spid5 Starting up database 'tempdb'.
> 2004-02-03 09:28:41.39 spid2 Recovery complete.
> 2004-02-03 09:31:19.40 spid51 Using 'xpstar.dll' version
> I should see SQL server listening on Shared Memory, TCP, Named Pipes.
> I'm missing the TCP in my error log though.
> netstat -an shows that I'm not listening on port 1443.
> C:\Documents and Settings\wlee>netstat -an
> Active Connections
> Proto Local Address Foreign Address State
> TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:1027 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
> TCP 192.168.1.202:139 0.0.0.0:0 LISTENING
> TCP 192.168.1.202:139 192.168.1.159:1934 ESTABLISHED
> TCP 192.168.1.202:1031 192.168.1.201:139 ESTABLISHED
> TCP 192.168.1.202:1033 192.168.1.200:139 ESTABLISHED
> TCP 192.168.1.202:3389 192.168.1.159:1923 ESTABLISHED
> UDP 0.0.0.0:445 *:*
> UDP 0.0.0.0:500 *:*
> UDP 0.0.0.0:1034 *:*
> UDP 0.0.0.0:1435 *:*
> UDP 0.0.0.0:4500 *:*
> UDP 127.0.0.1:123 *:*
> UDP 192.168.1.202:123 *:*
> UDP 192.168.1.202:137 *:*
> UDP 192.168.1.202:138 *:*
> C:\Documents and Settings\wlee>
>
> I tried to change it to other ports via the Network Utility but I still
> can't see the TCP in the error log.
>
>
>
> Tibor Karaszi wrote:
> > Nothing in the errorlog? Of some other service is using 1433, then you'd get an error in the
> > errorlog...
> >
>|||Tibor,
What entry should I search for?
Tibor Karaszi wrote:
> Yes, my sever has entries such as:
> 2004-02-02 14:15:42.42 server SQL server listening on <IP hiddeen>
> ...
> 2004-02-02 14:16:13.95 server SQL server listening on TCP, Named Pipes.
> Indeed, it seems like SQL Server doesn't even try to listen to IP. I'd check the registry so there
> isn't anything strange in the registry entry where this configuration is held (compare against a
> healthy SQL Server).
>|||Tibor,
Does this make you think that something is wrong with the SQL server and
not the OS?|||You have to do some investigation yourself and compare a healthy and the problematic machine. Here's
a place to start:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Won Lee" <noemail@.nospam.com> wrote in message news:e3BY9tm6DHA.2568@.TK2MSFTNGP10.phx.gbl...
> Tibor,
> What entry should I search for?
>
> Tibor Karaszi wrote:
> > Yes, my sever has entries such as:
> >
> > 2004-02-02 14:15:42.42 server SQL server listening on <IP hiddeen>
> > ...
> > 2004-02-02 14:16:13.95 server SQL server listening on TCP, Named Pipes.
> >
> > Indeed, it seems like SQL Server doesn't even try to listen to IP. I'd check the registry so
there
> > isn't anything strange in the registry entry where this configuration is held (compare against a
> > healthy SQL Server).
> >
>
Subscribe to:
Posts (Atom)