[Previous] Elcomsoft System Recovery Professional 2.0 Buy OEM...

 [Next] Backup and Restore Encrypted SQL Databases - Geiger...

Some related posts from Technorati and Google.

[MSSQLTips - Latest SQL Server Tips] Initialize SQL Server replication using a database backup: We need to be cautious when running the snapshot agent job in SQL Server replication when databases are very large, because of the overhead of exporting, transferring and importing the data into the subscriber. An alternative approach to initialize the subscriber database is to use a SQL Server database backup. 

[SQL Server Customer Advisory Team - SQL Server Best Practices] Initializing a Transactional Replication Subscriber from an: In this context, I use the term VLDB to mean a database that is typically multi-terabyte and requires specialized administration and management This is primarily because the standard transactional replication initialization process, which is typically restricted by either the network or storage I/O bandwidth, could take longer than the business service-level agreement (SLA) permits because of the time needed to initialize or recover the Subscriber. In contrast, initializing a Subscriber using an array-based snapshot utilizes the Virtual Device Interface (VDI) freeze and thaw mechanism, thereby minimizing recovery time.

[SQL Server Training & Consulting] SQL Server High Availability Questions | SQL Server Training ...: Question: what happens when the primary database is restored during replication / log shipping? Answer: Restoring the publisher during replication depends on when the backup was.

[MSSQLTips - Latest SQL Server Tips] Limit snapshot size when adding new article to SQL Server replication: The business has requested that I add a new article to the publication. I would like to initialize only the new article added to the publication, so that I could avoid taking a total snapshot of all existing articles in the publication.

[Tarun Kumar Jaiswal] What is Restore/Backup Doing?: 2008-01-23 09:00:06.08 Backup Database was restored: Database: dbPerf_MAIN, creation date(time): 2008/01/16(14:04:58), first LSN: 647:4889:66, last LSN: 647:4918:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {‘c:\temp\dbperf_main.bak’}). Informational message.

[SQL Server Customer Advisory Team - SQL Server Best Practices] SQL Server Replication: Providing High Availability using Database: Summary: This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. The document covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication.

[SqlSchool.gr Blog] The truth about WITH ENCRYPTION option « SqlSchool.gr Blog: Αυτό σημαίνει ότι όποιος χρήστης έχει δικαιώματα VIEW DEFINITION μπορεί να δει τον κώδικα μιας encrypted stored procedure κλπ, αρκεί να εκτελέσει μια άλλη sp που κάνει decrypt το περιεχόμενο της.

[Elawad Blog] Moving the OCS 2007 Databases to a new SQL 2005 Server ...: In this post I’ll go over the relatively easy process of moving the OCS databases from one SQL 2005 server to another using only SQL Management Studio.  Of course there are many options for how you perform backups and restores, but given the small size of the core OCS databases I find that it’s usually fastest to use the built in tools.  The entire process usually takes under 15 minutes.

[rightscale Blog] Microsoft .NET Stack Released | RightScale Blog: When I first proposed the SQL Server Database Manager last year to our development team with what ultimately would become our first SQL Server ServerTemplate, I met with mixed reactions.  EVERYONE thought it was a great idea and would be useful to users.  However, a lot of reservations too…doing something like what we have for MySQL with master/slave replication is no easy feat.  Adding in Microsoft complexity with Powershell as well as unexpected Windows behavior in the cloud, the solution seemed out of grasp. Some of the notable questions we asked ourselves:

[MSDN Blog Postings] Deep Dive on Initialize from Backup for Transactional Replication: Deep Dive on Initialize from Backup for Transactional Replication. Sateesh Yele Microsoft SQL Server Support .

[SQL Server Training & Consulting] Is it possible to restore a backup of a SQL Server 2008 database ...: Yesterday, this question was asked by one of the training participant, Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL. SQL Server High Availability Questions Question: How replication set up impacts to application performance ?

[SQLServerPedia] Backing Up and Restoring Replicated Databases | SQLServerPedia:  Typically when you restore a SQL Server database, replication settings are removed during the restore process.  This allows you to do a database recovery to a dev/test/DR environment and not have to worry about replication settings causing issues in a non replicated environment.  In many scenario’s however you may need to restore a replicated database and maintain these replication settings so that you can re-initialize replication after the restore.  The KEEP_REPLICATION option allows replication settings to be maintained after a database is recovered.  Syntax is below:

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