Gianluca Sartori (8/5/2011)

---

sp_readerrorlog can help you reading the SQL Server log.

More info here.

For what the Windows logs is concerned, you should probably narrow down the scope of the question. Which...

wow! Thanks for that. There's a lot going on in that query. il give it a good going over tomorrow in work. appreciate it. Thanks all!

thanks guys. lots of good areas to examine. you have given me the basis of a plan of action.

Id still like to know if there is a way...

great ideas there to start creation of a plan , thanks carlos.

I would like to know if anyone has expiremented with the issues caused by online index rebuilding and...

This is the tricky thing, you can have an idea that you can do a job, but if its something thats currently a little above your level, then you dont...

First day of consultancy over! Horray! Was not as bad as i thought.

I expected some hostility, and i did get some drole remarks from a manager on my cost, which...

FYI, a few points i have learned that are useful as they dont appear in any books ive read:

1. If you have 200 trn logs in your destination share, and...

I took a new backup and restored it to the secondry, and now my trn backups are restoring, so im guessing it was a screw up on my part, and...

To be completely sure i had processed all the backups I:

1. disabled the copy job. this ensured i had a finite known number of trn log backups to restore...

all instances on my own personal machine.

my machine has been part of many domains and VPN's in the last week though, bit of a domain slut.

i wonder if it could have been an issue with the fact that i connect to a few VPN's with my personal laptop. It could have been trying to validate...

Elliott Whitlow (7/3/2011)

---

I've seen cases where permissions changed but running processes didn't not recognize those changes. Did you have to grant the SQL login admin level access? Have...

Ì have tried this with two new accounts.

both have admin acces.

I have logged in with both accounts and can access the backup share, and all other shares.

When i run the...

didnt know i could convert word docs to kindle format. ive been converting them to pdf which is ok, but lacks the text sizing of the kindle format.

I will investigate...

Thanks guys, appreciate your advice and kind words. Don't know go people do this day in,day out. So much pressure. Hopefully won't be as bad as all that. Il close...