Dear Lutz,

Thanks for reply.

I've attached 3 jpg files to this post.

If you need script of those or any thing else just tell me.

🙁 no I don't have a clean back up.

And that report is the last report.

I have attached the file and also the output of @@version is:

Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c)...

🙁 I cant paste it all:(

how can i upload a file here?

Ok , i don't know how to upload text file here so i will paste it here:

Server: Msg 8906, Level 16, State 1, Line 1

Page (1:6836) in database ID 11...

WOW!

Really interesting;)

Nice job man;)

I think i should post a new topic for this error:(

Dear Gail,

Thanks for reply,

I have used that command and it returned about 3000 line of error code:

This is last lines.

Server: Msg 8948, Level 16, State 1, Line 1

Database error: Page...

It is not 20-30% for all.

my data base has 50 GB size and after compression in sql2008 , the backup file has 32GB.

and another DB has 20 GB - backup...

Wow, no body replied to you...

I had this problem and i used this solution:

my maintenance plan created a job with this step:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID blablabla -To "a.siroos" -Rpt "F:\DailyMajorDbs0.txt" -DelTxtRpt...

Wow, no body replied to you...

I had this problem and i used this solution:

my maintenance plan created a job with this step:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID blablabla -To "a.siroos" -Rpt "F:\DailyMajorDbs0.txt" -DelTxtRpt...

Dear Twinsoft SME,

Thanks for reply, yes I know it must grow.

The problem is I have a table with 16 MB of Data and 25 GB UNUSED SPACE.

Means each 1 Mega...

Dear EdVassie,

Thanks for reply, I will check it...

I already have sqlserver 2000 but i can check it in sqlserver 2005 , if it works , it will be great.

Thanks a...

Thanks dudes,

I will search e books for solution.

I understood that i need to study more;)

Have a nice time,

Ashkan

Dear Steve,

Thanks for reply. I have stopped shrinking my data base.

Know Please tell me what to do?

How can i understand why my database grows beyond 50MB...

Thanks,

Ashkan