Activity overview
Latest activity by tleblanc
It was the account for the application pool that finally did the trick. / comments
It was the account for the application pool that finally did the trick.
SQL Query Fragments
I'm getting a deadlock and the SQL fragment that is displayed is truly that--a fragment. Is there any way to see the whole query?
Update to 4.0 Unable to detect Base Monitor
The credentials supplied to the package were not recognized
This is the error I get when trying to connect to the base monitor. The monitor and the web server are on the same machine and it wa...
Was the cure enabling ASP.NET Impersonation?
I did so and now I get a new error (new/different is always progress)
•/SqlMonitor/Configuration/Base-Monitor/AjaxSetConfiguration: 200 OK
SyntaxError: Invalid character / comments
Was the cure enabling ASP.NET Impersonation?
I did so and now I get a new error (new/different is always progress)
•/SqlMonitor/Configuration/Base-Monitor/AjaxSetConfiguration: 200 OK
SyntaxError...
Did you ever receive a response? If so, can you tell us the solution? I'm in the same boat. / comments
Did you ever receive a response? If so, can you tell us the solution? I'm in the same boat.
I'm getting the same problem when I use the scroll wheel on my mouse.
The message in the "powered by {sa}" window reads, "Arithmetic operation resulted in an overflow"
I click the send error report button each time.
This happens each and every time with any server expanded (or not) and as soon as the first detent on the scroll wheel is encountered it crashes.
SQLBackup 7.2.0.286 on Win 7 64-bit / comments
I'm getting the same problem when I use the scroll wheel on my mouse.
The message in the "powered by {sa}" window reads, "Arithmetic operation resulted in an overflow"
I click the send error report...
While there may not be a true "scratch disk" there is the TempDB. It had outgrown its drive capacity on our server and was the ultimate cause of the not enough disk space error in this case.
I reset the SQL service (truncating the TempDB) and that allowed me to do the restore.
I subsequently changed the location of the TempDB to a drive with more room to grow. / comments
While there may not be a true "scratch disk" there is the TempDB. It had outgrown its drive capacity on our server and was the ultimate cause of the not enough disk space error in this case.
I rese...
Thanks Raj,
When you say
In this case you can execute a restore command with the 'replace' option.
are you referring to something placed in the resulting sqlbackup script? Because I'm already specifying that I want to overwrite the database in the Edit Restore Job wizard.
Regards,
Tom / comments
Thanks Raj,
When you say
In this case you can execute a restore command with the 'replace' option.
are you referring to something placed in the resulting sqlbackup script? Because I'm already sp...
How much free disk space is required?
Sorry for this really basic question :oops: but how much free disk space is required to decompress the backup and restore it over an existing database?
The error I'm getting:
10/18/2012 10:20:13 ...
I'm running into the same problem. in looking at the SQL activity monitor I see this query from my workstation just sitting and spinning: master..sqbdata 'SELECT * FROM backuphistory WHERE id > 0 OR id IN ( SELECT backup_id FROM restorehistory WHERE id > 0 AND restore_type=''V'')'
Aside from the problem, is there any way to view the job's history? / comments
I'm running into the same problem. in looking at the SQL activity monitor I see this query from my workstation just sitting and spinning:master..sqbdata 'SELECT * FROM backuphistory WHERE id > 0...