there's no pre-configured option in sql to do it.

Why do you want to do it? You would need these log backups to recover to a point in time previous to...

..oops, posts crossed 🙂

they put that disclaimer in all CU releases.

It is in that link you gave me, do a search on some part of that phrase I posted

If you logon to SQL using windows authentication SQL knows your individual windows account at that point. so SQL must be able to use windows based code to connect to...

Agree with Roy, don't apply CUs unless you are experiencing the problem it fixes.

As Microsoft themselves say on all CU readme's:

'Apply it only to systems that are experiencing these specific...

I must ask the wrong questions or the right questions badly 🙂

Anyway the answer is you cannot just move the bin and config directories, it would require a reinstall.

This is...

This account is only to run the SQL services.

You then add your personal ID as a login in SQL and grant it the permissions you wish it to have. If...

Its not a good idea to run SQL services under an account used for other purposes, such as a personal account. A domain admin account is also a security risk....

the restore job will still show as successful when it has no logs to restore, if the copy is not happening there will be none to restore, so the restore...

the trace flag. I certainly cannot see it would ever have more impact than profiler. to minimise profiler impact you should run it as a server side trace.

the trace flag...

thanks.

that quote refers to SQL2000, in 2005 SQL can use AWe memory dynamically.

so yes slide the bar over, but I would not go above 30GB, you risk starving the OS...

If you mean perfmon is showing SQL is using just 15GB then yes SQL won't use more memory unless it needs it.

check the settings you have for min and max...

presuming production dba role?

You want -

documentation, documentation and documentation, in particular info on server setups, installation and upgrade procedures, backup\restore strategies, and DR procedures. What he does not...

we use DNS alias's.

If there is any other procedures from the sharepoint end to handle the different server name I am not sure, my responsibility is for the databases only.

mirroring is at the database level, does not matter where the connections to the database come from, you just mirror the database, so NLB does not come into it.

Our other...