Hot answers tagged

1

I wrote an universal script for backup selected databases from MS Sql Server Express. Script loops thru an array of databases and generates separate .bak for every database. Backup filename starts with database name and ends with time and date. Events are logged in log.log file, including database backup task details, so non of existing backups are ...


1

Information about whether the logon process in OSQL is secure or not seems to be sketchy and contradictory (see here) I think SQLCMD supports SSL encryption which would prevent the password being sniffed over the wire - but if you're storing the password in a script or something and you're worried about prying eyes, encrypt it and decrypt it yourself before ...


Only top voted, non community-wiki answers of a minimum length are eligible