Solved

Sql backup recovery model switch

Posted on 2004-10-06
2
198 Views
Last Modified: 2008-03-17
I have a sql database that is setup with a simple backup recovery model.  I would like to change it to a full recovery model.  I know how to do make the change but i am concerned about effect tothe existing data in the database.  I know this is probably just my paranoia but i don't want to lose any existing data.  Can i safely change from simple to full recovery model?
0
Comment
Question by:martini60123
2 Comments
 
LVL 18

Accepted Solution

by:
ShogunWade earned 50 total points
Comment Utility
Yes.  but you need to remeber to put a backup strategy in place or your log will grow.    also you may find that performance drops slightly
0
 
LVL 17

Expert Comment

by:BillAn1
Comment Utility
yes, it will not effect your data in anyway. The only 'danger' is that your log file will start to grow, and may even run out of space, at which stage your application will fail.
Of course, for peace of mind you can back up the database before you change the recovery model, so if nything were to go wrong you can go back to this backup.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now