Hey there,

The ldf is likely to be much larger than the database mdf itself, because probably no log backups are being taken...it will have all transactions.

Normally the best practise before...

If by crashed, there was not a major system issue, and SQL is still runnable, then right click on my computer and go to "manage" then check your services.

If there...

On the primary, I overwrite previous log backups, with the current, and it has been working fine for about 3 years prior to this without fail.

No logs were moved, all...

Yeah, I managed to sort it out not long afterwards, can't remember off the top of my head what the cause/solution was, so I'll go take a look and I'll...

Did you check the share permissions for the destination folder you're dropping the excel sheets into?

It is most definitely an issue with the account you're using to run the job,...

OK, chances are you're trying to write to a share then, have you checked the permissions on the actual share, and that the designated account you're now using has permissions...

So the DTS package is set up to run reports on another server?

I'm assuming it's set up as a linked server?

Does the account you replaced the original one with have...

Okay thank you 🙂

GilaMonster (12/8/2009)

They will. Shrink, with the default options can completely reverse an index, ie increase fragmentation up to almost 100%

Why do you...

Okay, there is no significant difference in the backup times, and there is plenty of diskspace available to handle the extra 200+GB, so it is not a major issue to...

There's no real way I can think of to do it with NO downtime, but it's quite easy to manage with minimal downtime.

You're going to have to take the database...

Thanks for all the replies guys!

Looks like I'll have to redesign some of the queries and put together some test results to see if they can be applied to the...

If the issue is server-wide as you suggest though, then you'll have to narrow it down to slow running queries to see if it is infact, an indexing issue, or...

Doing a reindex, is particularly important if you have done any bulk inserts or there have been any big changes to the data in the DB.

It is basically containing a...

If you can configure your trace with the necessary output data, then I would advise using something like "cleartrace" which will collate the results and you can filter by host/user/CPU...