Redgate Backup

Question

Post reply

Redgate Backup

ramana3327

SSCoach

Points: 19722
More actions
May 14, 2015 at 9:36 am

#298152

Hi,
We have trial version of Redgate backup. When I check the full backup
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [*] TO DISK = ''D:\Backups\Database\<AUTO>.sqb'' WITH MAILTO = ''raman@yahoo.com'',
DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, THREADCOUNT = 32, VERIFY"', @exitcode OUT, @sqlerrorcode OUT
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
Is it includes all new user db automatically?
The dbo.sqlbackup is the extended stored procedure
when I script out it showing like this
EXEC dbo.sp_addextendedproc N'sqlbackup', ''
GO

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

cunningham SSCarpal Tunnel Points: 4595 More actions · Answer 1

give it a try. create a new database and see if it is backed up automatically.

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 2

If you're using the syntax BACKUP DATABASES, unless you specify a list of databases to include or exclude (and you have to use the EXCLUDE key word), then it's backing up all the databases. You can read more in the documentation. If you add a database, it will get backed up.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

ramana3327 SSCoach Points: 19722 More actions · Answer 3

It included the new database also.

I am looking to set up the differential backup. I will look in to the documentation. Thanks for providing the documentation

Lowell SSC Guru Points: 323518 More actions · Answer 4

the Redgate GUI has a wizard does a decent job of allowing you create SQL Jobs to regularly schedule the Full / Diff / Log backups , all based on whether each database is in Full or simple mode: full gets Full + Log, Simnple gets Full + Differential.

I used the default style for a while, but then ended up scripting jobs to my own individual tastes, but that gave me the full baseline for creating the backups the way i wanted.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ramana3327 SSCoach Points: 19722 More actions · Answer 5

I honestly speaking, I don't have any exact information.

Under the jobs, I can see there are backup jobs Full & Transactional scheduled. When I click on that it is showing that it is executing the extended sp under master db. I think it should be Redgate backup because of the symbol

When I added new db, it automatically include the new db in the full backup but didn't include in the transactional backup.

If I want to change the transactional backup to include the new db and also need to schedule the differential backup but unable to start the process

All user db are in full recovery only. Any help to set up the differential backup?

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 6

ramana3327 (5/17/2015)
It included the new database also.
I am looking to set up the differential backup. I will look in to the documentation. Thanks for providing the documentation

Just a word of warning there. I've seen it where DIFs get larger than the original database just because of all the activity going on. Sometimes they're worth it and sometimes they're not. As with all else, "It Depends".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ramana3327 SSCoach Points: 19722 More actions · Answer 7

In that case we need to take everyday full backup right?

Currently we have weekly full backup & 15 min log backups.

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 8

ramana3327 (5/18/2015)
In that case we need to take everyday full backup right?
Currently we have weekly full backup & 15 min log backups.

Jeff didn't say to throw away differentials, just to keep an eye on them. For most systems, a weekly full, daily differentials and 15 minute log backups will provide pretty good coverage.

The really important thing is that you know how to do the recovery process and that you've tested it and trained in it. Doing the backups is great, but the most important thing is to be able to restore from them.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning