Data Recovery Reports > COPY_ONLY Option in SQL Server 2005 Backups

Systems Engineering and RDBMShttp://decipherinfosys.wordpress.com/2008/04/08/copy_only-option-in-sql-server-2005-backups/ [Systems Engineering and RDBMS] As you can see from above, this is a good addition to the backup set in SQL Server 2005 - especially for the production environments and even for the development environments at times when the CTO/CIP/VP comes asking for a fresh backup that can be used for a demo…using this option, such special one-off back-ups can be taken without effecting your back-up and restore routines.

Some related posts from Technorati and Google.

SQL Server Community Blogshttp://sqlblogcasts.com/blogs/sureshbarathan/archive/2008/04/17/know-the-transaction-log-part-2.aspx [SQL Server Community Blogs] KNOW THE TRANSACTION LOG -PART 2: Even though having high availability system configured with compatible RAID level of Disk Subsystems or fully redundant Storage Area Networks and for Servers that are clustered with failovers with Microsoft Cluster Services and SQL Server 2005 failover clusters, backups of mission-critical databases are so important for many reasons. Say suppose, a developer executed a DELETE FROM query forgetfully missed a WHERE clause in it against a production server, instead of Development Server where he supposed to execute!

Sterling Hamilton[Sterling Hamilton] Learning Replication: data is updated in the Publication database and is then copied to the Distribution database where it is held until it is propagated out to all the Subscriber databases. If you restore the Publication database back to an earlier point, transactions may exist in the Distribution database that have been backed out from the Publication database

STCFXhttp://www.stcfx.com/2008/04/16/wordpress-plugins-secure-and-protect/ [STCFX] WordPress Plugins : Secure and Protect: The plugin prevents WordPress from transmitting a list of active plugins, the blog url and WordPress version. Ideal for privacy-aware administrators of WordPress installation.

technet Edgehttp://edge.technet.com/Media/SQL-Server-2008-Database-Backup-Compression/ [technet Edge] SQL Server 2008 Database Backup Compression: Backup Encryption can be accomplished by enabling Transparent Data Encryption and then taking a backup. However when you enable encryption you lose the ability to compress the backup.  Unfortunately backup compression and Transparent Data Encryption are mutually exclusive.  It is not recommended to enable database backup compression when using Transparent Data Encryption.

SQL Server 2008 Application Compatibility Blog[SQL Server 2008 Application Compatibility Blog] Backup Compression: You can change the level of compression with some of these 3rd parties but SQL Server 2008 only has 1 level so I didn’t bother testing against different settings. I’d imagine the delta would not be significant percentage wise but if you have tens of Terabytes to deal with, even 5% can be a noteworthy difference.

techarena Community - Windows Server Helphttp://forums.techarena.in/showthread.php?t=952438 [techarena Community - Windows Server Help] Volume Shadow Copy Service causing system state backup issues?: other file system backups are OK. > > I ran Live update to ensure that the backup exec product is > completely up to date.I have also updated SQL Express SP 2 on the > backup server, dropped the Backup Exec database and reloaded from .

Zeros & Oneshttp://fawzi.wordpress.com/2008/04/11/why-should-you-move-to-system-center-data-protection-manager-2007/ [Zeros & Ones] Why should you move to System Center Data Protection Manager 2007?: DPM 2007 enables lossless recovery of Exchange, SQL, and SharePoint servers without the need for constant replication or synchronization by seamlessly integrating a point in time database restore with the existing application logs.

Michael Kimsal's webloghttp://michaelkimsal.com/blog/mysql-conference-first-session/ [Michael Kimsal's weblog] MySQL conference first session: MySQL workbench - I missed the demo of this, but it’s being reported here as massively upgraded. I hope so - it’s basically been broken for a long time (at least, my experiences under Linux were).

Hard Drive Data Recovery Software Tools[Hard Drive Data Recovery Software Tools] Mastering System Center Data Protection Manager 2007 (Mastering): intend up and streaming direct if your essential intend crashes,File Exceptions - Specify which files are never hardback up,Run some Data Backup duty on a limited days, dates or another continual basis,Create an literal double of a folder or a disk, to wage an phylogenesis of backed-up data,Incremental Backup copies every restricted files since the terminal backup

Andys Techie Bloghttp://parkesy.wordpress.com/2008/04/15/restore-a-list-or-library-in-wss-v2/ [Andys Techie Blog] Restore a list or library in WSS v2: Once your finished you tidy up after yourself by deleting the restored site using Sharepoint central administration and deleting the SQL database (the exact details for this are in the document i mentioned above)

Restore Point. sharepoint.http://blog.sharepoint-recovery.com/2008/04/14/sharepoint-data-outside-sql-is-this-real/ [Restore Point. sharepoint.] SharePoint Data Outside SQL - Is This Real?: The biggest issue from my perspective is the API does not have a built-in mechanism to guarantee consistent backups. A backup tool for such deployment would have to be smart enough and consider different parts of the same object are stored in different places (e.g., hierarchy and metadata in SQL and the file itself on external storage).

Ubuntulandhttp://ubuntuland.nireblog.com/post/2008/04/15/febe-firefox-environment-backup-extension-531-released [Ubuntuland] FEBE, Firefox Environment Backup Extension, 5.3.1 released: 27/02 - The Zumastor Linux storage project adds enterprise storage. 23/02 - Run Linux inside Windows.

Weathervanehttp://www.sunrisedancer.com/weathervane/?p=166 [Weathervane] Advice To New Bloggers: A plugin is code written in one or more PHP pages (with maybe some images and this-and-that) which you add to your installation in the plugins folder at your host site. It’s not all that hard””if you got your WordPress copied to your host yourself, then this is the same procedure.

Venu Anuganti Bloghttp://venublog.com/2008/04/14/notes-from-mysql-cluster/ [Venu Anuganti Blog] Notes from MySQL Cluster: Checkpoint to disk (frequency is configurable, default 2 secs); Rate is limited to avoid IO; Cluster will restore from last known Global Check Point (GCP); Any comitted transactions that are not part of checkpoint will be lost ...

Reflected tags on Technorati: Blog, , , , , ,