I know shrinking is not so good idea. I have no option except shrinking to gain space and that too is on dev server.

Now what's happening is shrink opertaion is...

If its not shrunk by 500 mb, whats the surity it would do for 50 gb. Also, i tried doing rebuilding indexes, but not fruitful.

May be:-) I tried later,it completed but no space gained now. Size is as it was.

Actually its a dev db that needs to be refreshed from prod but space issue is there in dev. I wnat to shrink some other db's datafile in dev which...

Its just not completing. No blockings, no user connection even.

Yes and in multiple of 8, but no luck.

Shrink database didn't work. I have tried it before. Also, increasing the size and then shrinking is not sufficing the requirement too.

Vivek

:-)No option working. Have tried everything.

Tried executing the script but hard luck.

From scratch.:-)

See SQL Server Agent Fixed Database Roles in msdb database.

SQLAgentUserRole

SQLAgentReaderRole

SQLAgentOperatorRole

You will get all details in the link below

http://msdn.microsoft.com/en-us/library/ms188283.aspx

Pls clarify are there 6000 users existing in ur db or u r taliking abt connections.

And, if you want do make it read-write, you need to break the mirroring and as mirror database is in no recovery mode, you need to issue the following command...

Ya, it works.

No, I can't do that since it is Production Server.