Comments
Sort by recent activity
I resolved the last issue by deleting the repository and installing the latest update. I deleted the database and had it start fresh.
It worked since the 17th, but now it is back.
I am trying to figure out what is going on.
Right now the query running for 40 minutes is:
<?query --
DELETE [data].[Cluster_Keys]
FROM @Chunk c
INNER JOIN [data].[Cluster_Keys] d WITH (ROWLOCK) ON c.[Id] = d.[Id]
-- FORCE ORDER: The order above is carefully chosen, and this prevents pathological orders.
-- LOOP JOIN: Profiling shows that this tends to improve performance, as long as the number of rows to be deleted is small
-- compared to the number of rows in the table, by encouraging index seeks.
OPTION (FORCE ORDER, LOOP JOIN, MAXDOP 1)
--?> / comments
I resolved the last issue by deleting the repository and installing the latest update. I deleted the database and had it start fresh.
It worked since the 17th, but now it is back.
I am trying to fi...
you could script it...
i am using dynamic sql to restore 54 databases in a row. I am restoring to another computer and instance, so it is a little more than what you would typically use.
it is pretty easy..
help instructions: EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [pubs] FROM DISK = ''C:\Backups\pubs_01.sqb'' WITH REPLACE" '
my way:
set @SQL = ' EXECUTE master..sqlbackup ''-SQL "RESTORE DATABASE ' + @sitename +
' FROM DISK = ''''' + @backupfilepath + ''''' WITH MOVE DATAFILES TO ''''' + @dbdirectory + ''''' ,
MOVE LOGFILES TO ''''' + @tlogdirectory +''''' , REPLACE " '' '
exec sp_executesql @sql
/ comments
you could script it...
i am using dynamic sql to restore 54 databases in a row. I am restoring to another computer and instance, so it is a little more than what you would typically use.
it is pret...
i hate to say it.. but ti works...
something must be happening in chrome... [image] .. so depressing... IE is nice and snappy compaired.. i have not had ANY of the wait time that hasbuilt up in chrome. / comments
i hate to say it.. but ti works...
something must be happening in chrome... .. so depressing... IE is nice and snappy compaired.. i have not had ANY of the wait time that hasbuilt up in chrome.
i can consistently recreate the issue. If you would like to do a remote or something to see if you can track something down, i would be willing to be a test bunny.
It really creates a wait when opening up alerts. / comments
i can consistently recreate the issue. If you would like to do a remote or something to see if you can track something down, i would be willing to be a test bunny.
It really creates a wait when ope...
i will test it with IE to see if i have the same results..
i also have been using chrome... i hate using IE.. this is the 3rd application in my company that "FORCES" me to use IE.. grrr
although the commercial song for IE is catchy... lol / comments
i will test it with IE to see if i have the same results..
i also have been using chrome... i hate using IE.. this is the 3rd application in my company that "FORCES" me to use IE.. grrr
although th...
well it is just me.... so i don't see users being an issue.
I was doing some testing.. it seems that if I remote into the monitor server and open a browser to localhost... it is WAY WAY faster...
Everything else seems to run ok... just the alerts take FOREVER.. / comments
well it is just me.... so i don't see users being an issue.
I was doing some testing.. it seems that if I remote into the monitor server and open a browser to localhost... it is WAY WAY faster...
E...
thanks for the link.. i figured it out.
I needed more single quotes... a LOT more.... and then it worked! [image] / comments
thanks for the link.. i figured it out.
I needed more single quotes... a LOT more.... and then it worked!
I am so sorry. I was waiting for a response and never actually read it all. Let me try to answer all the questions.
Do any error messages appear when the problem occurs?
-- yes.. It says: error 1: arithmetic operation resulted in an overflow
error 2: Invoke or beginInvoke cannot be called on a control unit until the window handle has been created
error 3: index was out of range. must be non-negative and less than teh size of the collection parameter name: index
----i wonder if this has to do with my mouse scrolling 3 at a time per move
Are there any entries in the Event Viewer logs that correspond to the reported problem?
Fault bucket , type 0
Event Name: CLR20r3
Response: Not available
Cab Id: 0
Problem signature:
P1: redgate.sqlbackup.ui.exe
P2: 7.2.1.4
P3: 505332dc
P4: RedGate.SQLBackup.UI
P5: 7.2.1.4
P6: 505332dc
P7: 1f82
P8: 3b
P9: †.+
P10:
Attached files:
These files may be available here:
C:\Users\jes01\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_redgate.sqlbacku_4358ec24c7ba56f39fc93f5882bb1e148ca37fbc_2b964df8
Analysis symbol:
Rechecking for solution: 0
Report Id: 5f0ce607-1a1f-11e2-b3e5-f0def1db3bce
Report Status: 0
How many SQL Instances are there listed down the left hand side of the SQL Backup GUI timeline?
3 groups - 15 instances
What exact version of SQL Backup are you using?
7.2.1.4
Version of Windows the SQL Backup GUI is installed upon?
7 64bit
Does the reported problem occur on this single machine or do you encounter it on two or more machines?
i only have one machine with it installed. I can find another one to test it on. / comments
I am so sorry. I was waiting for a response and never actually read it all. Let me try to answer all the questions.
Do any error messages appear when the problem occurs?
-- yes.. It says: error 1: ...