Comments
Sort by recent activity
Your version will not work with Denali because as Aaron Bertrand says
DATABASEPROPERTY()
You should use DATABASEPROPERTYEX() or, better yet, get your database-related metadata from catalog views such as sys.databases. Chances are, DATABASEPROPERTYEX() will find its way out of the product at some point, too.
in this blog post http://sqlblog.com/blogs/aaron_bertrand ... g-now.aspx
Chris / comments
Your version will not work with Denali because as Aaron Bertrand says
DATABASEPROPERTY()
You should use DATABASEPROPERTYEX() or, better yet, get your database-related metadata from catalog views su...
Darren,
You can use the FILECOUNT = parameter to split the backup into multiple files. I don't know about any size cutoff method but if your current backup is say 5Gb then FILECOUNT = 3 will produce 3 1.7Gb outputs.
HTH
Chris / comments
Darren,
You can use the FILECOUNT = parameter to split the backup into multiple files. I don't know about any size cutoff method but if your current backup is say 5Gb then FILECOUNT = 3 will produc...
Pete,
I downloaded the zip file and it just includes a new SQBCoreService.exe and SQLBackupC.exe files. To implement this I would need to copy this over the current 6.5.1.9 and maybe the SQLBackupC.exe too?
Will this be included in v 7 when it becomes available?
Thanks
Chris / comments
Pete,
I downloaded the zip file and it just includes a new SQBCoreService.exe and SQLBackupC.exe files. To implement this I would need to copy this over the current 6.5.1.9 and maybe the SQLBackupC...
I have now tested this out and its works as advertised.
Thanks
Chris / comments
I have now tested this out and its works as advertised.
Thanks
Chris
Great.
I will try and test this out first.
Thanks
Chris / comments
Great.
I will try and test this out first.
Thanks
Chris
I have now copied the executable to a test server. In the GUI under Help/About it shows 6.5.1.9. Under Edit/Properties it shows SQL Backup version as 6.5.1.9 and Service Application Version as 6.5.2.9. In any job show log entry its 6.5.2.9. I guess from all of this I am now using 6.5.2.9 to take backups.
Chris / comments
I have now copied the executable to a test server. In the GUI under Help/About it shows 6.5.1.9. Under Edit/Properties it shows SQL Backup version as 6.5.1.9 and Service Application Version as 6.5....
Run this query in each instance as see what you return
With VASummary(Size,Reserved,Free) AS
(SELECT
Size = VaDump.Size,
Reserved = SUM(CASE(CONVERT(INT, VaDump.Base)^0)
WHEN 0 THEN 0 ELSE 1 END),
Free = SUM(CASE(CONVERT(INT, VaDump.Base)^0)
WHEN 0 THEN 1 ELSE 0 END)
FROM
(
SELECT CONVERT(VARBINARY, SUM(region_size_in_bytes))
AS Size, region_allocation_base_address AS Base
FROM sys.dm_os_virtual_address_dump
WHERE region_allocation_base_address <> 0x0
GROUP BY region_allocation_base_address
UNION
SELECT CONVERT(VARBINARY, region_size_in_bytes), region_allocation_base_address
FROM sys.dm_os_virtual_address_dump
WHERE region_allocation_base_address = 0x0
)
AS VaDump
GROUP BY Size)
SELECT SUM(CONVERT(BIGINT,Size)*Free)/1024 AS [VAS Total avail mem, KB] ,CAST(MAX(Size) AS BIGINT)/1024 AS [Max free size, KB]
FROM VASummary
WHERE Free <> 0
Chris / comments
Run this query in each instance as see what you return
With VASummary(Size,Reserved,Free) AS
(SELECT
Size = VaDump.Size,
Reserved = SUM(CASE(CONVERT(INT, VaDump.Base)^0)
WHEN 0 THEN 0 ELSE 1 END),...
The reason that I got you to run the query is that SQLBackup uses VAS memory. In SQL2005 it is set to 256Mb by default. In this memory all CLR and Linked Servers run as well as SQLBackup. If you run short of VAS memory SQLBackup will throw the 1010 error.
Chris / comments
The reason that I got you to run the query is that SQLBackup uses VAS memory. In SQL2005 it is set to 256Mb by default. In this memory all CLR and Linked Servers run as well as SQLBackup. If you ru...
SJ,
You mentioned that you added a new instance to an existing server. What version and Edition(s) are you running of SQL and how much memory are you giving to each instance?
The 1010 error can be associated with lack of VAS memory situations.
Chris / comments
SJ,
You mentioned that you added a new instance to an existing server. What version and Edition(s) are you running of SQL and how much memory are you giving to each instance?
The 1010 error can be ...
Petey,
I was able to create the bugreport.txt file on that server when no SQLBackup jobs were running.
Chris / comments
Petey,
I was able to create the bugreport.txt file on that server when no SQLBackup jobs were running.
Chris