Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2007
    Posts
    20

    Unanswered: Kinda new to SQL, have a few questions

    I have to update my database format to msSQL (any version) and the specific version I will be using I guess is unknown.

    1. Security wise is there anything I should have installed? Can databases be accessed remotely through anything other than serverside scripts or software?
    2. Backups will be important and so does msSQL allow you to do this easily? Is there a function in the program that will allow automatic backups? Or, I have autobackup software that basically zips files, would this work for msSQL?


    Will probably think of some more questions :P

    Thanks a lot

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    In answer to your second question (2) : Yes MSSQL allows scheduled backups from within the management studio interface. You can set up a scheduled job and get it to run on a daily basis. You need to set up a backup device (file area). Usually advisable to have a seperate drive for this (although a partition MIGHT suffice, except in disk failure scenarios).

  3. #3
    Join Date
    Apr 2007
    Posts
    20
    Thanks, when you say a separate drive is this due to performance or loss of data due to disk failure etc?
    Is this a feature of all versions?

    Thanks again

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ummmmm.....do you have sql server client tools installed?

    Start there, then get back to us

    If you don't have access to a sql server or the tools, this will be very difficult to help you
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Apr 2007
    Posts
    20
    This was just general research before I go out and buy anything expensive

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Depending upon your requirements you could start with SQL Server Express, which is very cheap (free, I think).
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    yes, it's free. has similar limitations as MSDE, like no more than 4gb database size, etc.

  8. #8
    Join Date
    Apr 2007
    Posts
    20
    Ok then thanks, did not know there was a free version.
    What else should I add to my checklist of things to install?

    sql server client tools?

  9. #9
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    there is a free client to go along with the free server. client is SQL Server Management Studio Express, server is SQL Server Express.

    you can get both here: http://msdn.microsoft.com/vstudio/express/sql/download/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •