But our data file size of the whole database is already 10 gb.

quote: By table = 4GB, you mean the clustered index is 4GB in size?

If I go...

Thanks a lot

Thanks,

I found in the error message, when reindexing, the task failed at one of the biggest table we have.

The table is 4 gb. and index is 0.6 gb.

It seems this...

GilaMonster (10/31/2011)

---

Both.

100% the size of the index + log header...

Thanks, so in this approach of storing constant in the table, how can we use it in sproc,

To select the value from the table? Or use a function?

Yes, we ended up to create a simple scalar function to return the value.

And what is the const table?

Thanks, Yes, I undstand that,

But at first when I do that, I reset the columns of the flat data source, and it should resync the columns too, the point I...

SQLRNNR (11/3/2011)

---

It sounds like the metadata just needed updated. By chance were the two columns similar in name? Or did you remove one, then add it back and...

Thanks.

I will do an estimate of the reports and find out.

And also is there a way I can find out on an existing server, the drives are physical drive...

Where are those directories?

We install default instance,

I thought...

Thanks all.

First, I see the script is so long, I will have to study it a little bit later before I use it .

Second, I checked in the maintenance plan...

Thank you,

So now our data file currently allocated space is 10 gb, availble free space of 35%, backup file is 6.5 gb.

If it needs 120%, does it mean at least...

When you say it's 100-120 % of original objects, you mean use the space in data file or log file.

The issue we had before is transaction log full during reindex....

Perry Whittle (10/31/2011)

---

extract any reports, etc from the 2005 instance using Reporting services scripter tool(unless you have backups, which you do have dont you 😉 )

uninstall the sql server 2005...

-- Yes, the data loaded fine, but the next step in pacakge is to add constraints, and it...