No diskspace free at the moment ... 🙁

And the database can't have a downtime 🙁

It could grow till disk is full (=40Gb).

That was the problem.. 🙁

I don't know why they have 2 log files... I'm just here for 1 week (as consultant) and i received this errors in my checks, so I'm trying to solve...

GilaMonster (7/11/2011)

---

As I said, it could simply have been that the autogrow wasn't fast enough. Grow the logs, see if that helps (and make sure you don't have autoshrink or...

Error is on both db's, but especialy the A105_A is important here...

I know the data and log are on the same disk, but there's still enough diskspace on (30Gb)

/****** Object: Database [A105_A] Script Date: 07/11/2011 10:48:31 ******/

CREATE DATABASE [A105_A] ON PRIMARY

( NAME = N'VUMNIEUWS_Data', FILENAME = N'D:\Microsoft SQL Server\Data\A105_A.mdf' , SIZE =...

Where can I see that the log growth...

GilaMonster (7/11/2011)

---

In full recovery index rebuilds are fully logged and require easily 1.2x the size of the index being rebuilt in log space.

If you can accept the minor risks associated,...

Rhox (7/4/2011)

---

I was searching for a good index optimalisation script.

That reorganised or rebuild the indexes (online) for the database.

I'm trying following script: Example Script to Rebuild / Reorganize Fragmented Indexes...

I was searching for a good index optimalisation script.

That reorganised or rebuild the indexes (online) for the database.

I'm trying following script: Example Script to Rebuild / Reorganize Fragmented Indexes

I've...

That's solved already, it missed the default...

Ok, I will try that and reply here tomorrow.

Thanks for your help already!

At the same time, there's a:

- Backup transaction log

- Job History (syspolicy_purge_history)

That's all, if I'm not mistaken, this will not interupt the index rebuild?

This is the generated output:

http://users.telenet.be/rhox/DBA/RebuildIndexError.txt

Script: (T-SQL from the mainenance plan task)

USE [A105_P]

GO

ALTER INDEX [PK__NewBoSecurityCheck] ON [dbo].[_NewBoSecurityCheck] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON,...