HELP!...VB.NET killed SQL Server

Hi,
Yesterday I installed VB.NET on my machine. I had been runnng SQL Server
2000. After the install SQL Server will not run. SQLAgent fails with the
error "1068: The dependency service or group failed to start". When I try to
start MSSQL service I get a message it started then stopped because it may
not have anything to do.
I was planning to install SP3 of SQL Server 2000, so I tried that, but it
fails to install because (it seems) it needs SQL Server to be running.
Any ideas? Right now I desperately need SQL Server but not VB. So, I
guess my next move is to un-install VB.NET, which is going to be a royal
pain, and that may not even work because such a big install cannot be truly
uninstalled. After that I would fall back to an OS restore point.
Help, please!
Tim
> When I try to
> start MSSQL service I get a message it started then stopped because it may
> not have anything to do.
Can you post the SQL Server errorlog file? Assuming it is only a few rows, of course...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:D3C2B8A5-17F9-448D-8EA0-19F5A4119907@.microsoft.com...
> Hi,
> Yesterday I installed VB.NET on my machine. I had been runnng SQL Server
> 2000. After the install SQL Server will not run. SQLAgent fails with the
> error "1068: The dependency service or group failed to start". When I try to
> start MSSQL service I get a message it started then stopped because it may
> not have anything to do.
> I was planning to install SP3 of SQL Server 2000, so I tried that, but it
> fails to install because (it seems) it needs SQL Server to be running.
> Any ideas? Right now I desperately need SQL Server but not VB. So, I
> guess my next move is to un-install VB.NET, which is going to be a royal
> pain, and that may not even work because such a big install cannot be truly
> uninstalled. After that I would fall back to an OS restore point.
> Help, please!
> Tim
|||Thanks! I ran the SQL Server setup program with the option "Rebuild
Registry" and now it seems fine. Thanks again!
Tim
"Tibor Karaszi" wrote:

> Can you post the SQL Server errorlog file? Assuming it is only a few rows, of course...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tim" <Tim@.discussions.microsoft.com> wrote in message
> news:D3C2B8A5-17F9-448D-8EA0-19F5A4119907@.microsoft.com...
>
>

HELP!

how do i reduce the size of an mdf and ldf file in sql server2000. they have
grown to the point of locking up my machineYou can use DBCC SHRINKFILE. See BOL for syntax plus look at
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/defaul...b;en-us;Q272318
INF: Causes of SQL Transaction Log Filling Up
http://support.microsoft.com/defaul...b;en-us;Q110139
INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server
http://support.microsoft.com/defaul...kb;EN-US;317375
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"DAVE" <anonymous@.discussions.microsoft.com> wrote in message
news:64DAA4E3-173F-43B6-A12A-104336227E8A@.microsoft.com...
> how do i reduce the size of an mdf and ldf file in sql server2000. they
have grown to the point of locking up my machine|||Hi,
The best option is shrinking the transaction log and data file individually
using the DBCC SHRINKFILE command.
How to check the Transaction log file size and usage, execute the below
command
DBCC SQLPERF(LOGSPACE)
How to shrink the transaction log file if your database is FULL recovery
model.
1. Backup the Transaction Log using (Backup log command)
2. Use DBCC SHRINKFILE('logical_tran_log_name','Trun
cateonly')
How to shrink the transaction log file if your database is Simple recovery
model.
1. Truncate the Transaction Log using (Backup log dbname with triuncateonly
command)
2. Use DBCC SHRINKFILE('logical_tran_log_name','Trun
cate_only')
How to shrink the data files
1. Check any open transactions or there using DBCC OPENTRAN(DBname)
2. If not, Run DBCC SHRINKFILE('logical_datafile_name',size)
Note:
If your data is not that critical (Development Server) and if you do not
require a time based
recovery go for SIMPLE recovery Model for your database. This
require less monitoring of tranasction log usage.
Thanks
Hari
MCDBA
"DAVE" <anonymous@.discussions.microsoft.com> wrote in message
news:64DAA4E3-173F-43B6-A12A-104336227E8A@.microsoft.com...
> how do i reduce the size of an mdf and ldf file in sql server2000. they
have grown to the point of locking up my machine