April 8, 2011 at 9:41 am
Hi Team,
Database having full Recovery model,one of my junior DBA change it to simple recovery due to this reason my T-log backup job was failed.
How can i recovery the database.
i am was planning to do is
1. i have to change Recovery model into Full after that
2. taking simple recovery model
3. full backup
any thing wrong please guide me.
Tx
April 8, 2011 at 10:18 am
If it is a production database I would suggest something like:
1) Set to FULL recovery model
2) Take one-time full backup now to re-establish log chain
3) Take full backup daily
4) Schedule regular t-log backups (every 15-30 minutes)
The exact schedule, timing and full/diff options will depend on your business needs.
April 9, 2011 at 6:02 pm
homebrew01 (4/8/2011)
2) Take one-time full backup now to re-establish log chain
no need for a full, a differential will do the trick
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2011 at 12:26 am
hi
we cant take differential backups we have only take every day 12:00 AM full backup and every 15 teen mins T-log backups.
Tx
April 12, 2011 at 12:00 pm
shiv-356842 (4/10/2011)
we cant take differential backups we have only take every day 12:00 AM full backup and every 15 teen mins T-log backups.
Just curious: why you can NOT take diff backup?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply