Re: [Mssqlcompressed-users] User and Passwordcredentials in Connectionstring

[Otis L. <oti...@go...>]

Hello Clay,

you are right.
I created a user on the DB with my Windows - usergroup - credentials and
gave him the sysadmin-role.
The DB runs on a Windows 2008 System, so i fire the batch in a planned task
with the Checkbox "highest  rights"
(dont know, how it is written in english (it's a german system).

here is the batch (the echos are for the test):

echo off

SET
logfile="d:\db-Dumps\NV-REP_ENTW_BACKUP_LOG-%date:~-4,4%-%date:~-7,2%-%date:~0,2%%1%.log"

echo ========================== Starting Backup Of Repository NV_REP_ENTW
================================

C:\MSSQLCompressedBackup\msbp.exe backup "db(database=NV_REP_ENTWICKLUNG)"
"zip64(level=3)" "local(path=d:\db-Dumps\NV_REP_ENTW.bak.zip)"  >> %logfile%

echo ============================= finished Backup
==============================

: end

Your application is absolutely great! especially, if you have
commandline-admins and they think that we developer will reach with
10 GB 100 years ;-)


Sorry, my english is absolutely bad...
Have a nice day and thank you very much!

Otis