How to backup database in SQL Server 2008 Express Edition

Posted on 2010-01-04
Last Modified: 2012-05-08
Hi, how is database backup done in SQL Server 2008 Express Edition? Thanks in advance.
Question by:0nepiece
    LVL 60

    Accepted Solution

    LVL 13

    Assisted Solution

    USING COMMAND: BACKUP DATABASE %DBNAME% to disk = 'c:\myfilename.bak'
    optionally you can add
    BACKUP DATABASE %DBNAME% to disk = 'c:\myfilename.bak' with password = '123456'
    LVL 13

    Expert Comment

    check out: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/89a4658a-62f1-4289-8982-f072229720a1.htm for more options

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now