July 14, 2011 at 2:44 pm
Stefan Krzywicki (7/14/2011)
Ninja's_RGR'us (7/14/2011)
sure. Why don't you do what you want??Sorry, I'm not sure what you're referring to here.
Either is fine. I just think full is overkill in your situation (my 0.02$).
You think otherwise and it's your system so do what you want :w00t:.
July 14, 2011 at 2:44 pm
Brandie Tarvin (7/14/2011)
As a matter of fact, we have jobs that restore daily down to our QA server. We don't do every database, but we do the major ones.These restores serve as double-duty. Not only do they verify our backups, but they serve as production copies of our data so the developers / dbas can troubleshoot production problems without needed actual access to production. In addition, since the "prod copy" is only a day behind, we seldom need to make emergency restores that interrupt our SDLC processes because the data is so fresh for the error checking.
We use SQL Agent jobs to do the restore. The first step is to drop the old ProdCopy, the second restores it, the third obfuscates private information, the fourth sets all email addresses to a Test email so the customers don't get emails, the fifth resets everyone's permissions (sp_update_users as well as role adds & new perms for the prod copy version), etc.
Does that help?
We do this as well, but wrote our own process and are not using the Agent. We copy it out to Pre, Test and Dev once per week, then automatically run the scripts that are part of the next deploy. So this process doubles as a check to make sure our deployment scripts are accurate. ("Hey, why is feature XXX broken in Test?" "Did you send me your DB scripts?" "No" "That's why"). It took a couple weeks to sink in, but been golden since then and our database deploys have far fewer issues.
Thanks,
Chad
July 15, 2011 at 12:43 am
Mind me tossing in my all time favorit when it comes to what the log is all about and why your choice of recovery model matters ?
- Managing Transaction Logs[/url]
and
- Why is my transaction log full?[/url]
both by Gail Shaw.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 15, 2011 at 7:06 am
ALZDBA (7/15/2011)
Mind me tossing in my all time favorit when it comes to what the log is all about and why your choice of recovery model matters ?- Managing Transaction Logs[/url]
and
- Why is my transaction log full?[/url]
both by Gail Shaw.
I never mind people throwing in things written by Gail.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply