Activity overview
Latest activity by deweigend
We are experiencing this problem as well. Is the SQL Backup download version 3.2.0.5? The readme file only says 3.2.0 / comments
We are experiencing this problem as well. Is the SQL Backup download version 3.2.0.5? The readme file only says 3.2.0
This post is to follow-up on this thread and to close it out. What we decided to do was to remove the /3gb from the SQL Server. This SQL Server has 16 gig of RAM and we do have it configured to use AWE. According to Microsoft, servers with more than 16 gig of RAM don't need the /3gb switch and since we had 16 gig we decided that it was OK to go ahead and remove the switch. This action did reduce the over all amount of memory that SQL Server was using and that impacted the buffer cache mostly but the hit ratio did not go down so I think that we are ok. The Network Admins attempted to retrieve the sector size where we are storing the backups but they were unable to get that information with the equipment we are using. With the /3gb switch in place we were seeing any DB over 1 gig in size fail. So far the backups are running fine. We were previously using SQL LiteSpeed to backup our databases and we never had this problem. I would like to see this problem resolved in the next release of SQL Backup because it may not be an option to remove the /3gb switch with the next SQL Server that we deploy SQL Backup to. / comments
This post is to follow-up on this thread and to close it out. What we decided to do was to remove the /3gb from the SQL Server. This SQL Server has 16 gig of RAM and we do have it configured to u...
Insufficient system resources exist to complete the request
I am having a problem with backing up large databases to a network device. SQL Backup with fail with this error: "Insufficient system resources exist to complete the request". I searched through ...
It does seem that SQL Compare tries to decrypt each encrypted object, is there anyway to turn off this feature. All our QA, UA and production servers will have encrypted objects (SP's, views, UDF's, triggers). As it stands now, we will not be able to use SQL Compare against any of these servers. / comments
It does seem that SQL Compare tries to decrypt each encrypted object, is there anyway to turn off this feature. All our QA, UA and production servers will have encrypted objects (SP's, views, UDF's...
Compare problem with Encrypted Stored Procedures
We recently purchased a tool called SQL Shield from Activecrypt and installed it on one of our QA servers. Before encrypting each stored procedure, view, UDF, and trigger we were able to use SQL C...
We are using 3.2.0 according to control panel which agrees with what is printed in the backup logs. I take it that this is not the same as 3.2.0.5. I will look for this version on the website. / comments
We are using 3.2.0 according to control panel which agrees with what is printed in the backup logs. I take it that this is not the same as 3.2.0.5. I will look for this version on the website.
Database name with a space char in it
Hello,
I received a syntax error with this command when typing to backup a database that has an embedded space character in it. This is the only database that is named this way and this command ha...
Thank you for the tip. I was thinking along the same lines as you.
I think my best option is to embed the hour in the same of the file and use the INIT option for each backup run. This should give me a set of 10 log backup files that are reused from day to day (backing up every 2 hours from 4 am until 12 am).
Thank you for your help on this.
Donald Weigend / comments
Thank you for the tip. I was thinking along the same lines as you.
I think my best option is to embed the hour in the same of the file and use the INIT option for each backup run. This should give...
Thanks for the reply.
My log backup job runs every two hours from 4 am until 12 am. So with SQL Backup I will create a new file each time this job runs. I don't suppose there is an option to make SQL Backup add something to a backup file name so they will be unique? Ideally I would like to have a rotating set of files that will get reset with the 4 am log backup then I will not have to worry about deleting old log backups once I take a new full backup. Not being able to append to a single log backup file throughout the day is definitely a drawback to an otherwise very good product. Is this function being considered for future releases of SQL Backup, if not, how can I get it on the list.
Donald Weigend / comments
Thanks for the reply.
My log backup job runs every two hours from 4 am until 12 am. So with SQL Backup I will create a new file each time this job runs. I don't suppose there is an option to make...
Backing up Log Files
I am switching from SQL LiteSpeed to your product. With SQL Litespeed I was able to append to the Log backup file by passing an init switch to the backup stored procedure. I would like to do this ...