Thanks everyone for the quick reply.

I am a DBA and need to have access to that server. Is there anyway to get access without a restart??

I found two servers showing the red stop icon i checked the services and its showing running for one server and stopped for the other one.

you sure you have two instance already?? Normally first installation will take the computer name and dont consider that as named instance.

you can move old data to another table on same db. Create some job to achieve the same.

You can use sp_dropsubscription and then add article when required and then refresh subscritpion to reenable.

Have to specified any size limit to the output file??

Welsh Corgi (10/11/2012)

I had then as DDL Admin but there is a...

If you want to DENY Create,Drop & Alter why cant you give a less privilege to that user??

What permission does that user have currently?? Is that user the owner of that table??

Thanks a lot Bhuvnesh.

What all programs you find running?? There are some process related to sql server needed for client connection and some other for applications like SSIS,SSRS,SSAS. You can stop the later...

Whats the schema name for those tables? is that different from the other??

I dont know the downtime you are taking about. You mean to say your mirror DB is using currently??

The data will catch up for sure.

He should better ask the application team.

AWE is for 32 bit system .AWE is not required and cannot be configured on 64-bit operating systems.