how did you update it?

its easier and more reliable to do the full database backup and restore yourself.

You would have to manually restore any log backups (with norecovery) taken beween that full backup...

all are logged, see http://msdn.microsoft.com/en-us/library/ms187382(v=sql.110).aspx

see what message is getting written to the errorlog to fill it and deal with whatever is causing it.

you can but its probably pointless. A performance problem with either database is unlikely and are any of the tables large enough to benefit from defragging (> 1000 pages)

do you have the SQL errorlog covering the last restart, that will tell you.

google sp_help_revlogin

may well have been Process:Private Bytes for the sqlservr instance

what version of SQL are you on? From 2008R2 compression is available with the native backups on all versions, you should only need 3rd party tools (sorry grant) if you...

this is something you would have to do when the server was quite. Ideally just after a restart and before any one logged on.

pinged the webmaster (before I knew the cause) and got a nice (and prompt) reply from a lady called Melanie Townsend. Looks like she was not aware of this particular...

Ed Wagner (9/23/2014)

---

george sibbald (9/23/2014)

---

what have I missed people? Not been around much for the last month, I come back and my post count has gone down by 128.

I kinda...

what have I missed people? Not been around much for the last month, I come back and my post count has gone down by 128.

I kinda miss them, so close...

check out SQLIO and SQLIOSIM

increasing the frequency of your log backups would help control the size of the log file unless you have a single transaction producing that much log.