[Previous] BlackBerry Service Solution: Backup Database BES Server...

 [Next] DYONYX Chooses Data Foundry for Disaster Recovery Strategy - W...

Some related posts from Technorati and Google.

[Brent Ozar - SQL Server DBA] Why Dedupe is a Bad Idea for SQL Server Backups | Brent Ozar - SQL ...: Dedupe appliances basically sit between a server and storage, and compress the storage.  Sometimes they do it by identifying duplicate files, and sometimes they do it by identifying duplicate blocks inside files.  It isn’t like traditional compression because the process is totally transparent to anything that stores files on a deduped file share – you can save an Excel file to one of these things without knowing anything about dedupe or installing any special drivers.  In theory, this makes dedupe great because it works with everything.

[Realtime Nexus: IT eBook alerts] Solidifying Your Backup and Recovery Strategy for SQL Server ...: You can perform a manual backup of the Analysis Services database by right-clicking it in SQL Server Management Studio and selecting Backup from the context menu. A dialog box will appear allowing you to select the location of the backup file and to pick from the following options:

[WORKERS OF THE WORLD, UNITED!] Script utk Backup Otomatis Database Postgresql « WORKERS OF THE ...: Artikel ini akan memandu kamu di dalam membuat script untuk backup otomatis database server kita secara harian, mingguan, bulanan, terkompresi dan ter-rotasi. Copylah isi script ini ke dalam sebuah file baru, misalkan autopgsqlbakup.sh , dan chmod 755 file tersebut. Letakkan di dalam direktori: ..... Monday.sql.gz'. Backup Information for /home/fajar/sore/daily/contohdatabase/contohdatabase_2006-03-13_15h17m.Monday.sql. compressed uncompressed ratio uncompressed_name ...

[Successful Software] How good are your backups? « Successful Software: Further more I nightly harvest sql files for all my websites and that goes into the gpg’ed files as well. I use ruby mechanize to login and export via phpmyadmin, since some of the websites are on cheep webhosts where there are no other interface for this.

[SQL Server Customer Advisory Team - SQL Server Best Practices] Tuning the Performance of Backup Compression in SQL Server 2008 ...: The size of the compressed backup is smaller than that of the uncompressed backup, which results not only in space savings, but also in fewer overall I/O operations during backup and restore operations. The amount of space you save depends upon the data in the database, and a few other factors, such as whether the tables and indexes in the database are compressed, and whether the data in the database is encrypted.

[In Recovery...] In Recovery... | SQL Server 2008: Backup Compression CPU Cost: I used System Monitor to capture %user-mode CPU time, plus backup/restore throughput for a compressed and .1) For the uncompressed backup the average CPU was 5% (the green line at the bottom), the run-time was 39.5s, and, of course, it took 322Mb to store the backup.

[Tibor Karaszi] Tibor Karaszi : Backup compression in SQL Server 2008: Time for RESTORE was 10.4 vs 6.3 seconds (with the destination database already existing). I expect the difference to be bigger on real installation and realistic db .

[Free Full Download] Disaster Protection 2009 - 8in1 - (AIO) | Free Full Download: To restore your backup copy archive, you only need double-click the archive, and the wizard will guides you to restore Compress your backup files Windows Mail Backup can compress your backup copy archive with high compress ratio Password protected archive You can choose a password to protect your backup archive. Please note, no body can open and restore the archive without the password, so please keep your password safe and write it down if you can not remember it Double click the backup file to restore You don’t need to choose the backup archive in Windows Mail Restore Wizard again, just simply double-click on the archive in Windows Explorer, Windows Mail Backup will fill the full path and filename for you Backup Windows Mail database, attachments, settings, accounts, identities settings, contacts, email rules Windows Mail Backup will backup all data from Windows Mail, these settings can be restored after you running the restore wizard Archive filename with time-stamp Use the filename generator, you can generate your filename with time stamp, using this function, you don’t need to choose the archive folder and enter the filename on each backup FTP uploader You can upload your archive file onto a FTP server automatically CD/DVD burner You can burn the archive file to a writable CD/DVD device Archive size larger than 4GB Windows Mail Backup supports more than 4GB file storage Scheduler You can schedule your backup process and don’t need to start the backup process by your self

[SQL Server Customer Advisory Team - SQL Server Best Practices] Tuning Backup Compression Part 2 - Technical Notes: Tuning this parameter is likely unnecessary in hardware configurations using dedicated storage, and it may be necessary only if it is determined that the backup operations impact concurrent workloads. As recommended in Part 1 of the article, tuning MAXTRANSFERSIZE should be considered as a secondary tuning option, and it should only to be utilized when it is determined to be beneficial through testing.

[Brent Ozar - SQL Server DBA] Quad Cores Help Compress SQL Server Backups | Brent Ozar - SQL ...: Most of the time, quad-core CPU’s aren’t really a compelling feature for database administrators because SQL Server experiences more I/O backups than CPU power backups. We pour money into drives, HBA’s, and preach the benefits of raid 10, but we don’t spend a lot of time comparing processors in great detail.

[Top 10 Lists] Top 10 SQL Server 2008 Features for the Database Administrator ...: Having the ability to centralize the management and administration of a number of SQL Server instances from a single source can allow the DBA to save significant time and effort. The Central Management Servers implementation, which is accessed via the Registered Servers component in SQL Server Management Studio, allows the DBA to perform a number of administrative tasks on SQL Servers within the environment, from a single management console.

[Blog - Stack Overflow] Our Backup Strategy - Inexpensive NAS - Blog - Stack Overflow: Every day, it’s defragging everything over 10% fragmented, and rebuild everything over 30% fragmented. StackOverflow is pretty heavily indexed in order to make some of the more challenging queries return fast, and it definitely pays off in terms of query runtimes.

Reflected tags on Technorati: Blog, Sql Server Restore Database, Data Recovery Reports