Can't shrink transaction log

Hi,
A SQL Server2000 database we have has ended up with a
massive Transaction Log (basically because the maintenance
schedule needs looking at).
Anyway to cut a long story short, I backed up the
transaction log which truncated it, but I can't seem to
shrink the logfile to free up the space.
I tried:
DBCC SHRINKFILE (2, 200, TRUNCATEONLY)
[where 2 is the filenumber of the logfile]
This came back with:
'Cannot shrink log file 2 (Main_Log) because all logical
log files are in use.'
Can anyone tell me how I can shrink this log file please?
Regards,
VinceVince Beaney wrote:

> Can anyone tell me how I can shrink this log file please?
Check out below KB articles:
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/defaul...kb;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/defaul...kb;en-us;272318
Log File Grows too big
http://www.support.microsoft.com/?id=317375
Log file filling up
http://www.support.microsoft.com/?id=110139
Considerations for Autogrow and AutoShrink
http://www.support.microsoft.com/?id=315512
http://www.mssqlserver.com/faq/logs-shrinklog.asp
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||I have had a similar problem. The only thing that worked was running these
commands:
First, backup the log with truncate_only:
BACKUP Log DBNAME with TRUNCATE_ONLY
Then you can run the SHRINKFILE DBCC Command:
DBCC SHRINKFILE (LOGFILE, 10)|||Excellent!
Thankyou, the "INF: Shrinking the Transaction Log in SQL
Server 2000 with DBCC SHRINKFILE" is what I was looking
for.
Thanks,
Vince

>--Original Message--
>Vince Beaney wrote:
>
please?
>Check out below KB articles:
>INF: How to Shrink the SQL Server 7.0 Transaction Log
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;256650
>INF: Shrinking the Transaction Log in SQL Server 2000
with DBCC SHRINKFILE
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;272318
>Log File Grows too big
>http://www.support.microsoft.com/?id=317375
>Log file filling up
>http://www.support.microsoft.com/?id=110139
>Considerations for Autogrow and AutoShrink
>http://www.support.microsoft.com/?id=315512
>http://www.mssqlserver.com/faq/logs-shrinklog.asp
>sincerely,
>--
>Sebastian K. Zaklada
>Skilled Software
>http://www.skilledsoftware.com
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>.
>sql

Cant install msde on server2000

