September 22, 2008 at 4:32 am
Hello,
I just want to be sure that my order is correct and wont let any holes for possible errors open.
I have a night job that processes following jobs:
1: Perform full Backup of testdatabase with SQLBackup (redgate) to disk on 2 locations
2: Backup production Database and restore it as testdatabase (so the testenv is always provided with the production data from previous day for more accurate testing purposes)
( this one give me cache restore flushes in the error log)
3: Perform Full backup of production database with SQLBackup (redgate) to 2 locations
4: Perform Full Log backup of production database with SQLBackup (redgate) to 2 locations
Is this the order that should be handled or should i first create the full backups of the productiondatabase.?
Wkr,
Eddy
September 22, 2008 at 1:02 pm
It looks like you're backing up production in step 2, then again in step 3. Why not back it up first thing, then copy to another location. Then restore to test.
September 23, 2008 at 4:09 am
Sorry, i guess my question was not totally clear..
Backup in step 3 is been taken by redgates' sqlbackup (every night same time)
The backup/restore in step 2 is a T-Sql script that normally needs to run every day but not always
for example:
There could be a big change in development env. (data schema changes) thats already in the test env. but for witch the testing is not yet done , in that case the production db backup/restore should not be run at night..
In other cases it should run multiple times on a day, on testing request it is possible to perform the backup/restore more then ones a day, does not happen often but could be.
But i was more wondering on what happened on the background if you perform a full backup,
Log chain broken is possible this way ..?
Ps: i also perform 15' interval log backups of the production database between 05h and 18h30
And here is where the true question lies.
If i first perform the full backup + Restore to the test env. is this the point where my log chain stops.?
Or for example when i run the backup production/restore test at 2Pm,
What would then happen if something happens to my production env. at 3Pm
Can i restore full till 3Pm or 2H45 eg. time of last logbackup?
Or can i restore until 2Pm, the time another full backup was token by the backup/restore procedure .??
Hope someone can clearifie this one for me.
Wkr,
Eddy
September 23, 2008 at 8:28 am
eddy (9/23/2008)
Sorry, i guess my question was not totally clear..Backup in step 3 is been taken by redgates' sqlbackup (every night same time)
The backup/restore in step 2 is a T-Sql script that normally needs to run every day but not always
for example:
There could be a big change in development env. (data schema changes) thats already in the test env. but for witch the testing is not yet done , in that case the production db backup/restore should not be run at night..
In other cases it should run multiple times on a day, on testing request it is possible to perform the backup/restore more then ones a day, does not happen often but could be.
But i was more wondering on what happened on the background if you perform a full backup,
Log chain broken is possible this way ..?
Ps: i also perform 15' interval log backups of the production database between 05h and 18h30
And here is where the true question lies.
If i first perform the full backup + Restore to the test env. is this the point where my log chain stops.?
NO, SQL doesn't care that you restored to test, your logs are still fine.
Or for example when i run the backup production/restore test at 2Pm,
What would then happen if something happens to my production env. at 3Pm
Then you restore your 2 pm backup, and then restore your 15 minute log backups up to 3 pm
Can i restore full till 3Pm or 2H45 eg. time of last logbackup? Yes
Or can i restore until 2Pm, the time another full backup was token by the backup/restore procedure .??
Hope someone can clearifie this one for me.
Wkr,
Eddy
September 23, 2008 at 8:37 am
Hey Homebrew,
tnx a lot for making it clear for me, 🙂
wkr,
Eddy
September 23, 2008 at 10:43 am
You should do a test restore for practice and make sure everything work. Take your live DB and Log backups, and restore them to "Restore_practice" database.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply