Thanks a lot gentlemen. I really appreciate each one of you for taking out time to answer my query.

I am now looking forward to start and infact have started on...

hi,

As a DBA I am involved with devising and implementing backup/restore plans, HA/DR solutions, migrating of servers, performance tuning etc.

hi,

maybe i did not make myself clear. I wanted to ask that is 70-533 (implementing and deploying azure ) the right career path to take

T

Thankyou so much for the code snippet.

But I have a problem, that I have EMPTY(NULL) columns.

because of this the columns in the email get shifted to the left.

Please help to...

actually this had all happened before I joined the organisation.

Previous DBA had removed the replication but left the distribution database at it is.

When I enquired about it, I was told...

I have got full permissions on the folder.

But i did not take the backup of the files before deleting them

I have the permissions.

but I did not take the copy of the files before deletion

I think I know what has happened.

Around 2 weeks back, we had an outage on this server. and it was decided that the storage on the E:\ drive needs to...

Nope cannot take it OFFLINE.

cannot do anything with distibution database.

All the ALTER commands against it are failing with the same error.

cannot even open the properties dialog box.

While trying to disable replication I still get the same error.

I cannot issue any command against the distribution database as I get the same error again and again.

can I try...

The E:\ is present. and I can access the mentioned folder.