How reliable is backuping sql from the express management studio. I know how to do this, I wonder just how reliable it is.
I have had a tech from a particular softwares help desk tell me that method doesnt allways work.
I have had it fail (backup wasnt complete) myself when moving the database from 1 server to another (I then used a 3rd party program
The plan is to setup a batch file to run a weekly sql backup & spit that backup over to an old server or NAS. The 'normal' Win backups will still
be run regardless .
The idea being if the server had a complete meltdown, we could get the companies software up & running quite quickly by importing that backup
onto another old server or workstation, both of which are ready to go just in case - just needing the current database. Not perfect but would get the company semi-operational again , quickly.