Posts
Sort by recent activity
Odd permissions issue with restore
Running the following:
master..sqlbackup N'-SQL "RESTORE DATABASE [ic001CommonPrd]
FROM DISK = ''D:\SQLBackups\FULL_PILS_ic001CommonPrd_20061206_020022.sqb''
WITH STANDBY = ''C:\Program Files\Micr...
Log Shipping process running indefinatly
DBCC xp_sqlbackup(FREE)
Go
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "RESTORE LOG [SOY_usc001prd] FROM DISK = ''\\Server\d$\SQLBackups\SOY_usc001prd_*.sqb'' WI...
4.1.0.207 Restroing Logs created in 4.2.511
I have tested this new version 4.2.511 importing log files created from an older version (4.1.0.207). This seems to be working just fine in production.
I have also been able to import into an older...
iSQL Backup exit code: 1050 (not working at all currently)
Backing up usc001prd (full database) to:
\\endive\d$\SQLBackups\SOY_usc001prd_20060612_121124.sqb
Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860
Server: Msg 3013
BACKUP DA...
Log Shipping failing "randomly"
There may be a pattern to it, but I have not found it yet...
I'm running SQL Backup for log shipping in the following manner
Server A backups to Server B
Server B backups to Server C
Server C backu...
Deleting files after restoring logs
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "RESTORE LOG [PEPPER_ic001Prd] FROM DISK = ''\\beet\d$\sqlbackups\atlanta\PEPPER_ic001Prd_*.sqb'' WITH STANDBY = ''D...
Error: Msg 3013, Level 16, State 1, Server BEET, Line 1
Running this command:
master..sqlbackup
'-SQL "BACKUP DATABASE [ic001Commonprd]
TO DISK = ''\\endive\d$\SQLBackups\BEET_ic001CommonPrd.sqb''
WITH NAME = ''Server: BEET, Database: ic001Commonprd'',
...
SQL Back-up Error Msg 3013, Level 16, State 1, Server BEET,
Running this command:
master..sqlbackup
'-SQL "BACKUP DATABASE [ic001Commonprd]
TO DISK = ''\\endive\d$\SQLBackups\BEET_ic001CommonPrd.sqb''
WITH NAME = ''Server: BEET, Database: ic001Commonprd'',
...