Did you try (local)?

Yes, the name of your machine. Otherwise when using a client tool to connect to a SQL Server instance on the current machine "(local)" will work.

I am a bit confused since you indicate your backups are being overwritten. As in - new backup overwrites old.

If you do know that you have a backup that...

Excellent article! And thanks for clearing up, once and for all, the issue over full backups/log chain. It was always my understanding that full backups break the the log...

I would like to add that once you have done the above (and those transaction log backups are critical to database health) you should think about getting a test instance...

Please consider the option that Gail presents as well.

Without knowing the details of your configuration it is hard to say for sure. I do know that in general, once a file is full, SQL can shift to a...

It will be interesting to see what results you get. I should think they would be consistent.

The LEN function won't give you trailing spaces. Try this instead:

declare @sqlStr varchar(max)

set @sqlStr = 'aa, '

print DATALENGTH(@sqlStr)

The SQLAgent job is dependent on the privileges of the SQL Server Agent service.

Reading between the lines, you might also be needing to assign the SQLAgentOperatorRole to those user accounts....

If you have SQLExpr32_x86 you are out of luck. Here are the three versions available for download:

SQLEXPR32_x86 only for 32-bit windows systems.

SQLEXPR_x86 for both 32-bit and 64-bit windows...

Divine Flame (9/17/2012)

Thanks for the feedback Paul. Many of us (including me until I didn’t...

If you are not already aware of it, a good read on the subject of ETL can be found in the "Stairway" section on this website. Look for "Stairway...

What other roles is this server involved in? Domain controller, file server?

Is SQL Server optimised on your Windows server?

Rather than put forth a new question I thought I would bump someones else s old post to the front of the line - a cosmopolitan SQL Server 2008 problem...