cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Pondering Automation: Movin' that DB

360
Views
0
Helpful
0
Comments
Cisco Employee

Howdy out there in automation land!! Since I came across my own issues with database size I decided to create a how to VOD on moving a DB from one server to another and the whole re-attach process. This is done for SQL and should be straight forward enough for everyone to follow!

The steps are as follows...

  1. Attach SQL server to remote storage
  2. Backup Process and Reporting DB to remote storage
  3. Move DBs to new SQL server
  4. Restore both DBs to new SQL server
  5. Use DB Utility to attach new DB server to CPO
  6. Use CPO console to remove/re-attach Reporting DB
  7. Use attached script to help you restore Reporting DB jobs for grooming

And that's all there is to it! Hopefully the below VOD will help you out. The audio is a bit loud so just a fair warning!

Onto the VIDEO!

Play recording (27 min 2 sec)

Recording password: pXFWGMZ3

Thanks as always to all my wonderful readers and those who continue to stick with and use CPO. Big things are on the horizon and I hope that you will continue to use CPO and find great uses for it! If you have a really exciting automation story, please email me it! (see below) I would love to compile some stories and feature customers or individual stories in an upcoming blog!!!

AUTOMATION BLOG DISCLAIMER: As always, this is a blog and my (Shaun Roberts) thoughts on CPO and automation, my thoughts on best practices, and my experiences with the product and customers. The above views are in no way representative of Cisco or any of it's partners, etc. None of these views, etc are supported and this is not a place to find standard product support. If you need standard product support  please do so via the current call in numbers on Cisco.com or email tac@cisco.com

Thanks and Happy Automating!!!

--Shaun Roberts

shaurobe@cisco.com

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards
This widget could not be displayed.