Activity overview
Latest activity by soonyu
I think this is what you want ?
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-SQL "BACKUP DATABASE [Northwind] TO DISK = ''e:\sql\MSSQL\BACKUP\<AUTO>'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', COMPRESSION = 1, THREADS = 1"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
IF (@exitcode <>0) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
It will appear "fail" in sql history / comments
I think this is what you want ?
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-SQL "BACKUP DATABASE [Northwind] TO DISK = ''e:\sql\MSSQL\BACKUP\<AUTO>'' WITH NAME = ''<A...
"You may also want to examine your logs in %allusersprofile%\application data\red gate\sql backup\instance\logs."
will the logs auto purge? how long it will?
Cheers,
Liang Yew / comments
"You may also want to examine your logs in %allusersprofile%\application data\red gate\sql backup\instance\logs."
will the logs auto purge? how long it will?
Cheers,
Liang Yew
Backup file name for red-gate
As we know, we can backup sql db with predefine file name or use "auto" in sql command where file name will be
FULL_servername_dbname_20061018_150407.sqb
2 question
1. is that anyway to change to b...
SQL Backup (DLL v4.2.0.425)
Reading file header of "D:\student_differentialbackup.sqb"
Backup name : Database (studentdb), 7/10/2006 5:30:01 AM
Description : Backup on 7/10/2006 5:30:01 AM Server: STAR
Database: studentdb
Backup type : 5 (Differential database)
User name : STAR\dba
Backup start : 7/10/2006 5:30:01 AM
Backup finish: 7/10/2006 5:50:31 AM
Server name : STAR
Database name : studentdb
Database version : 539
Creation date : 10/1/2005 12:49:18 PM
Size : 3.111 GB
Sort order : 52
Code page : 228
Machine name : STAR
Collation : SQL_Latin1_General_CP1_CI_AS
First LSN : 153921000001594400005
Last LSN : 153921000006626900001
Checkpoint LSN : 153921000001594400005
Differential base LSN : 153774000000132000003
(25 row(s) affected)
name value
exitcode 0
sqlerrorcode 0
filename01 [image] \student_differentialbackup.sqb
(3 row(s) affected) / comments
SQL Backup (DLL v4.2.0.425)
Reading file header of "D:\student_differentialbackup.sqb"
Backup name : Database (studentdb), 7/10/2006 5:30:01 AM
Description : Backup on 7/10/2006 5:30:01 AM Serv...
Restoration fail
I restore fullbackup and diffrential backup with standby mode to sqlserver
I want change the standby mode to recovery mode
but it give me this message...
Server: Msg 3013
RESTORE DATABASE is termin...