Steve Craig cixelsyd
cixelsyd
/ backupdb.rb
Created
December 17, 2011 20:45
"backupdb.rb" is the main recipe inside of a larger "backupdb" role
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Cookbook Name:: smashrun | |
| # Recipe:: backupdb | |
| # | |
| # Copyright 2010, Smashrun, Inc. | |
| # Author:: Steven Craig <support@smashrun.com> | |
| # | |
| # Licensed under the Apache License, Version 2.0 (the "License"); | |
| # you may not use this file except in compliance with the License. | |
| # You may obtain a copy of the License at |
cixelsyd
/ createdb.rb
Created
December 17, 2011 20:48
"createdb.rb" creates empty MSSQL databases from settings inside data bags
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Author:: Steven Craig <support@smashrun.com> | |
| # Cookbook Name:: windows | |
| # Recipe:: createdb | |
| # | |
| # Copyright 2010, Smashrun, Inc. | |
| # | |
| # Licensed under the Apache License, Version 2.0 (the "License"); | |
| # you may not use this file except in compliance with the License. | |
| # You may obtain a copy of the License at |
cixelsyd
/ postrestoredb.rb
Created
December 17, 2011 21:10
"postrestoredb.rb" updates schema of MSSQL databases from data bag settings after they have been refreshed
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Cookbook Name:: smashrun | |
| # Recipe:: postrestoredb.rb | |
| # | |
| # Copyright 2010, Smashrun, Inc. | |
| # Author:: Steven Craig <support@smashrun.com> | |
| # | |
| # Licensed under the Apache License, Version 2.0 (the "License"); | |
| # you may not use this file except in compliance with the License. | |
| # You may obtain a copy of the License at |
cixelsyd
/ restoredb-restore.sql.erb
Created
December 17, 2011 21:36
"restoredb.rb" recipe needs templated T-SQL script to restore database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Author:: <%= @author_name %> / <%= @author_email %> | |
| -- Cookbook Name:: smashrun | |
| -- Templates:: <%= @basesql_template %> | |
| -- | |
| -- Copyright 2010, Smashrun, Inc. | |
| -- | |
| -- Licensed under the Apache License, Version 2.0 (the "License"); | |
| -- you may not use this file except in compliance with the License. | |
| -- You may obtain a copy of the License at |
cixelsyd
/ backupdb.rb
Created
December 17, 2011 20:42
"backupdb.rb" is the main recipe inside of a larger "backupdb" role
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Cookbook Name:: smashrun | |
| # Attributes:: backupdb | |
| # | |
| # Copyright 2010, Smashrun, Inc. | |
| # Author:: Steven Craig <support@smashrun.com> | |
| # | |
| # Licensed under the Apache License, Version 2.0 (the "License"); | |
| # you may not use this file except in compliance with the License. | |
| # You may obtain a copy of the License at |
cixelsyd
/ createdb.rb
Created
December 17, 2011 20:49
"createdb.rb" creates empty MSSQL databases from settings inside data bags
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Author:: Steven Craig <support@smashrun.com> | |
| # Cookbook Name:: windows | |
| # Attributes:: createdb | |
| # | |
| # Copyright 2010, Smashrun, Inc. | |
| # | |
| # Licensed under the Apache License, Version 2.0 (the "License"); | |
| # you may not use this file except in compliance with the License. | |
| # You may obtain a copy of the License at |
cixelsyd
/ rsyncdb.rb
Created
December 17, 2011 20:54
"rsyncdb.rb" zips and moves backups from settings inside data bags
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Cookbook Name:: smashrun | |
| # Recipe:: rsyncdb | |
| # | |
| # Copyright 2010, Smashrun, Inc. | |
| # Author:: Steven Craig <support@smashrun.com> | |
| # | |
| # Licensed under the Apache License, Version 2.0 (the "License"); | |
| # you may not use this file except in compliance with the License. | |
| # You may obtain a copy of the License at |
cixelsyd
/ restoredb.rb
Created
December 17, 2011 21:06
"restoredb.rb" restores/refreshes MSSQL databases from data bag settings
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Cookbook Name:: smashrun | |
| # Attributes:: restoredb | |
| # | |
| # Copyright 2010, Smashrun, Inc. | |
| # Author:: Steven Craig <support@smashrun.com> | |
| # | |
| # Licensed under the Apache License, Version 2.0 (the "License"); | |
| # you may not use this file except in compliance with the License. | |
| # You may obtain a copy of the License at |
cixelsyd
/ createdb-execute_sql.bat.erb
Created
December 17, 2011 21:21
"createdb.rb" recipe needs a templated batch file to execute arbitrary T-SQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| :: chef template <%= @executesql_template %> | |
| :: becomes "<%= @executesql_bat %>" on the server | |
| :: generic execute sql wrapper - <%= @author_name %> / <%= @author_email %> | |
| :: requires chef / internet connectivity to opsware git repo | |
| :: initial version 2011:09:19 15:01:00 EST | |
| :: pass SQL sa passwd as ARG1 | |
| :: pass SQL script as ARG2 | |
| :: pass SQL logfile as ARG3 |
cixelsyd
/ createdb-create.sql.erb
Created
December 17, 2011 21:22
"createdb.rb" recipe needs a templated T-SQL script to create databases
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Author:: <%= @author_name %> / <%= @author_email %> | |
| -- Cookbook Name:: windows | |
| -- Templates:: <%= @basesql_template %> | |
| -- | |
| -- Copyright 2010, Smashrun, Inc. | |
| -- | |
| -- Licensed under the Apache License, Version 2.0 (the "License"); | |
| -- you may not use this file except in compliance with the License. | |
| -- You may obtain a copy of the License at |
OlderNewer