Solved

Oracle DBA now using SQL Server,  Backups

Posted on 2011-03-15
2
216 Views
Last Modified: 2012-05-11
Backup questions when using SQL Server.
Hi Everyone,

I have inherited a SQL Server database, that I am putting together a backup strategy for. My experience has been with Oracle and I had a question with regards to the transition.

 1) When backing up in Oracle, to have the capability to perform a full recovery, the system       (log files) has to be set to Archive log mode. (In case the older entries in the archived log files are needed for recovery.)  Does SQL Server operate in a similar manner? In other words, does it back up copies of old log files in case they are needed to perform a full recovery? Is there different terminology used for this concept in SQL Server.

Any help is greatly appreciated.

0
Comment
Question by:jonsuns7
2 Comments
 
LVL 4

Accepted Solution

by:
Veerabhadraiahhv earned 500 total points
Comment Utility
0
 

Author Closing Comment

by:jonsuns7
Comment Utility
Thanks, I found out most of what I needed to know.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
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…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

772 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

10 Experts available now in Live!

Get 1:1 Help Now