Just Learned - How to create new database in SQL Server with "Full Recovery Model"?

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

How to create new database in SQL Server with "Full Recovery Model"?

Jun 2 2011 5:24AM by Khyati Patel

I just learned the easiest way to create database in SQL Server with "Full Recovery Model" from Pinal's blog . The solution is: Go to your Model database: Path is SSMS >> Databases >> System Databases >> model >> Right Click Properties >> Options >> Recovery Model - Select Full from dropdown.

Now new database will be created with Full recovery model since every newly created database takes its base template from the Model Database. Any database that was already created before making changes in the Model Database will not be affected at all.

Read More.. [5 clicks]

Published under: SQL Server Tips · · · ·

Previous: Print statement prints maximum of 8000 characters only
Next: How to enable SQL Server Agent XPs

Khyati Patel

29 · 6% · 1821

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	Submit

1 Comments

I feel that If you change the recovery model of Model database, It will also effect TempDB which is recreated everytime the server is restarted. I will check out today what happens with TempDB.

Having TempDB if Full recovery model is not suggested.

commented on Jun 22 2011 2:54AM

pk_bohra

731 · 0% · 44

Your Comment

Sign Up or Login to post a comment.

"How to create new database in SQL Server with "Full Recovery Model"?" rated 5 out of 5 by 7 readers +Khyati Patel