Activity overview
Latest activity by gael
Service dependance
Hi,
During test, i've noticied that if we restart MSSQL server service, sqlbackup don't run correctly. (VDI 1000)
so SQLBackupAgent service need to be started after SQL Server service.
may bay a mo...
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...
error 810 during backup (with auto install)
hi,
after installing with this command line :SQBServerSetup.exe /verysilent /sqbminimal /suppressmsgboxes /svcuser %1\SQLUSER /svspw %2 /sqluser %1\SQLUSER /sqlpw %2
and run by : install.cmd doma...
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...
sqlbackup 5 ?
what are they the functionalities on the next version from SQLbackup? will it have solutions of job of restoration?
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...
error with restore job
I'm creating a (simple) job to restore DB1 > DB2 (sql2k):
p:\backup\DB1.sqb is ok.DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-SQL "RESTORE DATABASE DB2 FROM DISK = ''P...
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" ...
Config file?
After the auto install, i' need to set configuration to auto.
how are save configuration on SQLBackup??
is there solution to backup config?
thanks