The table in msdb is 6828MB.

Row count is 6385.

How would I work out if it's less than 1000 data pages?

Yes I do have heap tables on there but I just manually rebuilt an index for the MSDB database which was 99% fragmented.

This particular index in MSDB wasn't defragmented using...

Ok thanks.

Ok I will check that thanks.

I have also tried to restore by adding my .bak file onto a folder on the C drive locally.

When I try to do a restore...

Thanks.

The sp_trace_create specifies the stop date and time for the trace.

I guess if I set it a start time it should be ok to stop by itself......

If I was to use only one job will the trace still start and stop at specified times?

If using two jobs would I add my trace script in both jobs...

Ok will do, thanks.

Hi John,

I would have to choose it to run every second. So would it start and stop running every second?

I am running a trace and so would like it to...

Yes you would use that and I know that now, but when I asked this question I didn't know about Forced Service.

That's why I asked about failover from principal as...

Hi Perry,

No confusion.....Failover is performed at the principal server isn't it?

If the principal is down then how would failover take place?

That was my question in a nutshell.

Ok thanks I'll have a read.

In relation to this, what happens if one of the site's goes down (i.e - the principal site) and automatic failover is not being used (i.e. - there is no...

That's great, thanks for your replies.

Thanks for your replies, that's clarified it.