DPM team is driving the efforts to build a Centralized Console for Microsoft System Center Data Protection Manager for the next version whereby multiple DPM Servers can be centrally managed from a single location.
Currently, the feedback to the surveys that have been sent are predominantly from existing DPM Customers where more than 90% of respondents have less than 20 DPM Servers. The Centralized management feature needs to meet the needs of enterprise class customers (20+ DPM Servers on an average).
So if you have more than 20+ DPM Servers on an average , please contact me and I will let Microsoft contact you to directly to get your feedback
This is my Contact Information
Islam Gomaa
Islam@IslamGomaa
MVP DPM
in this article I will show you how DPM 2010 can backup
in the untrusted machine login as administrator , copy the RA folder from the DPM 2010 Server,
then install the agent manually.
in the command prompt , go to C:\program File\Microsoft Data Protection Manager\DPM\bin
run SetDPMServer.exe –dpmservername yourDPMServerName –isNonDomainServer –username DPMagent
then you will be prompted to enter the password for that username
note this procedure will create a username DPMagent as a local user on the protected machine,
in the DPM Server click on protection group then protect a client then select attach agents , then select a computer in a WorkGroup or untrusted domain , then click Next
in the selected Computer write the computer name and the username and password that you identify in the step in a above , then click ADD
in the summary click on attach
Thanks
Islam Gomaa
Islam @ IslamGomaa.com
The System Center Data Protection Manager (DPM) 2010 allows backup administrators to authorize SQL Server database owners to recover their databases without intervention from the backup administrator.
To do this, the DPM administrator must create and manage DPM roles. A DPM role allows backup administrators to control what an end-user can recover and which instances of SQL Server they can recover to.
in this article I will show you how to use SQL End User Recovery.
First of all you need to create a security group in AD , that Security Group will represent the set of SQL Server users, in this article it is Gomaalab\DBAJ
in the protection Group in the right hand side click on SQL end user recovery,
in welcome Window click Next
In the Specify Security groups , you need to name the Role, then you click on the add button to select the security Group from AD Gomaalab\DBAJ, then click Next
in the Specify Recovery Items , you need to specify the server name and the database name , if you want to allow all the database in that SQL server leave the Database Name field empty.then click Next
in the specify recovery targets , you have the option to allow users to recover to another database instance of not by checking the first check box
then you need to specify which server to be a recvery located , and also you have the option to restrict where they can restore the data on the server
then in the Summary windows click Next
in the end you will receive a confirmation message that the role has been created
Thanks
Islam Gomaa
Islam @ IslamGomaa.com
Microsoft System Center Data Protection Manager (DPM) 2010 allows you to protect client computers - desktops and laptops. Backup administrators can centrally configure data protection for the desktops and laptops in their environment. Additionally, administrators can give their end users the ability to define and manage their own backups. DPM 2010 enables end users to perform their own recoveries by leveraging the Previous Versions feature in Windows.
In this article I will show how to protect client using DPM2010
in the protection group tab , click on the left site on Create protection Group, that will open a window has two choices , backup servers or Backup Clients , in our case we are going to select Clients , then click Next
Note
If you want to add multiple computers, you can create a .txt file containing the computers you want to add. To add the computers, click Add Multiple Computers. You must enter each computer in the file on a new line. We recommend that you provide the fully qualified domain name (FQDN) of the target computers. For example, enter multiple computers in a .txt file as follows:
Comp1.abc.domaian.com
Comp2.abc.domain.com
Comp3.abc.domain.com
If DPM cannot find any of the computers that you specified in the .txt file or that you entered in the Text file location box, the failed set of computers is placed in a log file. Click the Failed to add machines link at the bottom of the page to open the log file.
in the Select Group Member window select the client that you wish in my case I would like to backup W7D.gomaalab.local
On the Specify Inclusions and Exclusions page, specify the folders to include or exclude for protection on the selected computers.
a. Type the folder names in the Folder column using variables such as %programfiles%, or you can use the exact folder name. Select Include or Exclude for each entry in the Rule column.
b. Select Allow users to specify protection members to give your end users the choice to add more folders on the computer that they want to back up. However, the files and folders you have explicitly excluded as an administrator cannot be selected by the end user.
c. Under File type exclusions specify the file types to exclude using their file extensions, and then click Next to continue.
in the select Data protection method, select the protection method that suite your need either short-term or long-term , then click Next
click next , and specify your short-term recovery goal
notice there is new option to specify after how long DPM will raise an alert if the Client will not be available for backup, in my case I configured for 18 days
On the Allocate Storage page, specify the size of data to be protected on the computer. I recommend that you co-locate multiple data sources to one DPM replica volume. Click Next to continue.
Note
I recommend that you co-locate your data if you have a large number of client computers. You will not be able to protect 750 or more client computers with one DPM server without co-locating your data. I recommend that you do not co-locate if you have less than ten client computers in a protection group.
in the summary window click create Group then close
Islam Gomaa
Islam @ IslamGomaa.com
Originally posted by Jason Buffington on http://blogs.technet.com/DPM
Data Protection Manager 2010 delivers unified data protection for Windows servers and clients, providing backup & recovery from Microsoft for Windows environments in a scalable, manageable and cost-effective way.
Overview
Data Protection Manager 2010 is part of the System Center family of management products from Microsoft. It delivers unified data protection for Windows servers such as SQL Server, Exchange, SharePoint, Virtualization and file servers -- as well as Windows desktops and laptops. DPM is designed as a best-of-breed backup & recovery solution for Windows environments from Microsoft. DPM provides the best protection and most supportable restore scenarios of your Windows environment from disk, tape and cloud. Windows customers of all sizes can rely on Microsoft to provide a scalable and manageable protection solution that is cost-effective, secure and reliable.
Feature Summary
- Protection for Windows clients, while they are online or offline, with easy-to-use wizards for establishing protection, retention and alert schedules. A single DPM server can protect over 1,000 Windows clients, while end users are able to restore their own data using Windows Explorer or Microsoft Office.
- Protection of Microsoft Virtualization platforms, including Hyper-V R2 Live Migration / Cluster Shared Volume (CSV) configurations. DPM can also restore single-file items from host-based VM backups.
- Enhanced Protection for SQL Server, scaling to over 2,000 databases per DPM server, and offering auto-protection of new databases per SQL instance. DBA’s can now restore their own databases, through a self-service restore utility for SQL Server.
- Enhanced Protection of Exchange Server, scaling to over 40TB of email and support for Exchange 2010 Database Availability Groups (DAG), as well as CCR/SCR in Exchange 2007.
- Enhanced Protection for SharePoint, without the requirement for a recovery farm with SharePoint 2010, and scaling up to 25TB farms with over 1M items. New content databases are now auto-protected without administrator interaction.
- DPM 2010 is truly enterprise-ready, scaling to over 100 servers with over 80TB per DPM server, and includes new Auto-grow, Auto-heal, Auto-protect features for a lights-out reliable protection and recovery solution.
System Requirements
- Supported Operating Systems: Windows Server 2008; Windows Server 2008 R2
.NET Framework 3.5 with Service Pack 1 (SP1)
Microsoft Visual C++ 2008 Redistributable Package
Windows PowerShell 2.0
DPM 2010 must be installed on a Windows Server 2008 or Windows Server 2008 R2 64-bit computer that is located in an Active Directory domain that is running in 2003-mode or better.
DPM 2010 can protect machines running 32-bit or 64-bit Windows Server 2003, 2003 R2, 2008 or 2008 R2, as well Windows XP, Windows Vista or Windows 7.
If you are protecting data over a wide area network (WAN), there is a minimum network bandwidth requirement of 512 kilobits per second (Kbps).
Try Microsoft System Center Data Protection Manager 2010 RTM free for 180 days
SC Data Protection Manager 2010 is Released to Manufacturing
Originally posted by Jason Buffington on http://blogs.technet.com/DPM
YES! It is finally here!
We are very excited to announce the RTM of DPM 2010.
You can read the official announcement at System Center Nexus, as well as the commentary from my blog.
DPM 2006 started our journey as ‘centralized backup of branch office files’ to disk. The most important goal was just getting the data out of the branches and not requiring tape drives in each remote location.
DPM 2007 continued by bringing our own tape solution in unison with our disk-to-disk protection, and adding supported ways to protect and recover key Microsoft applications such as SQL Server, Microsoft Exchange or SharePoint. We also delivered DPM 2 DPM 4 DR, as a method of replicating data from one DPM server to another, between datacenters.
DPM 2007 SP1 built upon that and added Hyper-V protection, as well as cloud-based protection using trusted partners like Iron Mountain.
Staying true to our vision of reinventing how Windows customers accomplish data protection by discarding some of the constraints that many legacy backup products deal with -- DPM delivers a single agent at the production workload to protect those assets to unified disk, tape and cloud repositories … from Microsoft for Windows.
DPM 2010 truly delivers unified data protection for Windows servers and clients, in a way that is wholly supportable for protection and recovery and across disk-, tape- and cloud-based media.
Some of the big enhancements include:
Protection of Windows Clients, using protection policies that are in effect while they are connected to the corporate network (or VPN/Direct Access) or disconnected by storing changes within the local hard drive.
Protection for Microsoft Virtualization, including Hyper-V R2 LiveMigration scenarios, recovering VMs to alternate hosts, and item-level recovery (single file) from a host-based backup.
New features for application servers, including SQL Server self-service restores, no more SharePoint recovery farm, support of Exchange 2010 DAG and auto-protection of new databases within SQL instances or SharePoint farms.
DPM 2010 really also takes the product as midmarket/large-company to enterprise-ready, with scale increases. A single DPM server can protect:
100 production servers
1,000 Windows clients
2,000 SQL databases
25TB SharePoint farms containing 1M items
40TB Exchange databases
We are really proud of DPM 2010 and believe that it surpasses all of the goals that you asked for in a Microsoft backup and recovery solution for Windows environments.
One thing I have to say about DPM , it is requires a lot of lot of disk space , if you are small medium business with large data storage to be backed up and want to implement DPM with less money of course , you need to consider to build your own DPM server.
Building your own DPM server doesn't mean getting all the components and build a server as these old days, this what you can do.
Dell offers the PowerEdge R200 with 8 GB ram and mirrored SAS drive with 10K RPM and QNAP offers the TS-809U-RP Turbo NAS that offers 14 TB on RAID 5. combining both Hardware you can build your own DPM appliance for less than 6000 $.
ISlam Gomaa
ISlam @ IslamGomaa.com
Today someone asked me does DPM can run a pre and Post backup jobs , my answer was NO because it is not straight forward from the GUI , but you can edit the ScriptingConfig.xml located in the protected server at install path\Microsoft Data Protection Manager\DPM\Scripting
When DPM runs a protection job, ScriptingConfig.xml on the protected computer is checked. If a pre-backup script is specified, DPM runs the script and then completes the job. If a post-backup script is specified, DPM completes the job and then runs the script.
when I Say Protection Job that include “replica creation, express full backup, synchronization, and consistency check.”
This is the raw file in the Protected Server:
<?xml version="1.0" encoding="utf-8"?> <ScriptConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/2003/dls/ScriptingConfig.xsd">
<DatasourceScriptConfig DataSourceName="Data source">
<PreBackupScript>”Path\Script Parameters” </PreBackupScript>
<PostBackupScript>"Path\Script Parameters” </PostBackupScript>
<TimeOut>30</TimeOut>
</DatasourceScriptConfig>
</ScriptConfiguration>
in this example I am deleting some files using the “PreBackup.cmd" batch file prior to the backup job
protection the F: drive.
example :
<?xml version="1.0" encoding="utf-8"?>
<ScriptConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="http://schemas.microsoft.com/2003/dls/ScriptingConfig.xsd">
<DatasourceScriptConfig DataSourceName="F:">
<PreBackupScript>
"F:\PreBackup.cmd"
</PreBackupScript>
<PreBackupCommandLine />
<PostBackupScript/>
<TimeOut>90</TimeOut>
</DatasourceScriptConfig>
</ScriptConfiguration>
For each data source, complete the DatasourceScriptConfig element as follows:
- For the DataSourceName attribute, enter the data source volume (for file data sources) or name (for all other data sources). The data source name for application data should be in the form of Instance\Database for SQL, Storage group name for Exchange, Logical Path\Component Name for Virtual Server, and SharePoint Farm\SQL Server Name\SQL Instance Name\SharePoint Config DB for Windows SharePoint Services.
- In the PreBackupScript tag, enter the path and script name.
- In the PreBackupCommandLine tag, enter command-line parameters to be passed to the scripts, separated by spaces.
- In the PostBackupScript tag, enter the path and script name.
- In the PostBackupCommandLine tag, enter command-line parameters to be passed to the scripts, separated by spaces.
- In the TimeOut tag, enter the amount of time in minutes that DPM should wait after invoking a script before timing out and marking the script as failed.
Note:
The backup job will not happen and will generates the following error in the following cases :
The configuration of the pre-backup script or the post-backup script XML for Volume F:\ is incorrect. (ID 30193 Details: Internal error code: 0x809909F4).
The execution of the pre-backup script for Volume F:\ returned an error. (ID 30189 Details: Internal error code: 0x809909F0) .
“now chubby will be happy again”
Thanks
ISlam @ IslamGomaa.com
Issue 1
The DPM 2007 error logs are flushed only when the DPM service starts or stops. If the DPM service crashes, the DPM error logs are not flushed. This behavior causes some errors to be missing from the error logs.
Note After you apply this hotfix rollup, the DPM error logs are flushed every five minutes. The error logs are also flushed when the DPM service stops or crashes.
Back to the top
Issue 2
The DPM SQL Server database causes Microsoft SQL Server exceptions that are not captured in DPM traces.
Back to the top
Issue 3
Express full backup may take several hours to run if the DPM server is configured to protect more than 100 SQL Server databases.
Back to the top
Issue 4
The DPM administrator console does not open when multiple backup jobs concurrently access a tape library.
Back to the top
Issue 5
When library sharing is enabled, the GlobalDbConnectionString registry value may point to the local computer and not to the global SQL Server installation after a post-DPM 2007 Service Pack 1 rollup is installed.
Back to the top
Issue 6
A job may freeze before it transfers data if the
DsRoleGetPrimaryDomainInformation function fails.
Back to the top
Issue 7
The DPM administrator console may not open if the Disconnect-DPMServer PowerShell cmdlet runs during a new tape backup job.
Back to the top
Issue 8
When DPM protects mirrored SQL Server databases that are clustered, the old volume bitmaps are not deleted. Therefore, the 128-volume bitmap limit may be exceeded.
This hotfix also includes all previously released rollups for Data Protection Manager 2007 Service Pack 1 (SP1):
961502 (http://support.microsoft.com/kb/961502/ ) A replica may be listed as inconsistent after you install System Center Data Protection Manager 2007 Service Pack 1 on a computer that is running an x64-based version of Windows Server 2003
963102 (http://support.microsoft.com/kb/963102/ ) Description of the hotfix rollup package for System Center Data Protection Manager 2007: February 16, 2009
968579 (http://support.microsoft.com/kb/968579/ ) Description of the hotfix rollup package for System Center Data Protection Manager 2007: April 14, 2009
970867 (http://support.microsoft.com/kb/970867/ ) Description of the hotfix rollup package for System Center Data Protection Manager 2007: June 4, 2009
970868 (http://support.microsoft.com/kb/970868/ ) A hotfix rollup package is available for System Center Data Protection Manager 2007: August 28, 2009
http://support.microsoft.com/kb/976542
DPM 2007 supports the use of iSCSI dynamic disks on Windows Server 2003, however, it isn't quite as straight forward as it is in Windows Server 2008.
In Windows Server 2008 you can add your iSCSI disks to the DPM server, make them dynamic and then add the disk into the DPM storage pool and you're done.
In Windows Server 2003 you follow the same steps but when rebooted the server, you'll notice that all your iSCSI disks are offline. The disks can be brought back online manually in disk management but this is not really a practical solution, the disks can also be brought online by opening the DPM console on the server, but again this solution is equally impractical.
To resolve the problem, change the start up type of the DPM service to Automatic. By doing this, your iSCSI dynamic disks will be brought online automatically after reboot.
One final point thought though, if you are deploying DPM please consider using Windows Server 2008 x64 as the base Operating System as not only will you have better performance but you'll also be fully prepared to upgrade to DPM 2010 next year. DPM 2010 will only be supported on Windows Server 2008 x64 so to avoid any upgrades, rebuilds and all the associated problems that cam with upgrading and rebuilding, use Server 2008 x64 if you can !
If you are a Small Medium Business looking for a non expensive backup storage solution, I recommend QNAP Appliance specially TS-809U-RP Turbo NAS it support up to 8 disk 2 TB each and provide Total Throughput 114.9 MB/sec on Read and 103.1 on Write.
Thanks for David Allen to work on that : http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/54729/Default.aspx
Islam Gomaa
Islam @ IslamGomaa.com
Just copy this Power shell Script and save the file under AutoClean.ps1 then run the script from DPM Management Shell
# Inactivates all active alerts
param (
[string[]]$dpmserverlist = @()
)
#region traps
trap [Exception] {
writelog $("TRAP: DPMinactivateAlert: $Error")
$Error >> $logfile
$log = Get-EventLog -List | Where-Object { $_.Log -eq "Application" }
$log.Source = "DPMinactiveAlert"
$log.WriteEntry("TRAP: DPMinactiveAlert: $error", [system.Diagnostics.EventLogEntryType]::Error,9911)
writelog $Error
$Error.Clear()
exit 1
}
#endregion
#region functions
function writelog
{
#write to console and logfile, pre-able with date time
param([array]$msg)
$dt = (Get-Date).ToString("MM/dd/yy HH:ss")
"$dt :: " >> $logfile
if ($debug) {Write-Host "$dt :: " -NoNewline}
for ($i = 0;$i -lt $msg.count;$i++) {
if ($debug) {Write-Host $msg[$i]}
$msg[$i] >> $logfile
}
}
function LoadDPMsnapin {
#load PS snap-in if not already
param ()
if (Get-PSSnapin | ?{$_.name -like "Microsoft.DataProtectionManager.PowerShell"}) {
}
else {
Add-PSSnapin -name Microsoft.DataProtectionManager.PowerShell
}
}
#endregion
#START
$debug = $true
$Error.clear()
$version = "v1.1"
[datetime]$now = Get-Date
$format = "HH:mm:ss"
LoadDPMsnapin
$logfile = "{0}\DPMinactiveAlert.LOG" -f , (get-location)
writelog "DPMinactivateAlert $version`n log output is written to $logfile`n`n"
$srv = Connect-DPMServer $env:computername
$alctl = $srv.AlertController
$alctl.RefreshAlerts()
Writelog ("Inactivating {0} alerts" -f $alctl.ActiveAlerts.Count )
#Don't log, alerts go to inactive and are still accessible
#could filter on $a.ErrorInfo.RecommendedAction to be "None"
if ($srv.GetProductInformation().version.major -gt 2 ){
foreach ($a in $alctl.ActiveAlerts.Values) {$a.ResolveAlert()}
}
else {
foreach ($a in $alctl.ActiveAlerts) {$a.ResolveAlert()}
}
writelog "Done inactivating alerts!"
Islam Gomaa
Islam @ IslamGomaa
Two weeks ago MY production DPM crashed and I had to fail over the Secondary DPM , I got an error in the Event viewer “An unexpected error caused a DPM service failure. Restart the DPM Service.”
However when I restart the DPM service I got the same error again and keep looping.
In my case I had some invalid replica that couldn't run anymore , so to clean up I ran this store Procedure in SQL Management studio in the DPM Sever
BEGIN TRAN
-- mark replica as invalid if there was some operation happening on that replica
UPDATE tbl_PRM_LogicalREplica
SET Validity = 1 -- Invalid
WHERE OwnerTaskIdLock IS NOT NULL AND
Validity <> 5 AND -- ProtectionStopped
Validity <> 6 -- Inactive
-- Release all the locks held
UPDATE tbl_PRM_LogicalREplica
SET OwnerTaskIdLock = null,
Status=8
UPDATE tbl_RM_ShadowCopy
SET ArchivetaskId = NULL,
RecoveryJobId = NULL
UPDATE tbl_ARM_Datasource
SET Status = 0,
OwnerLockId = NULL
DELETE tbl_RM_DatasourceServerlock
DELETE tbl_RM_ShadowCopyLocks
-- Set All running tasks and jobs to failed
UPDATE tbl_TE_TaskTrail
SET ExecutionState = 3,
LastStateName = 'Failure',
StoppedDateTime = GetUtcDate()
WHERE ExecutionState NOT IN (2,3)
UPDATE tbl_JM_JobTrail
SET JobState= 'Failed',
EndDateTime = GetUtcDate()
WHERE jobstate= 'Execute' OR jobstate= 'Retire'
-- unreserve resources held
UPDATE tbl_MM_Global_Media
SET ReservationLevel = 0,
ReservationOwnerMMId = null
UPDATE tbl_MM_Global_Drive
SET ReservationLevel = 0,
ReservationOwnerMMId = null
UPDATE tbl_MM_Global_IEPortResource
SET ReservationLevel = 0,
ReservationOwnerMMId = null
COMMIT TRAN
Islam Gomaa
Islam @ IslamGomaa.com
Microsoft System Center Data Protection Manager (DPM) 2010 allows you to protect client computers - desktops and laptops. Backup administrators can centrally configure data protection for the desktops and laptops in their environment. Additionally, administrators can give their end users the ability to define and manage their own backups. DPM 2010 enables end users to perform their own recoveries by leveraging the Previous Versions feature in Windows.
The client computers you are protecting may not be connected continuously to the network so there are some fundamental changes in the way DPM manages protection for client computers as compared to how it protects file servers.
Client computers will not be connected to the network at all times and the number of protected client computers can be much larger than the number of protected file servers. These scenarios have resulted in the following changes about how DPM 2010 manages client computer protection.
- The administrator can configure protection for the client computer that they want to protect. We recommend that administrators use software distribution mechanisms such as System Center Configuration Manager (SCCM) to install and configure the DPM agent.
- DPM will not automatically start a job to back up a client computer. The client computer polls the DPM server at 15 minute intervals and obtains the backup schedule that the administrator specifies for the protection group. The client computer starts the backup according to the schedule, or by user demand. Alternatively, the end user can start a backup at any time from the DPM Client UI.
- DPM will not show alerts for client computers that usually appear on protected servers. These alerts pertain to failures of individual jobs. For example, a synchronization failure alert will not appear for the DPM administrator to act upon for any of the failed synchronizations. This is because client computers are designed to retry the synchronization in the event of a failure. However, DPM 2010 allows you to configure DPM to alert the end user if a client computer has not been backed up for a predefined number of days that the administrator defined when they created the protection group.
DPM can perform backups on client computers even if they are connected using a virtual private network (VPN) connection. For example, a user can connect the client computer to the corporate network from their home using a VPN connection.
DPM 2010 protects client computers that are connected to the LAN and wireless connected computers. For client computers that are continuously connected to the network, ensure that the LAN network bandwidth is available to DPM. We recommend that you have a minimum network bandwidth of 256 Kilobits per second (kbps) available for computers that are connected to the LAN.
Islam Gomaa
Islam@IslamGomaa.com
As I mentioned in my previous article that DPM 2010 enable end-users to recover Databases, in order to allow end-users to recover databases DPM administrator needs to install SQL SERVER END-USER RECOVERY CLIENT and create and manage DPM roles.
In this article I will explain how to install and use SQL SERVER END-USER RECOVERY CLIENT
To install SQL Server EUR Client application, on the protected server Click Start, click Run, type %ProgramFiles%\Microsoft Data Protection Manager\SQLEur\EurClient.exe in the Open box, and then press Enter. This opens the SQL Server End-User Recovery Console (SQL EUR Console) that lists recovery jobs for SQL Server databases and provides options to start recoveries, rerun recoveries, or stop recoveries.
Before you can perform recoveries from the SQL EUR Console, you must connect to the DPM server. Click Connect to DPM Server to connect to a DPM server. You must know the name of the DPM server that you want to connect to.
After you connect to the DPM server, information is retrieved from the server about all recovery-related jobs for SQL Server databases.
By default, DPM displays recoveries done in the last 30 days. This information is automatically refreshed for current jobs. When there are no jobs running, this information is refreshed every two minutes. You can also manually refresh the information by using Refresh from the Actions menu.
SQL Server EUR Client allows you to recover SQL Server database files to a network folder or recover a database to any instance of SQL Server, however you cannot recover a database to the original instance of SQL Server directly.
To recover SQL Server databases, follow these steps:
1. In the SQL Server EUR Console, click New Recovery Job to start the Start New Recovery Job Wizard.
2. Select the SQL Server Instance Name and the Database Name that you want to recover, and then click Next.
3. Available recovery points are indicated in bold on the calendar in the recovery points section. Select the date from the calendar and the time from the drop-down list for the recovery points that you want to recover, and then click Next.
4. Specify the type of recovery you want to perform:
Recover to any instance of SQL Server. Enables you to recover SQL Server databases to an alternate instance of SQL Server that has been preconfigured by your DPM administrator. If you choose this option:
i. Click Next.
ii. Select the SQL Server Instance Name and the Recovered Database Name, and then click Next.
iii. Specify the database state and then click Next.
Copy to a network folder. You can recover SQL databases as files to any shared location where a DPM agent is installed and users have write access. If you choose this option:
i. Click Next.
ii. Select an alternate recovery point and then click Next.
iii. Specify the name of the destination server and the destination folder path to store database files during recovery.
5. Specify recovery options and then click Next.
6. On the Summary page, review the recovery settings, and then click Recover
| OWSUG Study Group |
| Special Announcement: TS: Windows 7, Configuring Study Group! 1. We are pleased announce that we are now accepting applications to join our TS: Windows 7, Configuring Study Group! certification study group. The previous OWSUG.ca study group was very successful with over 85% of the participants obtaining the certification by the end of the study group. Schedule Sessions take place on Tuesday evenings from 6:00 PM until 8:30 PM at CTE Solutions’ Ottawa facility beginning January, 2010 and continuing until April, 2010 for a total of 12 sessions (30 hours). Exact date will be send later after confirming the numbers of attendees Objectives 1. Individual: a. Prepare for the sessions by reading the training material content on the study group schedule. b. Develop and improve skills with Windows7. c. Obtain the TS: Windows 7, Configuring certification. 2. Group: a. Review the content, perform demonstrations and review exam practice questions. b. Attend 80 % of the sessions. Offer Cost to participate in the study group is $ 250. All participants will receive a copy (to keep) of the MCTS Self-Paced Training Kit (Exam 70-680): Configuring Windows® 7 and an exam voucher for the exam. Apply To apply please send an email to certify@owsug.ca. Additional registration details will be sent only to people that pre-register. Positions will not be held before deposit and fees have been received. Proudly Sponsored By |