Anybody out there know why i can't install MSDE on a win2000 server. I start
setup in dos mode with sapwd ="password" but it dies without error
messages.
Thanks in advance
hi,
news wrote:
> Anybody out there know why i can't install MSDE on a win2000 server.
> I start setup in dos mode with sapwd ="password" but it dies without
> error messages.
> Thanks in advance
please add verbose logging of the installation process providing the
/L*v "c:\msde.log"
parameter to your call to setup.exe boostrap installer... this will output
an about 2mb text file (for a succesfull installation) you can later inspect
for
RETURN VALUE 3
entries... about 10/15 lines before each entry som (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi thanks for the reply i tried it nut cant read the cryptic merror report
or rather cant understand it
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3ii0fpFljhkoU1@.individual.net...
> hi,
> news wrote:
> please add verbose logging of the installation process providing the
> /L*v "c:\msde.log"
> parameter to your call to setup.exe boostrap installer... this will output
> an about 2mb text file (for a succesfull installation) you can later
> inspect for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry som (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||him
news wrote:
> Hi thanks for the reply i tried it nut cant read the cryptic merror
> report or rather cant understand it
perhaps we can help you...
try reporting the lines indicating the problem..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||See my post "Corrupted MSDE files encountered" posted 7/2/2005. Maybe you
have the same problem I did.
Axel Larson,
Share What You Know,
Learn What You Don't
"news" <news@.c.com> wrote in message
news:HL-dnaakovg48F7fRVn-ow@.rogers.com...
> Anybody out there know why i can't install MSDE on a win2000 server. I
start
> setup in dos mode with sapwd ="password" but it dies without error
> messages.
> Thanks in advance
>
|||Hi, I don't know if I have the same problem as News.
This is just the last part of the log file.
Thanks!
MSI (c) (58:60) [09:49:42:814]: Note: 1: 1708
MSI (c) (58:60) [09:49:42:814]: Product: Microsoft SQL Server Desktop
Engine -- Installation operation failed.
MSI (c) (58:60) [09:49:42:830]: Grabbed execution mutex.
MSI (c) (58:60) [09:49:42:830]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (58:60) [09:49:42:830]: MainEngineThread is returning 1603
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3ij10tFlrda6U1@.individual.net...
> him
> news wrote:
> perhaps we can help you...
> try reporting the lines indicating the problem..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi,
Gule wrote:
> Hi, I don't know if I have the same problem as News.
> This is just the last part of the log file.
please isolate the relevand part of the log reporting
RETURN VALUE 3
... about 10/15 lines before each entry some (sometime cryptic) description
of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Actually, i solved the problem. I run the setup2.msi and installation passed
without problem!?
Thanks anyway!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3jnfloFqq68uU1@.individual.net...
> hi,
> Gule wrote:
> please isolate the relevand part of the log reporting
> RETURN VALUE 3
> ... about 10/15 lines before each entry some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi Andrea,
We are experiencing the same issue while installing MSDE 2K on a Windows 2K
(SP3) machine. It gives out the error: 1603.
Here is the excerpt from the MSDE install verbose log of the 10-15 lines
before the 'Return Value 3' happens (2 occurences in the log)
-----
-----
1.Starting custom action SkuIt
MSI (s) (24:C0): Executing op:
ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
Action 14:03:31: ConfigServer.2D02443E_7002_4C0B_ABC9_EAB2C064397B. ..
MSI (s) (24:C0): Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (24:C0): Creating MSIHANDLE (214) of type 790536 for thread 1984
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\D35166.000\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\D35166.000\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
Executing "C:\WINNT\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
"SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
Action ended 14:04:04: InstallFinalize. Return value 3.
-----
2. Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (24:C0): Executing op: End(Checksum=0,ProgressTotal=0)
MSI (s) (24:C0): Error in rollback skipped. Return: 5
MSI (s) (24:C0): FEATURECACHE: Entering Invalidate
MSI (s) (24:C0): Unlocking Server
Action ended 14:04:24: INSTALL. Return value 3.
-----
-----
I will greatly appreciate any direction to help resolve this issue.
Regards,
Srinivas
"Andrea Montanari" wrote:

> hi,
> Gule wrote:
> please isolate the relevand part of the log reporting
> RETURN VALUE 3
> ... about 10/15 lines before each entry some (sometime cryptic) description
> of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
Srinivas Rampalli wrote:
> Hi Andrea,
> "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> Action ended 14:04:04: InstallFinalize. Return value 3.
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Cant install MSDE - Get message about Strong Passwords

Hi, I am a newbie when it comes to SQL. At work I was
handed a 4 inch thick book titled, 'Microsoft SQL Server
2000', and a book on just the learning SQL language. Im
trying to spend time at work learning this but I have many
other functions and work to take care of. So I asked my
boss and he told me that if I wanted to be able to
continue studying at home that I would need to download
the free version of SQL Server which is called MSDE and is
available to download from Microsoft. So I went home and
downloaded it. Here is the problem...When I try to
install it using SETUP.exe, I get a message informing me
that a SA password is required to install the program. I
have no Idea what that is except that is refered to as a
strong password.
At that point it tell me I need to use some other thing to
supply a SA password and then it will continue to install
the program. I think its expecting me to already know a
bit about SQL which I dont, and also expects me to know
how to install a program via command lines which I dont.
Does anyone know what i'm talking about here, and if so,
what is the laymans, easiest way to accomplish what it is
the istall program wants me to do? Please dont refer me
to some microsoft informational document. I tried that
last night and all it did was confuse me, as they assume
that I know more than I do. I just want to be able to
install the MSDE program on my home computer and once
thats done Ill probably need some hints on how to set up
MSDE to be run for the first time...like how to make it
look at a database thats local. From there on I can muddle
throught the actual learning process on my own.
Thanks in advance for your help!
Tim
Tim,
ReadmeMSDE2000A.htm comes with your download and it talks about common
installation problems.
To install MSDE, you need to supply a strong pasword for sa (something that
is not empty). You can open a DOS prompt, change to the MSDE setup.exe
directory and run 'setup SAPWD=<yourpassword>'
Thanks,
Amy
| Content-Class: urn:content-classes:message
| From: "Tim" <twilliams@.indicopublic.com>
| Sender: "Tim" <twilliams@.indicopublic.com>
| Subject: Cant install MSDE - Get message about Strong Passwords
| Date: Wed, 7 Apr 2004 12:02:42 -0700
| Lines: 32
| Message-ID: <19ab501c41cd2$e7a4bea0$a401280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQc0uekPVanx5LCRE+b6Cmo5Vvz2Q==
| Newsgroups: microsoft.public.sqlserver.msde
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13487
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Hi, I am a newbie when it comes to SQL. At work I was
| handed a 4 inch thick book titled, 'Microsoft SQL Server
| 2000', and a book on just the learning SQL language. Im
| trying to spend time at work learning this but I have many
| other functions and work to take care of. So I asked my
| boss and he told me that if I wanted to be able to
| continue studying at home that I would need to download
| the free version of SQL Server which is called MSDE and is
| available to download from Microsoft. So I went home and
| downloaded it. Here is the problem...When I try to
| install it using SETUP.exe, I get a message informing me
| that a SA password is required to install the program. I
| have no Idea what that is except that is refered to as a
| strong password.
| At that point it tell me I need to use some other thing to
| supply a SA password and then it will continue to install
| the program. I think its expecting me to already know a
| bit about SQL which I dont, and also expects me to know
| how to install a program via command lines which I dont.
| Does anyone know what i'm talking about here, and if so,
| what is the laymans, easiest way to accomplish what it is
| the istall program wants me to do? Please dont refer me
| to some microsoft informational document. I tried that
| last night and all it did was confuse me, as they assume
| that I know more than I do. I just want to be able to
| install the MSDE program on my home computer and once
| thats done Ill probably need some hints on how to set up
| MSDE to be run for the first time...like how to make it
| look at a database thats local. From there on I can muddle
| throught the actual learning process on my own.
| Thanks in advance for your help!
| Tim
|