SQL Archives - Flemming Riis's System Center Blog

Nov

Data Protection Manager 2012 R2 UR4 Support SQL 2014

Categories: Data Protection Manager, DPM, SQL

Comments Off

With the release of update rollup 4 for Data Protection Manager 2012 R2 , it is now supported to protect a remote SQL server running SQL 2014 (about time)

http://blogs.technet.com/b/dpm/archive/2014/10/29/protect-sql-server-2014-using-dpm-2012-r2.aspx

There are still some features that isnt supported to test and verify , v.next will support/require SQL 2014 as DPM database target but in 2012 R2 UR4 its protected data only

Install is pretty straight forware as usual

Push the agent , will require a reboot due to updated filter driver

After server have been reboottet verify that SYSTEM have sysadmin rights on the SQL server you want to protect

Create new protection group

Select Servers

browse the SQL instance , and select auto to ensure that all databases will be added

Name the protection protectoin group , in the demo setup there is no tape libarary so short term only

And a hourly backup

Sucess ! Smiley

and a few minutes later we now have a valid backup , ready for first restore test

Oct

Data Protection Manager Recover SQL master database

Categories: Data Protection Manager, Disaster Recovery, DPM, SQL

Comments: No

Had a question today about the ability to recover the SQL master database if the SQL server wasnt operational.

To set the scene for the converation we did the following

Installed the Data Protection Manager on the SQL 2012 server , created a brand new fresh and shiny protection group , added the SQL instance

Created short term recovery this was after all just a test

And a backup every hour kept for the last 5 days

And as always with Data Protection Manager Sucess is an option 🙂

And a few minutes later we now have a full backup of the SQL server

And lets try to add the human factor

Twice

And after that we have a non functional SQL Server

And as we can see the reason if lack of master databases

DPM to the rescue , enter recovery select the master database

Option One , Recover to original instance (otherwise restore to folder and copy the files manually)

And leave database operational as we are not recovering from additional logs

Verify server/files

And 35 seconds later the database is recovered without incident

Recovery is complete , SQL instance is restarted and we can fire the blogger that deleted the master database

Jan

Data Protection Manager 2012 SP1 Remote SQL Server 2012 SP1

Categories: Data Protection Manager, SQL, Windows Server 2012

Comments: No

With System Center 2012 SP1 the support to use SQL Server 2012 as a database for Data Protection Manager was added

The use the SQL Server 2012 to colocate DPM databases there are a few things that needs to be configured

SQL Reporting Services Need to be installed

SQL needs to run under a service account (not its against recommendations to use the same account on for each role but for testing it works great)

Just to be safe I always set the collation to “CPI_CI_AS” but honestly not sure if it’s a requirement

Adding the account that host SQL and the admin account I will install DPM with

And just default install of reporting services.

On the SQL server run the DPM Remote SQL Prep Installer

This only takes a few seconds after VC redist install

On the DPM server start the installer and select use existing instance and enter administrative permissions for the remote SQL server

and when the installer states that we need the requirement we can proceed

Location for database is greyed out as the DB is on the remote sql instance

And we need credentials for the reporting user

And the installer skips SQL Server install and jumps directly to tools and workstations

and a little bit later we are good to go

and we can see that the installer added the rights needed to the SQL instance

and DPM is ready for action.

Jan

Data Protection Manager 2012 SP1 SQL Backup to Azure

Categories: Azure, Data Protection Manager, SQL

Comments: No

Microsoft have released a update for data protection manager 2012 SP1 that support backup to Azure

The updates features is support for SQL based workloads and 120 days retention , the 120 days is a BIG feature enhancement

http://support.microsoft.com/kb/2779569

Description of an update rollup package that adds features to Windows Azure Online Backup in System Center 2012 SP1 DPM and in Windows Server 2012

This article describes an update rollup package that adds the following features to the Windows Azure Online Backup for Microsoft System Center 2012 Service Pack 1 (SP1) Data Protection Manager (DPM) and for a computer that is running Windows Server 2012:
This update improves the performance of Windows Azure Online Backup.
Windows Azure Online Backup support for a SQL Server data source in System Center 2012 SP1 DPM is available.
The retention range of Windows Azure Online Backup for System Center 2012 SP1 DPM is increased to support 120 recovery points

http://www.windowsazure.com/en-us/home/features/online-backup/ there is a 300gb trial available install guide here http://flemmingriis.com/?p=1103 the “old” installer needs to be installed before installing the upgrade

Verify that no jobs are running against Azure before starting the upgrade

And 16 seconds later we are ready to rock

And with the updated integrations we can now add SQL based workload

And select the Cloud option , as always we need to backup to disk before cloud so short term is a requirement

And another cool feature we can select what database we want protected with Azure

And 120 days very very cool Smiley , we still need long term for tape in most environments , but then there is room for new features later on.

And we can create a recovery point manually to the cloud instead of having to wait until the schedule kicks in

and a short while later our data is moved to the cloud

Jul

Virtual Machine Manager Convert Virtual Machine Failed Error 2909

Categories: SQL

Comments: 1

My normal weekend procedure these days goes with baby sitting Virtual to Virtual converting from VMware to Hyper-V using Virtual Machine Manager 2012

I had a few servers that failed and for instead of trouble shooting I did a retry as the source servers was in dire need of being put down so I thought the error was due to that , but again after x hours the covert job through VMM failed again.

The Convert job starts without issues

But fails on disk 2

Error 2909 , from the Virtual to Virtual Conversion , claiming that the file already exists , looking the target before job start shows no vhd files in the directory.

Looking at the source side I can see that there is a vmdk for the system drive that completes without error

And the data drive that fails.

The Error 2909 was due to the drives both being called test.vmdk as vmware don’t enforces different vmdk names if the files are located on different data stores.

So after changing the vmdk file name on the source I can convert the virtual machine from VMWARE to Hyper-V

All posts in SQL

Data Protection Manager 2012 R2 UR4 Support SQL 2014

Data Protection Manager Recover SQL master database

Data Protection Manager 2012 SP1 Remote SQL Server 2012 SP1

Data Protection Manager 2012 SP1 SQL Backup to Azure

Virtual Machine Manager Convert Virtual Machine Failed Error 2909