Posts
Sort by recent activity
Rules for "system named constraint and index names"
Having the "Ignore system named constraint and index names" option enabled, it doesn't seem to be working all the time.It failed to identify [DF__ABCD__EFGH__3C02494A] as a system named constraint....
Using RG Source Control when deploying multiple copies with slight differences (IDENTITY)
So, I have a database schema. The code (procs and functions) are all identical. No problem there.The tables all have identical columns and indexes. But, they have different identity column initi...
Load-based multiple restore errors?
Hi!
I'm currently running 7.4.0.186, and I have a very annoying issue.
Every week I have a series of six DB backups that need to be restored to the same reporting/snapshot machine. All the backup ...
Auto adding WITH for table hints
I've been looking for a solution to help me migrate from an SQL 2000 database to something to run in SQL 2012. One of the key pain points is that the WITH keyword on table hints is now required.
I...
File browser unable to access local resource
I've got around a dozen servers running SQL Backup. We are upgrading one and I've got everything installed.
The backup agent is running as Administrator, and it's still in TRIAL mode, as I haven't...
SQB2MTFGUI fails on multi-threaded backups?
While I've never had a completed backup be bad, I suppose it might have been in this case, however...
I backed up a 17GB database, using compression 1 and two threads. When converting it to an MTF...
Failing on "not enough space" when plenty is available
Ok, so it might not be a flaky router.
I've had three backups fail to a remote share. In all three cases, the first error was from "backupmedium::reportioerror" claiming that there was not enough ...
SBCCoreServices.exe seems busy. Why?
Sorry about the continued posts. New, stupid, and uninformed customer, I guess.
Last night, two of my backups failed. I think I have a flakey switch, and the two backups failed because the share ...
Suppress backup file checking in restore wizard
I'm not sure that this is what is happening, but...
When I try to restore an 80GB backup file (that's 80GB after compressed), the GUI goes to "Checking backup files" or something for ... well.. I d...
Completed Backup stuck in "In Progress" queue
In testing a new backup, I was backing up all databases on an SQL server. The final database (msdb) is still stuck in the "In Progress" queue, even though the backup did complete successfully, as ...