Posts
Sort by recent activity
How do I get a blocked index name for a deadlock?
Example:
Object blocked: Index/(Key) 72057618332712960
Process detail:
dbid: 8, object id: 72057618332712960, index id: (010086470766)
Both of these numbers are too long to be the object_id (INT) i...
Stored procedures over 32K always show as changed
Whenever one of my procedures gets really large and exceeds 32K, it always shows up as being different when I try to synchronize it between databases. In the past, I worked around this by splitting...
Does SQL Backup use tempdb?
I'm splitting my backup into two files for performance - each file goes to a different raid 0 drive array. I then copy these files onto my report server and restore them using two different drives....
Split backup - one thread for each file?
Right now I'm using THREADCOUNT = 2 to speed up my backup and restore. If I split the backup into two files instead of using THREADCOUNT (these options are mutually exclusive), will it automaticall...
Restoring a SQL Server 2005 database without the log
Every night I restore backups of my databases to a report server. I don't need the logs, so after each restore I detach the database and delete the log. When I reattach, SQL Server creates new log...
Error: Could not convert variant of type (Null) into type...
I am getting the following error in my log file for SQL Backup:
Error: Could not convert variant of type (Null) into type (Int64)
My backup job is failing with exitcode 500. Here's the relevant eve...
SQL Backup - Product Activation error
When I try to activate over the Internet:
"The activation request was not in the correct format. [The root element is missing.]"
When I try to activate by e-mail, the box that is supposed to contai...