crossmark wrote
I want to be able to back up my DNN database to a local file on my machine. I'm launching a business that will involve many users updating their own pages and will be in deep doggy doo should something go wrong and I don't have a solid back up. Aside from that, I just want a back up for when I'm testing things in case I totally screw up the database (which I've done once and thankfully recovered from without too much trouble).
Anyone know of a software or service that would accomplish a local back up? I have a copy of Aqua Data Studio and know how to export a single table, but I don't know how to get the entire database exported.
Any input is greatly appreciated.
Unless the command has changed in 2005, the SQL 2000 backup command was:
BACKUP DATABASE { database_name | @database_name_var }
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = { blocksize | @blocksize_variable } ]
[ [ , ] DESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] DIFFERENTIAL ]
[ [ , ] EXPIREDATE = { date | @date_var }
| RETAINDAYS = { days | @days_var } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] NAME = { backup_set_name | @backup_set_name_var } ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]
I do think however that backing up the database itself will NOT back up content files, images or skins as all of these are kept seperately in the filesystem instead of internally stored within the SQL database.