How do I backup my databases?

Results 1 to 3 of 3
  1. #1
    Apprentice james121056 is offline
    MemberRank
    Aug 2008 Join Date
    8Posts

    How do I backup my databases?

    When I try and back them up it says I can't in the Express version, which version do I need?


  2. #2
    The Cat in the Hat cypher is offline
    MemberRank
    Oct 2005 Join Date
    IrelandLocation
    5,073Posts

    Re: How do I backup my databases?

    Use sqlcmd to backup your database then.

  3. #3
    Proficient Member MOT7 is offline
    MemberRank
    Jan 2013 Join Date
    SomewhereLocation
    187Posts

    Re: How do I backup my databases?

    Quote Originally Posted by james121056 View Post
    When I try and back them up it says I can't in the Express version, which version do I need?
    I don't know what your problem is, backup the database is kind of easy even with the express version (i use it and it works flawlessly).

    1.
    How to: Back Up a Database (SQL Server Management Studio)

    or try
    2.
    How to backup databases in SQL Server | lynda.com tutorial - YouTube

    Not even 5 minutes to google with the keywords: "sql server 2008 express database backup".

    Edit:
    Look a bit around youtube and you can find tutorials for using plan (if you got the full 2008 sql version) or use windows tasks to automatically backup your databases (you can even use .batch files). Hope that helps you out with enough options



Advertisement