Activity overview
Latest activity by Mindflux
Formatting cursor logic indents weird
Here's a kill user script I found on the web a long time ago, I've flattened it out to show what it looks like before SQL Prompt formatDECLARE @strSQL VARCHAR(255)
--PRINT 'Killing Users'
...
3.4.1.73 no longer finds GIT?
I just installed the whole SQL Dev toolbelt, and was well on my way to using GIT as my repo..
I did my initial commit and that worked, then I got a message that 3.4.1.73 was available for SQL Sour...
Warning 151:MAILTO Error Failed to send mail. (Read Timeout)
I just started getting this warning in the SQLBackup activity history. I still get my backup emails per usual, so obviously "Failed to send mail" isn't accurate.
This just cropped up out of NOWHERE...
Ok doke. I can run the script out of a Query Analyzer logged in with windows authentication.
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [XYZ] TO DISK = ''C:\SQLBACKUP\DAILY\DB\<AUTO>.sqb'' WITH COMPRESSION = 1, ERASEFILES_ATSTART = 5, INIT, MAILTO = ''me@domain.com'', THREADCOUNT = 4, VERIFY"'
That works great, so somewhere.. the script is executing under the wrong permissions from SQLBackupC. / comments
Ok doke. I can run the script out of a Query Analyzer logged in with windows authentication.
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [XYZ] TO DISK = ''C:\SQLBACKUP\DAILY\DB\<AUTO>.sqb'' W...
I tried using the stored procedures listed here: http://help.red-gate.com/help/SQLBackup ... Backup.htm
to change the authentication, with no luck. I then removed the ServerCore install and re-installed it entering my domain credentials. However the backups still fire off as NT Authority\NETWORK SERVICE
The SQL Backup Agent is running under Domain\Administrator as well. / comments
I tried using the stored procedures listed here:http://help.red-gate.com/help/SQLBackup ... Backup.htm
to change the authentication, with no luck. I then removed the ServerCore install and re-inst...
Cannot backup server 2008?
10/2/2009 12:09:45 PM: Backing up master (full database) to:
10/2/2009 12:09:45 PM: C:\SQLBACKUP\DAILY\DB\FULL_(local)_master_20091002_120945.sqb
10/2/2009 12:09:45 PM: Error 880: BACKUP DATABASE...
SQL Backup 5.4 Component not loading SQL Server 2008/x64
FRY: Server Component Installation - Failed
===========================================
Copy SQBServerSetup.exe to server - Successful
This operation completed successfully.
Run setup on server - ...
Nevermind, I got it. [image] / comments
Nevermind, I got it.
Download for 5.4?
I cannot run my 5.4 installation anymore, I get this error:SQLBackup v5
Could not load type 'DevExpress.Utils..
ۆah*1y'Ll"_#pnF
gdnot@mgI8x5"l
=o' from assembly 'DevExpress.Utils.v7.2, Versi...
petey wrote:
Yes.
Perfect. This morning's backup went flawless and all the older data has been erased. / comments
petey wrote:
Yes.
Perfect. This morning's backup went flawless and all the older data has been erased.