Thanks Ken,

There is one error repeating couple of times:

Msg 8116, Level 16, State 1, Line 1

Argument data type text is invalid for argument 1 of rtrim function.

Thanks again,

Brano

It was easier to say than to do :), to prepare this query to pull out empty fields. Something with ASCII 32, or similar. Any thoughts?

Brano

Ken Simmons (5/8/2009)

---

This script will find all the fields in the database that allow NULL values and then give you the number of rows in the table and the number...

Actually, you gave me an idea:

RAID 1 - System (2x146Gb) - Total available 146 GB

RAID 1 - (2x800Gb) - Total available 800 GB - both ldf and mdf.

My concern is...

Thank you for answer, but the only problem with that plan is that 400 is not enough for planed database. That's why I am trying to make some combination if...

Thank you, and yes: testing, testing, and testing - most important. And, in addition, of course, to ask experienced guys here, who already tested :-). Hyper-V doesn't have same level...

If you check http://www.sqlservercentral.com/Forums/Topic627569-146-1.aspx,

you have most of the answers needed regarding your question.

Regards,

Brano

Thank you, that solved issue. I overlooked that sharepoint installation created job CDW_SHAREPOINT for that database.

It is gone.

Regards,

Brano

Thank you, thank you, one step less :)!

I tried with actual dates:

SUM(CASE WHEN "Transaction".Time BETWEEN '2009-01-10' and '2009-01-28' THEN TransactionEntry.Quantity ELSE 0 END) AS Sold1,

SUM(CASE WHEN "Transaction".Time BETWEEN '2008-12-17' and...

Diff backups do not give you point-in-time restores, they giving just to the time of backup. I have to learn that part, point-in-time tips and tricks, my next lesson :)....

Regarding issue:

Two databases with similar log problem, same output: Just tr log backup did not help. After couple log backups, than dbcc shrink command, log file(s) went to just...

Thank you Gail, it worked. And I read your article, it is great too. With backup transactional log couple couple times per day for last three days, log is reduced...

Thank you very much to all,

It is very insightful, even parts of discussion not 100% connected with my topic. I use every information to learn something, never know when you...

Thank you all, I will analyze all your posts (and article) before choosing solution.

Now it is time to go home :), till tomorrow!

Regards,

Brano

I am doing full backup, if I understand well, that means log file backup too?

The problem with this database is next: it is one of config database for SharePoint, so...