hello
when i execute this command:
DBCC DBREINDEX ('dbo.OV_PM_LPolGroupAssignment',
PK_OV_PM_LPolGroupAssignment)
GO
give me this error:
Server: Msg 9002, Level 17, State 6, Line 1
The log file for database 'openview' is full. Back up the transaction log
for the database to free up some log space.
The statement has been terminated.
How can fix this? or what can i do ?
Regards
José Júlio DuarteHi
Every operation in the database is logged to t -log file
Set recovery mode of the database to SIMPLE and run this commnad again
"Jos? J?lio Duarte" <JosJlioDuarte@.discussions.microsoft.com> wrote in
message news:73E755C8-ECC5-43C2-A38C-400A68040BBD@.microsoft.com...
> hello
> when i execute this command:
> DBCC DBREINDEX ('dbo.OV_PM_LPolGroupAssignment',
> PK_OV_PM_LPolGroupAssignment)
> GO
> give me this error:
> Server: Msg 9002, Level 17, State 6, Line 1
> The log file for database 'openview' is full. Back up the transaction log
> for the database to free up some log space.
> The statement has been terminated.
> How can fix this? or what can i do ?
> Regards
> Jos? J?lio Duarte|||This is a multi-part message in MIME format.
--090303040507050906090408
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
José Júlio Duarte wrote:
> hello
> when i execute this command:
> DBCC DBREINDEX ('dbo.OV_PM_LPolGroupAssignment',
> PK_OV_PM_LPolGroupAssignment)
> GO
> give me this error:
> Server: Msg 9002, Level 17, State 6, Line 1
> The log file for database 'openview' is full. Back up the transaction log
> for the database to free up some log space.
> The statement has been terminated.
> How can fix this? or what can i do ?
> Regards
> José Júlio Duarte
>
You could either:
1: Backup the logfile to truncate the file so the space can be re-used.
(Look up BACKUP LOG in Books On Line)
2: Set the Autogrow ON for the logfile. (Look up ALTER DATABASE in Books
On Line )
3: Manually increase the logfile size. (Look up ALTER DATABASE in Books
On Line)
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--090303040507050906090408
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
José Júlio Duarte wrote:
<blockquote cite="mid73E755C8-ECC5-43C2-A38C-400A68040BBD@.microsoft.com"
type="cite">
<pre wrap="">hello
when i execute this command:
DBCC DBREINDEX ('dbo.OV_PM_LPolGroupAssignment',
PK_OV_PM_LPolGroupAssignment)
GO
give me this error:
Server: Msg 9002, Level 17, State 6, Line 1
The log file for database 'openview' is full. Back up the transaction log
for the database to free up some log space.
The statement has been terminated.
How can fix this? or what can i do ?
Regards
José Júlio Duarte
</pre>
</blockquote>
<font size="-1"><font face="Arial">You could either:<br>
<br>
1: Backup the logfile to truncate the file so the space can be re-used.
(Look up BACKUP LOG in Books On Line)<br>
2: Set the Autogrow ON for the logfile. (Look up ALTER DATABASE in
Books On Line )<br>
3: Manually increase the logfile size. (Look up ALTER DATABASE in Books
On Line)<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--090303040507050906090408--|||You can use DBCC SHRINKFILE (logical filename ... logsize)
to physically shrink the file for want of disk space
M A Srinivas
Jos=E9 J=FAlio Duarte wrote:
> hello
> when i execute this command:
> DBCC DBREINDEX ('dbo.OV_PM_LPolGroupAssignment',
> PK_OV_PM_LPolGroupAssignment)
> GO
> give me this error:
> Server: Msg 9002, Level 17, State 6, Line 1
> The log file for database 'openview' is full. Back up the transaction log
> for the database to free up some log space.
> The statement has been terminated.
> How can fix this? or what can i do ?
> > Regards
> > Jos=E9 J=FAlio Duarte|||masri999@.gmail.com wrote:
> You can use DBCC SHRINKFILE (logical filename ... logsize)
> to physically shrink the file for want of disk space
> M A Srinivas
>
I doubt that will make any difference? If SQL server reports that the
logfile is full, then there're no free space in the file meaning that
you can't shrink it.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator|||The first obvious thing to try would be to backup the log file as it states
in the error message. If there still isn't enough log space after backing
up the log you will need to expand the size of the log file somehow - either
free up some space or add another file to the log
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"José Júlio Duarte" <JosJlioDuarte@.discussions.microsoft.com> wrote in
message news:73E755C8-ECC5-43C2-A38C-400A68040BBD@.microsoft.com...
> hello
> when i execute this command:
> DBCC DBREINDEX ('dbo.OV_PM_LPolGroupAssignment',
> PK_OV_PM_LPolGroupAssignment)
> GO
> give me this error:
> Server: Msg 9002, Level 17, State 6, Line 1
> The log file for database 'openview' is full. Back up the transaction log
> for the database to free up some log space.
> The statement has been terminated.
> How can fix this? or what can i do ?
> Regards
> José Júlio Duarte
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment