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?
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).