• About
    • Blog
    • Business Process
    • Charity Work
    • History
    • News
  • Services
    • Legacy System Support
    • Bespoke System Development
    • Web Design & Development
    • View all services
  • Products
  • Our work
    • Customers
    • Case Studies
  • Careers
  • Contact
Microsoft Partner - Application Development
11th May 2015

Backup Microsoft SQL Server 2014 Express Databases Automatically

Microsoft PSP Knowledge SQL SQL Express SQL Server SQL Server 2014 Express
Backup Microsoft SQL Server 2014 Express Databases Automatically

We have a client who has SQL Express 2014 and wanted to automate backups. Please find the steps to create automated backups using SQL Express 2014.

Step 1: Open SQL Server 2014 Express

Step 2: Expand Server Objects

Step 3: Right Click on Backup Device and select New Backup Device.

Step 4: The Backup Device Popup window will appear

                a./ Enter Device name

                b./ Enter the destinations of the backup files

                c./ Select Ok.

Step 5: Right click on the Backup Device you have just created and select Backup Up a Database.

Step 6: Select the database you wish to backup up from under source

Step 7: Select the script option.

Step 8: Select Ok.

Step 9: Save the Script to a file location of your choice.

Step 10: Create a batch file with the following information text:

sqlcmd -E -S [SERVERNAME]\[SQLINSTANCE] -i [LOCATIONOFSQLSCRIPT]

Step 11: Setup a Schedule Task to run the batch file on a nightly basis.

Share:
PSP IT Design & Development
About Us
  • Privacy Policy
  • History
  • Customers
  • News
  • Blogs
Services
  • Legacy System Modernisation
  • Website Design & Development
  • Bespoke Application Development
  • Outsource IT Strategy
  • All Services
Contact
  • 01775 722377
  • letstalk@psp-it.co.uk
  • Carver House, Apex Court, Spalding Office Park, Elsoms Way, Pinchbeck, Spalding,Lincolnshire, PE11 3UL

Terms & Conditions Privacy Policy

© PSP People Systems Process Ltd. 2022. All Rights Reserved.

MENU

MENU

  • About

    • Blog

    • Business Process

    • Charity Work

    • History

    • News

  • Services

    • Legacy System Support

    • Bespoke System Development

    • Web Design & Development

    • View all services

  • Products

  • Our work

    • Customers

    • Case Studies

  • Careers

  • Contact

© PSP People Systems Process Ltd. 2022. All Rights Reserved. Privacy Policy

give us a call
01775 722377
drop us an email