How big, in terms of number of objects, is your database? I've had some real problems with intellisense with a few of mine. They are pretty large by this measurement...

I've run into various naming conventions that have caused problems over the years. One of my favorites was naming printers after the 7 Snow White dwarfs. It was a bit...

Great post and excellent timing. I was recently inspired to try out blogging and I definitely see the benefits of writing about my work. Not only am I creating a...

There isn't any automated transfer of data between the two databases.

I'm guessing it has something to do with the SAN destination of the backups. Today I was seeing errors like...

Thanks, that was useful. I did find my production differentials were not compressing. The production full as well as the dev backups were compressed. Still not sure what caused the...

No, I didn't turn off compression or make any other changes to the maintenance jobs. Is there any way to query a backup file to see if it used compression...

This is great! I won in 33 shots and the computer only had 3 shots left on my battleship before winning.

And another one.

Try here, http://dba.stackexchange.com/questions/tagged/business-intelligence

Though you might get downvoted for it not being a technical question

Tim

A former co-worker go so tired of trying to explain his job as a SAP Basis Admin (SAP DBA of sorts) that he came up with a fake story of...

Thanks everyone, I think I have this worked out. The SQL Agent was running under a service account that had permissions, but the engine wasn't. When I changed this on...

When I'm browsing to the backup destination I open an explorer window and type \\server\backup\...

When I ran net view \\server from a command prompt it returned (in a somewhat different...

Thanks for the replies and suggestions.

I tried changing it to UNC, but the backup still failed. The error messages are slightly different

to disk = 'Z:\backup\...' Operating system error 3(The system...

My largest database isn't big based on size, but I'd count it big based on number of objects. I'm pushing 120,000 tables with a minimum of 50,000 more in the...

Looks great Michael, I think my NVARCHAR(MAX) was a little overkill 😛

Tim

With the latest version, 2.3.7, the Health Report is failing for me with the following error.

Job Name: dba_HealthReport

String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The...