Hi Warwick ,

We have sql2k8 standard edition. The avg_fragmentation is more than 30%. All the objects are on the primary group only. How can we specify another group for building...

Thanks to All for your valuable replies

Thanks for your reply. The DB compatibility level was 80 as you said. Now to build the indexses shall i use alter index command or dbcc dbreindex for these databases...

Thanks Sachin,

I checked the logs it seems that process has been killed by another user but in job history the job status is executing. So if i restart the redgate...

Thanks Grant, I was waiting for the reply. So If i use dbcc shrikfile that will reclaim the space right.

Thanks for the reply. That means there wont be any differece if i create a1.mdf,a2.mdf this is bcoz I am migrating all the objects from primary to user created file...

Thanks alot for the response.

Ok thanks this solved my a part of question.

Now it will be helpful if u put light on master 16 connection or say db_xyz has 4 connection still it...

thanks for your respose. My concern is to move the database files to another disk drive now when i detach the database it says there are 3 active connection. So...

Hi Kevi,

Thanks for your reply. Can u plz brief @ SAN Mount points and their types.

Hi,

Thanks alot for your guide now got the idea.:-)

Hi,

Thanks for your reply. Can you plz. give the step by step guide.

Thanks for the reply:-)

Ok

Thanks for your response and guide.

It is being implemented through process of log shipping.

Can u plz. share some details on job agent and audit or the methods which u know to keep the server's in...