Comments
Sort by recent activity
The following services all use the same account:
SQL Server
SQL Server Agent
SQL Backup Agent
I turned on xp_cmdshell and ran the following:
exec xp_cmdshell 'dir C:\"Program Files"\"Red Gate"\"SQL Backup"\(LOCAL)'
And received the following implying that access does exist:
output
Volume in drive C has no label.
Volume Serial Number is A8AA-9A42
NULL
Directory of C:\Program Files\Red Gate\SQL Backup\(LOCAL)
NULL
04/04/2008 11:55 AM <DIR> .
04/04/2008 11:55 AM <DIR> ..
02/25/2008 01:47 PM 2,925,568 SQBCoreService.exe
02/25/2008 01:47 PM 2,383,360 SQLBackupC.exe
04/04/2008 11:55 AM 49,822 unins000.dat
04/04/2008 11:54 AM 1,541,898 unins000.exe
04/04/2008 11:55 AM <DIR> Win32
10/03/2007 08:14 AM 59,904 zlib1.dll
5 File(s) 6,960,552 bytes
3 Dir(s) 60,351,586,304 bytes free
NULL
(16 row(s) affected) / comments
The following services all use the same account:
SQL Server
SQL Server Agent
SQL Backup Agent
I turned on xp_cmdshell and ran the following:
exec xp_cmdshell 'dir C:\"Program Files"\"Red Gate"\"SQL...
Cannot run this from the command line either from a privileged account:
C:\Program Files\Red Gate\SQL Backup\(LOCAL)>SQLBackupC.exe -SQL "BACKUP DATABASE model TO DISK = [c:\model.sqb] WITH INIT"
Red Gate SQL Backup 5.3.0.178, (c) Red Gate Software Ltd 2004 - 2007
Serial number: 010-030-073748-86CC
Backing up model (full database) to:
c:\model.sqb
VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server
instance is running and that you have the SQL Server System Administrator server role; or try increasing the value of the VDITimeout
registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName]
SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3201: Cannot open backup device 'SQLBACKUP_023F1F83-10B3-464D-A860-F9839357A255'. Operating system error 0x80070005(Access
is denied.).
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 1073414144 4096 1710222 1728 2955264000
Reserve 7991296 4096 405823 359 145690624
Free 23859200 4096 429304 280 120205312
Private 1073414144 4096 2223738 1337 2973138944
Mapped 1060864 4096 97358 78 7593984
Image 24862720 4096 178901 672 120221696
Warning 300: Backup failed. Retry attempt: 1 / comments
Cannot run this from the command line either from a privileged account:
C:\Program Files\Red Gate\SQL Backup\(LOCAL)>SQLBackupC.exe -SQL "BACKUP DATABASE model TO DISK = [c:\model.sqb] WITH INIT"
R...
I get this sometimes, but not sure how i'm causing this to happen / comments
I get this sometimes, but not sure how i'm causing this to happen
One tool worked, the other failed.
So getting somewhere with Quest Toad.
Now what is the next step to get the converted backup to work? / comments
One tool worked, the other failed.
So getting somewhere with Quest Toad.
Now what is the next step to get the converted backup to work?
I used the blocksize specified by your previous post, so it would appear that it can handle 65536.
Now the potential difference I do see is that after conversion, I get multiple files (multiple threads used to get the backup) and that is what may not be liked by any of the tools.
I will test that using a single thread, but is there anyway for convert to create a single file? / comments
I used the blocksize specified by your previous post, so it would appear that it can handle 65536.
Now the potential difference I do see is that after conversion, I get multiple files (multiple thr...
Able to restore with converted.
So the latter appears in line. Both ApexSQL and Quest Toad claim to be MTF compliant.
Here is an example of our full backup:
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [master,model,msdb,db_maintenance]
TO DISK = ''NEW_LOCAL:\BACKUPS\<database>\<AUTO>.sqb''
WITH ERASEFILES_ATSTART = 7,
ERASEFILES_REMOTE = 95,
FILEOPTIONS = 4,
PASSWORD = ''<ENCRYPTEDPASSWORD></ENCRYPTEDPASSWORD>'',
DISKRETRYINTERVAL = 30,
DISKRETRYCOUNT = 10,
COMPRESSION = 3,
COPYTO = ''\\copy\DatabaseBackups\<database>\'',
INIT,
KEYSIZE = 256,
THREADCOUNT = 3,
VERIFY"'
Example of our log backup:
EXECUTE master..sqlbackup '-SQL "BACKUP LOG [model]
TO DISK = ''NEW_LOCAL:\BACKUPS\<database>\<AUTO>.sqb''
WITH ERASEFILES_ATSTART = 7,
ERASEFILES_REMOTE = 35,
FILEOPTIONS = 4,
PASSWORD = ''<ENCRYPTEDPASSWORD></ENCRYPTEDPASSWORD>'',
DISKRETRYINTERVAL = 30,
DISKRETRYCOUNT = 10,
COMPRESSION = 3,
COPYTO = ''\\copy\DatabaseBackups\<database>\'',
INIT,
KEYSIZE = 256,
THREADCOUNT = 3,
VERIFY"' / comments
Able to restore with converted.
So the latter appears in line. Both ApexSQL and Quest Toad claim to be MTF compliant.
Here is an example of our full backup:
EXECUTE master..sqlbackup '-SQL "BACKUP...
That wasn't the question.
Is there another way to convert these so that a log reader tool can be used on these files?
Appears that the files may be compliant on mtf, but not fully compliant? / comments
That wasn't the question.
Is there another way to convert these so that a log reader tool can be used on these files?
Appears that the files may be compliant on mtf, but not fully compliant?
You might want to replace the copy of SQBConverterGUI on the FTP site. That is the issue.
I went and used the one that installed with the ToolBelt and that one does work. / comments
You might want to replace the copy of SQBConverterGUI on the FTP site. That is the issue.
I went and used the one that installed with the ToolBelt and that one does work.
Downloaded SQBConverterGUI from red-gate ftp site, put it in a nice, little, cozy directory, double-click....wait...wait....nothing.
Tried running on w2k3 sp2. Event tried setting compatibility mode to xp for giggles.
Also, cannot upgrade to production on a whim. Change control will take a while to get a new version to production.
Got anything else? / comments
Downloaded SQBConverterGUI from red-gate ftp site, put it in a nice, little, cozy directory, double-click....wait...wait....nothing.
Tried running on w2k3 sp2. Event tried setting compatibility mo...