my personal blog about systemcenter

All posts tagged SQL Server 2012

 

Data Protection Manager 2012 can protect SQL server 2012 with the exception for Always On Databases this feature should be ready in the Service Pack 1 time frame for System Center 2012.

There is a current  thread on TechNet regarding SQL server 2012 supported that this post was created from

http://social.technet.microsoft.com/Forums/en-US/dataprotectionmanager/thread/03f1267a-5061-488d-b4d6-e4b3b9b66dd5

 

image

A few steps to install SQL server so we can try to backup / recover a database

image

SQL Features Install

image

We will just install database engine and management tools

image

And place our databases

image

And its time to refill the coffee.

image

Success Smile

 

image

We then need to install the Data Protection Manager agent on the SQL Server 2012

image

Add the SQL Server 2012 host , here SQL12

 

image

Add credentials that can install a agent locallly

image

And with Data Protection Manager Success is always close by Smile

 

image

image

Create a database

image

image

Add some a table where we can add some data

image

Enter a few rows

image

And its time to create the Data Protection Manager Protection Group

image

Create a protection group for servers

image

Browse to the SQL server 2012 server and add the databases with autoprotect

image

Add a name to the protection group , in the demo setup there no autoloader so backup to tape only

image

Keep 5 days and Sync every 15 minutes

image

Success

image

Change journal not initialized or is the wrong size (ID 30118 Details: The volume change journal is not active (0x8007049B))

Almost , getting Replica is Inconsistent all the time

 

image

To resolve the error give SYSTEM sysadmin rights to the SQL Server 2012 Installation

image

And we can now see that the SQL server 2012 database is protected.

image

And to provoke a error , we delete the table we created

image

Go into Data Protection Manager , Recovery select the SQL server 2012 database and what time you want to recover from , right click and recover

image

image

In this case I want to recovery and overwrite the database to the original server

image

And leave the database operational

image

Summary before recivery

image

Success for recovery of the SQL server 2012 database

image

image

And we got the database restores as it was before the table was deleted