{"id":3954,"date":"2014-02-27T20:44:00","date_gmt":"2014-02-27T20:44:00","guid":{"rendered":"https:\/\/209.235.70.100\/?p=3954"},"modified":"2022-09-22T13:22:04","modified_gmt":"2022-09-22T13:22:04","slug":"maintaining-your-databases-on-sql-server-express-edition","status":"publish","type":"post","link":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/","title":{"rendered":"Maintaining Your Databases on SQL Server Express Edition"},"content":{"rendered":"\n

Do you ever click on a bookmark to find that the website is no longer available? That scenario was the inspiration for my first post. I was posed a question regarding setting up maintenance tasks for SQL Server Express Edition and my bookmark no longer worked. Luckily, I already had a local copy of the script and its usage, but I wanted to ensure that the solution can be easily found by others. You can find an executable of Jasper Smith\u2019s original ExpressMaint utilities for SQL Server 2005\/2008\/2008 R2 here: https:\/\/expressmaint.codeplex.com\/<\/a>. Because there have been no recent updates, I have done so and made some modifications to it. This new script can be downloaded here.<\/a><\/p>\n\n\n\n

Additions and Improvements<\/strong><\/h4>\n\n\n\n
  • Updated Error Handling<\/li>
  • Forced Cleanup Parameters
    • This will ensure no backup or report files are accidentally deleted if you do not define the variables.<\/li><\/ul>
      <\/li>
    • Redesigned Specifically for SQL Server Express, Express with Tools, and Express with Advanced Services Editions<\/li>
    • SQL Server 2012 Support<\/li>
    • Backups for all Databases Can be Performed in One Task<\/li>
    • ‘Smart’ Exclusion of Database Using the Simple Recovery Model when Performing Transaction Log Backup
      • You can use one task to perform transaction log backups without worrying, even if only one database is using the simple recovery model. <\/li><\/ul>
        <\/li>
      • ‘Smart’ Exclusion of Master Database from Differential Backup Task<\/li><\/ul>\n\n\n\n

        Permissions<\/strong><\/h4>\n\n\n\n

        This script will create a stored procedure named \u2018expressmaint\u2019 in the master database by default that can then be run on a schedule through the task manager with ‘xp_cmdshell\u2019 and ‘Ole Automation Procedures’ enabled. In SQL Server 2005, the account that will run the scheduled task must be a member of the sysadmin role in your Express Edition instance. There are two ways to set up the permissions to run this stored procedure in SQL Server 2008 and higher:<\/p>\n\n\n\n

        1. Add the account to the sysadmin role
        2. Grant the account execute permission on the \u2018expressmaint\u2019 stored procedure in the database it was
        created in and db_backupoperator in the database(s) you will be backing up. You will also need to set
        up the xp_cmdshell proxy account.<\/p>\n\n\n\n

        Parameters<\/strong><\/h4>\n\n\n\n

        There are several options for configuring your SQL Server Express Edition maintenance tasks:<\/p>\n\n\n\n

        Database- database(s) to BE INCLUDED IN MAINTENANCE TASKS (REQUIRED)<\/strong><\/h4>\n\n\n\n

        Optype- maintenance tasks to perform (required)<\/p>\n\n\n\n

        Value<\/th>Description<\/th><\/tr>
        DB<\/td>Full backup<\/td><\/tr>
        LOG<\/td>Transition log backup<\/td><\/tr>
        DIFF<\/td>Differential backup<\/td><\/tr>
        CHECKDB<\/td>Integrity check<\/td><\/tr>
        REINDEX<\/td>Rebuilds all indexes<\/td><\/tr>
        REORG<\/td>Reorganizes all indexes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        BackupWith- backup options (optional)<\/strong><\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        option=’set’, etc<\/td>T-SQL WITH options for backup<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        BackupFldr- backup write location on disk (required)<\/strong><\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        Drive:folders<\/td>Location to write backups<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        ReportFLdr- report text file write location on disk (required)<\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        Drive:folders<\/td>Location to write text report files<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Verify- specify if backup should be verified (optional)<\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        0<\/td>Do not verify backup<\/td><\/tr>
        1<\/td>Verify backup (default)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        VerifyWith- verify options (optional)<\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        option=’set’,etc<\/td>T-SQL WITH options for verify<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        DbRetainUnit- unit of measure for DBRetainVal (required for backups)<\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        minutes<\/td>Clean up time in minutes<\/td><\/tr>
        hours<\/td>Clean up time in hours<\/td><\/tr>
        days<\/td>Clean up time in days<\/td><\/tr>
        weeks<\/td>Clean up time in weeks<\/td><\/tr>
        months<\/td>Clean up time in months<\/td><\/tr>
        copies<\/td>Number of backups<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        DbRetainVal- number of DbRetainUnit to keep (required for backups)<\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        any integer<\/td>Number or time period of backup files to keep on disk<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Report- specify if a report text should be written to disk (optional)<\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        0<\/td>Do not create report text file<\/td><\/tr>
        1<\/td>Create report text file (default)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        RptRetainUnit- unit of measure for RptRetainVal (required for report files)<\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        minutes<\/td>Clean up time in minutes<\/td><\/tr>
        hours<\/td>Clean up time in hours<\/td><\/tr>
        days<\/td>Clean up time in days<\/td><\/tr>
        weeks<\/td>Clean up time in weeks<\/td><\/tr>
        months<\/td>Clean up time in months<\/td><\/tr>
        copies<\/td>Number of reports<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        RptRetainVal- number of RptRetainUnit to keep (required for report files)<\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        any integer<\/td>Number or time period of report text files to keep on disk<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        CheckAttrib- specify if backups should not be deleted if they have not been backed up onto tape (optional)<\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        0<\/td>Do not check archive bit on backup file before deleting (default)<\/td><\/tr>
        1<\/td>Check archive bit on backup file before deleting<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        DelFirst-specify if old backups should be deleted before performing current backups; useful if disk space is a concern (optional)<\/strong><\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        0<\/td>Do not delete old backups before performing current backup (default)<\/td><\/tr>
        1<\/td>Delete old backups before performing current backup<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Debug- prints debugging information such as commands and temporary table records (optional)<\/strong><\/h4>\n\n\n\n
        Value<\/th>Description<\/th><\/tr>
        0<\/td>Do not print debugging information (default)<\/td><\/tr>
        1<\/td>Print debugging information<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Scheduling<\/h4>\n\n\n\n

        Since SQL Server Express edition does not have an Agent, the only way to schedule maintenance tasks is through the Windows task scheduler. First, you will need to create a sql file calling the expressmaint stored procedure and passing in the parameters you need. Then create a new scheduled task and set the command to run as SQLCMD.exe. The parameters to pass to sqlcmd are:<\/p>\n\n\n\n

        Value<\/th>Description<\/th><\/tr>
        -S<\/td>Instance name<\/td><\/tr>
        -i<\/td>Full path to script calling expressmaint<\/td><\/tr>
        -v PARAM<\/td>Parameters in script calling expressmaint (optional)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Examples<\/h3>\n\n\n\n

        On Windows 2003, if your SQL Server Express edition instance name is SQLExpress2008R2 and you wish to perform full backups for all databases and generate a report text file. In this example you will be keeping one week of backups in C:Backups and one month of report files in C:Reports. Old backups will be deleted before creating new ones. The scheduled task will be run under a username and password that has the appropriate permissions within SQL Server.<\/p>\n\n\n\n

        C:ScriptsFullBackups.sql<\/th><\/tr>
        exec [dbo].[expressmaint]
        @database =’ALL_DB’,
        @optype =’DB’,
        @backupfldr =’C:Backups’,
        @reportfldr =’C:Reports’,
        @dbretainunit = ‘weeks’,
        @dbretainval = 1,
        @rptretainunit = ‘months’,
        @rptretainval = 1,
        @delfirst = 1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        Scheduled Task- Run<\/th><\/tr>
        Drive:PathToExesqlcmd.exe -S .SQLExpress2008R2 -i”C:ScriptsFullBackups.sql”<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        Scheduled Task- Start in<\/th><\/tr>
        Drive:PathtoExe<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        On Windows Server 2008, your SQL Server Express edition instance name is the default instance and you wish to use one sql file for all maintenance tasks. The below example will run full backups for all user databases and generate a report text file. You will be keeping one week of backups in C:UserBackups and one month of report files in C:Reports. The scheduled task will be run under a username and password that has the appropriate permissions within SQL Server.<\/p>\n\n\n\n

        C:ScriptsFullBackups.sql<\/th><\/tr>
        exec [dbo].[expressmaint]
        @database = ‘$(DB)’,
        @optype = ‘DB’,
        @backupfldr = ‘$(BACKUPFOLDER)’,
        @reportfldr = ‘C:Reports’,
        @verify = 1,
        @dbretainunit = ‘$(DBRETAINUNIT)’,
        @dbretainval = ‘$(DBRETAINVAL)’,
        @rptretainunit = ‘months’,
        @rptretainval = 1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        Scheduled Task – Action – Program\/script<\/th><\/tr>
        Drive:PathToExesqlcmd.exe<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        Scheduled Task – Add arguments<\/th><\/tr>
        -S ServerName -i”C:ScriptsFullBackups.sql” -v DB=”ALL_USER” -v BACKUPFOLDER=”C:UserBackups” -v DBRETAINUNIT=”weeks” -v DBRETAINVAL=”1″<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Thank you for reading my first RDX blog post. Feel free to reach out to me on Google+ or leave a comment below to start a discussion. Stay tuned for my next post in the coming weeks!<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":114,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"acf":[],"yoast_head":"\nMaintaining Your Databases on SQL Server Express Edition - Navisite<\/title>\n<meta name=\"description\" content=\"Do you ever click on a bookmark to find that the website is no longer available? That scenario was the inspiration for my first post. I was posed a\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Maintaining Your Databases on SQL Server Express Edition\" \/>\n<meta property=\"og:description\" content=\"Do you ever click on a bookmark to find that the website is no longer available? That scenario was the inspiration for my first post. I was posed a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/\" \/>\n<meta property=\"og:site_name\" content=\"Navisite\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-27T20:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-22T13:22:04+00:00\" \/>\n<meta name=\"author\" content=\"Megan Ferringer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@navisite\" \/>\n<meta name=\"twitter:site\" content=\"@navisite\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Megan Ferringer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/\"},\"author\":{\"name\":\"Megan Ferringer\",\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/person\/99bad6e33cc6d3ac27337400026e4a9f\"},\"headline\":\"Maintaining Your Databases on SQL Server Express Edition\",\"datePublished\":\"2014-02-27T20:44:00+00:00\",\"dateModified\":\"2022-09-22T13:22:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/\"},\"wordCount\":1141,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.navisite.com\/#organization\"},\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/\",\"url\":\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/\",\"name\":\"Maintaining Your Databases on SQL Server Express Edition - Navisite\",\"isPartOf\":{\"@id\":\"https:\/\/www.navisite.com\/#website\"},\"datePublished\":\"2014-02-27T20:44:00+00:00\",\"dateModified\":\"2022-09-22T13:22:04+00:00\",\"description\":\"Do you ever click on a bookmark to find that the website is no longer available? That scenario was the inspiration for my first post. I was posed a\",\"breadcrumb\":{\"@id\":\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.navisite.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Maintaining Your Databases on SQL Server Express Edition\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.navisite.com\/#website\",\"url\":\"https:\/\/www.navisite.com\/\",\"name\":\"Navisite\",\"description\":\"Elevate Your Cloud Journey\",\"publisher\":{\"@id\":\"https:\/\/www.navisite.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.navisite.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.navisite.com\/#organization\",\"name\":\"Navisite\",\"url\":\"https:\/\/www.navisite.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.navisite.com\/wp-content\/uploads\/2020\/02\/logo.svg\",\"contentUrl\":\"https:\/\/www.navisite.com\/wp-content\/uploads\/2020\/02\/logo.svg\",\"width\":1,\"height\":1,\"caption\":\"Navisite\"},\"image\":{\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/twitter.com\/navisite\",\"https:\/\/www.instagram.com\/navisite\/\",\"https:\/\/www.linkedin.com\/company\/navisite\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/person\/99bad6e33cc6d3ac27337400026e4a9f\",\"name\":\"Megan Ferringer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.navisite.com\/wp-content\/uploads\/2021\/02\/IMG-0529-150x150.jpg\",\"contentUrl\":\"https:\/\/www.navisite.com\/wp-content\/uploads\/2021\/02\/IMG-0529-150x150.jpg\",\"caption\":\"Megan Ferringer\"},\"description\":\"Megan is the Content Marketing Manager at Navisite with more than 10 years of experience helping brands discover and tell their stories. From working at a global non-profit organization to boutique marketing agencies in Chicago, she champions the power of storytelling across all industries.\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Maintaining Your Databases on SQL Server Express Edition - Navisite","description":"Do you ever click on a bookmark to find that the website is no longer available? That scenario was the inspiration for my first post. I was posed a","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/","og_locale":"en_US","og_type":"article","og_title":"Maintaining Your Databases on SQL Server Express Edition","og_description":"Do you ever click on a bookmark to find that the website is no longer available? That scenario was the inspiration for my first post. I was posed a","og_url":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/","og_site_name":"Navisite","article_published_time":"2014-02-27T20:44:00+00:00","article_modified_time":"2022-09-22T13:22:04+00:00","author":"Megan Ferringer","twitter_card":"summary_large_image","twitter_creator":"@navisite","twitter_site":"@navisite","twitter_misc":{"Written by":"Megan Ferringer","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/#article","isPartOf":{"@id":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/"},"author":{"name":"Megan Ferringer","@id":"https:\/\/www.navisite.com\/#\/schema\/person\/99bad6e33cc6d3ac27337400026e4a9f"},"headline":"Maintaining Your Databases on SQL Server Express Edition","datePublished":"2014-02-27T20:44:00+00:00","dateModified":"2022-09-22T13:22:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/"},"wordCount":1141,"commentCount":0,"publisher":{"@id":"https:\/\/www.navisite.com\/#organization"},"articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/","url":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/","name":"Maintaining Your Databases on SQL Server Express Edition - Navisite","isPartOf":{"@id":"https:\/\/www.navisite.com\/#website"},"datePublished":"2014-02-27T20:44:00+00:00","dateModified":"2022-09-22T13:22:04+00:00","description":"Do you ever click on a bookmark to find that the website is no longer available? That scenario was the inspiration for my first post. I was posed a","breadcrumb":{"@id":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.navisite.com\/blog\/maintaining-your-databases-on-sql-server-express-edition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.navisite.com\/"},{"@type":"ListItem","position":2,"name":"Maintaining Your Databases on SQL Server Express Edition"}]},{"@type":"WebSite","@id":"https:\/\/www.navisite.com\/#website","url":"https:\/\/www.navisite.com\/","name":"Navisite","description":"Elevate Your Cloud Journey","publisher":{"@id":"https:\/\/www.navisite.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.navisite.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.navisite.com\/#organization","name":"Navisite","url":"https:\/\/www.navisite.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.navisite.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.navisite.com\/wp-content\/uploads\/2020\/02\/logo.svg","contentUrl":"https:\/\/www.navisite.com\/wp-content\/uploads\/2020\/02\/logo.svg","width":1,"height":1,"caption":"Navisite"},"image":{"@id":"https:\/\/www.navisite.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/twitter.com\/navisite","https:\/\/www.instagram.com\/navisite\/","https:\/\/www.linkedin.com\/company\/navisite"]},{"@type":"Person","@id":"https:\/\/www.navisite.com\/#\/schema\/person\/99bad6e33cc6d3ac27337400026e4a9f","name":"Megan Ferringer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.navisite.com\/#\/schema\/person\/image\/","url":"https:\/\/www.navisite.com\/wp-content\/uploads\/2021\/02\/IMG-0529-150x150.jpg","contentUrl":"https:\/\/www.navisite.com\/wp-content\/uploads\/2021\/02\/IMG-0529-150x150.jpg","caption":"Megan Ferringer"},"description":"Megan is the Content Marketing Manager at Navisite with more than 10 years of experience helping brands discover and tell their stories. From working at a global non-profit organization to boutique marketing agencies in Chicago, she champions the power of storytelling across all industries."}]}},"publishpress_future_action":{"enabled":false,"date":"1970-01-01 00:00:00","action":"","terms":[],"taxonomy":"","browser_timezone_offset":0},"_links":{"self":[{"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/posts\/3954"}],"collection":[{"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/users\/114"}],"replies":[{"embeddable":true,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/comments?post=3954"}],"version-history":[{"count":2,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/posts\/3954\/revisions"}],"predecessor-version":[{"id":32304,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/posts\/3954\/revisions\/32304"}],"wp:attachment":[{"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/media?parent=3954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/categories?post=3954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/tags?post=3954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}