When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.
Bin,
How are you trying to shrink this log? What other steps have you taken before trying to shrink? Are you doing this from enterprise manage or through query analyzer?
Please post the exact error message here and someone may be able to assist.
Tunji O
"BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.
|||I shrink data through SQL Server Enterprise Manager All Tasks Shrink Database
task the error message as follow:
Microsoft SQL-DMO(ODBC SQLSTATE:42000)
Error 3140:Could not adjust the space allocation for the file'truck_data'.
DBCC execution completeed. If DBCC printed error messages, contact your
system administrator.
"Tunji" wrote:
> Bin,
> How are you trying to shrink this log? What other steps have you taken before trying to shrink? Are you doing this from enterprise manage or through query analyzer?
> Please post the exact error message here and someone may be able to assist.
> Tunji O
> "BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
> When I do shrink trans log file or database error message came out "Error
> 3140 Could not adjust the space allocation for the file". I search on
> Microsoft WEB only show SQL 7.0. Can someone help me please I already
> installed SP3 for it
Showing posts with label allocation. Show all posts
Showing posts with label allocation. Show all posts
Sunday, February 26, 2012
Error 3140 on SQL Server 2000
When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.Bin,
How are you trying to shrink this log? What other steps have you taken befor
e trying to shrink? Are you doing this from enterprise manage or through que
ry analyzer?
Please post the exact error message here and someone may be able to assist.
Tunji O
"BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE
5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.|||I shrink data through SQL Server Enterprise Manager All Tasks Shrink Databas
e
task the error message as follow:
Microsoft SQL-DMO(ODBC SQLSTATE:42000)
Error 3140:Could not adjust the space allocation for the file'truck_data'.
DBCC execution completeed. If DBCC printed error messages, contact your
system administrator.
"Tunji" wrote:
> Bin,
> How are you trying to shrink this log? What other steps have you taken bef
ore trying to shrink? Are you doing this from enterprise manage or through q
uery analyzer?
> Please post the exact error message here and someone may be able to assist
.
> Tunji O
> "BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B6
28FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
> When I do shrink trans log file or database error message came out "Erro
r
> 3140 Could not adjust the space allocation for the file". I search on
> Microsoft WEB only show SQL 7.0. Can someone help me please I already
> installed SP3 for it
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.Bin,
How are you trying to shrink this log? What other steps have you taken befor
e trying to shrink? Are you doing this from enterprise manage or through que
ry analyzer?
Please post the exact error message here and someone may be able to assist.
Tunji O
"BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE
5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.|||I shrink data through SQL Server Enterprise Manager All Tasks Shrink Databas
e
task the error message as follow:
Microsoft SQL-DMO(ODBC SQLSTATE:42000)
Error 3140:Could not adjust the space allocation for the file'truck_data'.
DBCC execution completeed. If DBCC printed error messages, contact your
system administrator.
"Tunji" wrote:
> Bin,
> How are you trying to shrink this log? What other steps have you taken bef
ore trying to shrink? Are you doing this from enterprise manage or through q
uery analyzer?
> Please post the exact error message here and someone may be able to assist
.
> Tunji O
> "BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B6
28FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
> When I do shrink trans log file or database error message came out "Erro
r
> 3140 Could not adjust the space allocation for the file". I search on
> Microsoft WEB only show SQL 7.0. Can someone help me please I already
> installed SP3 for it
Error 3140 on SQL Server 2000
When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.This is a multi-part message in MIME format.
--=_NextPart_000_008A_01C4CCFC.9D0630B0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Bin,
How are you trying to shrink this log? What other steps have you taken =before trying to shrink? Are you doing this from enterprise manage or =through query analyzer? Please post the exact error message here and someone may be able to =assist.
Tunji O
"BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message =news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
When I do shrink trans log file or database error message came out ="Error 3140 Could not adjust the space allocation for the file". I search on Microsoft WEB only show SQL 7.0. Can someone help me please I already installed SP3 for it.
--=_NextPart_000_008A_01C4CCFC.9D0630B0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Bin,
How are you trying to shrink this log? =What other steps have you taken before trying to shrink? Are you doing this from =enterprise manage or through query analyzer?
Please post the exact error message =here and someone may be able to assist.
Tunji O
"BIN YANG" wrote in message news:8B6=28FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...When I do shrink trans log file or database error message came out "Error =3140 Could not adjust the space allocation for the file". I search on =Microsoft WEB only show SQL 7.0. Can someone help me please I already =installed SP3 for it.
--=_NextPart_000_008A_01C4CCFC.9D0630B0--|||I shrink data through SQL Server Enterprise Manager All Tasks Shrink Database
task the error message as follow:
Microsoft SQL-DMO(ODBC SQLSTATE:42000)
Error 3140:Could not adjust the space allocation for the file'truck_data'.
DBCC execution completeed. If DBCC printed error messages, contact your
system administrator.
"Tunji" wrote:
> Bin,
> How are you trying to shrink this log? What other steps have you taken before trying to shrink? Are you doing this from enterprise manage or through query analyzer?
> Please post the exact error message here and someone may be able to assist.
> Tunji O
> "BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
> When I do shrink trans log file or database error message came out "Error
> 3140 Could not adjust the space allocation for the file". I search on
> Microsoft WEB only show SQL 7.0. Can someone help me please I already
> installed SP3 for it
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.This is a multi-part message in MIME format.
--=_NextPart_000_008A_01C4CCFC.9D0630B0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Bin,
How are you trying to shrink this log? What other steps have you taken =before trying to shrink? Are you doing this from enterprise manage or =through query analyzer? Please post the exact error message here and someone may be able to =assist.
Tunji O
"BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message =news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
When I do shrink trans log file or database error message came out ="Error 3140 Could not adjust the space allocation for the file". I search on Microsoft WEB only show SQL 7.0. Can someone help me please I already installed SP3 for it.
--=_NextPart_000_008A_01C4CCFC.9D0630B0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Bin,
How are you trying to shrink this log? =What other steps have you taken before trying to shrink? Are you doing this from =enterprise manage or through query analyzer?
Please post the exact error message =here and someone may be able to assist.
Tunji O
"BIN YANG"
--=_NextPart_000_008A_01C4CCFC.9D0630B0--|||I shrink data through SQL Server Enterprise Manager All Tasks Shrink Database
task the error message as follow:
Microsoft SQL-DMO(ODBC SQLSTATE:42000)
Error 3140:Could not adjust the space allocation for the file'truck_data'.
DBCC execution completeed. If DBCC printed error messages, contact your
system administrator.
"Tunji" wrote:
> Bin,
> How are you trying to shrink this log? What other steps have you taken before trying to shrink? Are you doing this from enterprise manage or through query analyzer?
> Please post the exact error message here and someone may be able to assist.
> Tunji O
> "BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
> When I do shrink trans log file or database error message came out "Error
> 3140 Could not adjust the space allocation for the file". I search on
> Microsoft WEB only show SQL 7.0. Can someone help me please I already
> installed SP3 for it
Subscribe to:
Posts (Atom)