Comments
Sort by recent activity
Yes, I'm sure user have right to start service. I use the same user when I install sqlbackup manually... / comments
Yes, I'm sure user have right to start service. I use the same user when I install sqlbackup manually...
example :
2 servers :
each night, sqlbackup pro backup DB_server1 by job, and restore on DB_server2 by job too...
i know that is possible with dts & jobs ... but sql backup could offer this possibility later?
in summary, have a possibility to create restore job with sqlbackup... / comments
example :
2 servers :
each night, sqlbackup pro backup DB_server1 by job, and restore on DB_server2 by job too...
i know that is possible with dts & jobs ... but sql backup could offer this possibi...
Huh... no, any user on the database... but I solve the problem. DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-SQL "RESTORE DATABASE [DB2] FROM DISK = ''P:\backup\DB1.sqb'' WITH RECOVERY, MOVE ''DB1'' TO ''E:\MSSQL\Data\DB2.mdf'', MOVE ''DB1_log'' TO ''E:\MSSQL\Data\DB2_log.ldf'', REPLACE"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
SELECT @exitcode returnExitCode,
@sqlerrorcode returnSQLErrorCode
and that's right.. :roll:
thx / comments
Huh... no, any user on the database... but I solve the problem.DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-SQL "RESTORE DATABASE [DB2] FROM DISK = ''P:\backup...
Yes, it's ok.
there were anything because it was default values.. but when custom options.. entries were registered in regedit [image]
thanks / comments
Yes, it's ok.
there were anything because it was default values.. but when custom options.. entries were registered in regedit
thanks
sorry,
when I say "config" I think to the config of sqlbackup (option button) with "backup location", "email", "log files" ... / comments
sorry,
when I say "config" I think to the config of sqlbackup (option button) with "backup location", "email", "log files" ...
thanks petey [image] / comments
thanks petey
excellent [image]
thanks / comments
excellent
thanks
And how can I define Built-in account for SQLBackup Agent service and windows authentification for sql?
thanks / comments
And how can I define Built-in account for SQLBackup Agent service and windows authentification for sql?
thanks