It sounds like you are talking about a downgrade when you bring the databases into production.

The big question is really: Are you using any Enterprise-level features that...

If the problem is space then yes, the instance root should be off the system partition. With the servers we have, we store the root instance on c: and...

My train of thought is that if the recovery model were changed to SIMPLE, we could in effect "unlock" the table and delete it. It was only a calculated...

I experienced this problem when using using an AD account user as the account to run the Server Agent and forgot to set "Password does not Expire" in the account...

Can you restart the instance? If you can then it might by an idea. It sounds like the job has hung.

Another solution might be to perform a full...

Which databases failed the Transaction Log backup? You have offered no information on that point. I suspect you have tried to backup the transaction log in a system...

If you implement only daily backups then you are removing the possibility of performing point-in-time recoveries, something that in a production environment may result in data loss. With that...

I agree with that 100%. The owner should be a service account that can only access the resources it needs to fulfil its job.

For me personally, the use of...

Hi!

Our practice is to create a service user/group in AD and assign that as the database owner. I have never been a fan of using the 'sa' account for anything...

Unfortunately the guys from Dell are assuming everyone has exactly the same environment. Hopefully you have full control over your configuration and not them!

I would recommend not 2 x...

Hi Pedro,

thanks! Now I understand a bit more. I have seen this happen on highly transactional databases where .mdf and .ldf files and tempdb all share the same...

It is interesting because I have exactly the same problem as the original poster. I don't see a server state for all the machines to which i don't have...

1600 databases in a single instance???? Who designed that?

My advice here before buying ANY hardware would be to consider database consolidation. I am willing to bet that an...

OK, here is a gripe. It is clear that you don't really understand the basic concepts and yet you are administering (I am guessing) production database servers. You...

The most important thing here is not the amount a fragmentation but rather the ratio of fragmentation to pages. If you have 4 pages with 50% fragmentation I would...