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
No comments:
Post a Comment