Hi,

Not sure why ur server is down and am not sure as to whether you will be able to backup your data or not.

I can suggest that you copy the...

Yes, the backup process will record all the committed transactions in the full backup till 10:29.

Only the uncommitted will not be written to the backup.

regards,

umesh

Hi,

Let me know if you are able to connect using query analyser.

Also try to connect using the Ip of the machine instead of the name.

Check if the server is registered...

I suppose you can get the version number of the client tools by using the help --> about options from the menu of the client tool.

As for the patching, I...

Hi,

I think is information is insufficient for a reply.

Can you tell me whether you are trying to connect from a client machine or are u working on the server itself.

Was...

Good One Cain.

Mine was so stupid..

Hi,

I think you might have write a SP for that.

I can suggest a very crude way and it can work provided there are not many tables.

save the result of the...

Yea Deb,

I thought that was your problem. Both EM and QA were open at the same time.

Were you able to solve the dbcc issue?

Umesh

Hi,

I have had  DBCC errors but mostly were consistency errors.

I always try the Repair_fast first, then the repair_rebuild and then the REPAIR_ALLOW_DATA_LOSS.

Obviously the take backups prior to the execution of...

Hi,

I think these are fairly easy questions. In India even a student in the final year of engineering would be able to answer most of them.

I would expect most DBA's to...

Hi,

You can also use Tools --> Option --> Advance tab to set the connection settings. This setting will apply for all the servers registered in your Enterprise Manager.

You can set...