Viewing 15 posts - 16 through 30 (of 39 total)
The third-party tool (Red-Gate's SQL Backup) was able to achieve basically 90% compression. This makes the solution theoretically possible, but still not desireable.
We are going to try additional options:
1. Less...
April 21, 2006 at 8:56 am
There are other backup products as well. Check out this comparison review which evaluates several leading products.
http://qa.sqlservercentral.com/columnists/wbrown/fourofakindbackupsoftwareshootout.asp
You can also detach the database, get it to the new server,...
March 31, 2006 at 9:26 am
I have seen instances where dbmail seems to send duplicate messages as well. I have not had time to investigate it. I don't even know if there are any patterns...
March 31, 2006 at 9:19 am
It will depend on what sort of data is being modified, I would imagine-- lots of text or a few tinyints.
It will also depend on how often you run transaction...
March 31, 2006 at 9:16 am
Our log from the DDL trigger showed that the ALTER DATABASE statements were issued before and after the rebuild, as intended. And the log file right after the rebuild was...
March 31, 2006 at 9:13 am
I believe as part of the interface when setting up log shipping, there is a threshold you can set which determines how much squawking it will do. You set the...
March 30, 2006 at 4:32 pm
Last night we implemented log shipping on one of our smaller databases. We set the recovery mode to FULL and then ran a snippet of T-SQL before and after the...
March 30, 2006 at 4:29 pm
This is an interesting post in this thread stating that minimally-logged acitivity, while taking up little space in the log, will still generate large log backups, which would seem to...
March 29, 2006 at 1:22 pm
I'm skeptical of that. Perhaps it will if switching between SIMPLE and FULL/BULK-LOGGED, but from what I've read of Microsoft's site, SQL Server is pretty good about switching between FULL...
March 29, 2006 at 1:16 pm
Does this mean that in a log shipping situation, minimally logged activity will still generate large transaction log backups to be shipped to the destination location?
March 29, 2006 at 1:10 pm
After reviewing some literature from MS, I was reminded that it should be available in some form for Standard, and it looks from the grid like it will have the...
March 29, 2006 at 9:23 am
You mention implementing database mirroring. However, that hasn't been blessed by Redmond for prime time, has it? Also, I'm not sure whether it will be available-- and if so to...
March 29, 2006 at 9:01 am
The Red-Gate product is similar but 1/3 (or less) the price. There was a cross-comparison review on SQL Server Central a while back and found that it's competitive with the...
March 29, 2006 at 8:57 am
Microsoft Books On-line only lists three index operations which are minimally logged-- CREATE INDEX, ALTER INDEX REBUILD, and DROP INDEX. It doesn't mention DBCC INDEXDEFRAG. I'm not positive what the...
March 29, 2006 at 8:40 am
We have Windows Standard Server 2003 x64 and SQL Server Standard 2005 x64, and it's able to use our full 8 GB of RAM in AWE mode. We have reason...
March 28, 2006 at 12:51 pm
Viewing 15 posts - 16 through 30 (of 39 total)