I wouldn't go down this route on a production server, 'bulk-logged' can actually produce a larger transaction log depending upon what's being done and 'simple' recovery mode means that you...

Woo hoo, some response at last, and it gives me a couple of ideas straight off

Or someone else could do some?

exactly what the script I gave you in the PM does

Are you referencing files that are not on the shared storage, say d:? in order for the DTS to work all of the resources need to be available to both...

Hi there,

as per your PM i've sent the script that I use to do this, let me know how you get on

Mike

sounds very odd, are you running a time synchronisation app on the server at all?

good point, although the first one can be a little out of date if you dont use dbcc updateusage first.

If only everyone were so diligent on this sort of thing, it would save me hitting people (developers) over their heads trying to make them do it right.

You'd be amazed...

Nice to see you're properly qualifying your DB objects Remi

Have you checked that you've set SQL Agent Mail to use the same profile as SQL mail? Sometimes people forget that they're 2 different entities and only do one of...

I've never used DBArtisan but as for your question, when you do a backup it only backs up the actual data in the database, if you allocate 20GB to the...

Hi There,

I have two questions which will probably help answer your question.

1. Do you have a clustered index on the table you're looking at?

2. Is the table split across more...

Hi Sanjay, Can you elaborate a little on what you mean by data scripts please, are you refering to scripting the structure of the database or is it something else...

This approach sounds ok but will have the added side effect of introducing OS file fragmentation, which is something else that you'll have to worry about.

If it were me i'd...

Depending on how you do it, and index rebuild can require empty space in the DB equal in size to the largest table it contains.

You might also want to keep...