Francisco Tapia
fhtapia at gmail.com
Wed Mar 18 10:20:58 CDT 2009
Yup, We deal with large databases on a regular basis here now, our largest is 1.5 tb and MS backups for this would be too big. So my schedules are, weekends kick off a full backup, and weekly I kick off a Differential backup, w/ transaction log backups kicking off whenever the logs hit about 60% of it's full size. I dig Red-Gate products, I was turned on to it by a college who was trying to move data and schema changes to another server, but had different schemas and data in each set. I checked out Sql Compare first about 3 years ago, and have been a customer ever since. Currently I also use the sql-prompt 3.0 product, though when I connect to the 1.5 terabyte databases I need to turn it off or the caching of all 64k tables will kill it's productivity. Several other databases that we have are shy of 800gb and have maybe about 24k tables and with those sql-prompt works just fine. I recently took a look at their Sql-Documentor and that is a great tool! -Francisco http://sqlthis.blogspot.com | Tsql and More... On Wed, Mar 18, 2009 at 1:40 AM, Arthur Fuller <fuller.artful at gmail.com>wrote: > OS is Vista with a service pack. Fortunately the recovery was easy, but it > did kick me in the butt and remind me that it's time to back up everything. > So once I got everything fixed up, I immediately fired up trusty Red Gate > SQL Backup and covered my ass. Speaking of which, do you use RG SQL Backup > or any other Red Gate stuff? SQL Backup is pretty amazing. It's more than > twice as fast as the built-in backup and even with minimal compression, its > file size is about 1/3 of the MS .bak files. > > A. > > On Wed, Mar 18, 2009 at 1:01 AM, Francisco Tapia <fhtapia at gmail.com> > wrote: > > > Ah... ok. still kind of curious when moving things around that these > write > > permissions got in the way. what was your OS? > > > > -Francisco > > http://sqlthis.blogspot.com | Tsql and More... > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >