look for more information

1. size of msdb

2. recovery model of msdb

3. space available on the drive where you are taking backup...

4. Error message.

Once you have all in place, probably you...

Here is the solution similiar to what you want to write...

Declare @i as int

set @i = 0

While @i < 100000

Begin

insert into t values (@i)

Set @i = @i + 1

End

Books online...

Please check the TCP/IP Protocol is enabled

Also, check if sql server browser service is running

Hi,

I am very new to these things.. can any of you guys tell me how to identify ideal fragmentation level...and how do i identify it..

Thanks in advance..

Kumar