.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What are the things we have to follow when swithing from FULL or BULK-LOGGED to SIMPLE recovery model ?

Posted By :Pandian     Posted Date :February 15, 2011    Points :15   Category :Sql Server 
1. Before switching from FULL or BULK-LOGGED recovery model, We have to take LOG Backup immediately before switching to SIMPLE.

2. It will help us to recover Point-In-Time(If any)

3. Finally, we can switch to SIMPLE recovery model.

You can also find related Interview Question to What are the things we have to follow when swithing from FULL or BULK-LOGGED to SIMPLE recovery model ?  below: 

What are the things we have to follow when switching from the SIMPLE recovery model to the FULL or BULK-LOGGED recovery model ?

  
1. Once we complete the switching to the FULL or BULK-LOGGED recovery model, we have to take a full or differential database backup to start the log chain.

2. Then only it takes effect after the first data backup.

3. Schedule regular log backups and update your restore plan accordingly to maintain high-availability/Disaster recovery
(More...)

How session layer in OSI model is responsible for Synchronisation and recovery?

  
Session layer creates certain check points while transmitting volumes of data in a sequence. When there is a problem in the transmission in the middle of any bulk of data, transmission will take place from the check point where it was left. This function of Session layer is called Synchronisation and recovery. (More...)

Synchronisation and Recovery in OSI model happens in which layer?

  
Synchronisation and Recovery in OSI model happens in Session layer. Session layer is also responsible for Token Management. (More...)

What are the major data structures used in RDBMS, Network data model & Hierarchical data model.

  
RDBMS - Array (i.e. Array of structures)
Network data model - Graph
Hierarchical data model - Trees (More...)

What is Data Model?

  
A collection of conceptual tools for describing data, data relationships data semantics and constraints. (More...)

What is E-R model?

  
This data model is based on real world that consists of basic objects called entities and of relationship among these objects. Entities are described in a database by a set of attributes. (More...)

What is Object Oriented model?

  
This model is based on collection of objects. An object contains values stored in instance variables with in the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain same types of values and the same methods are grouped together into classes. (More...)

What is Full Trust?

  
Your code is allowed to do anything in the framework, meaning that all (.Net) permissions are
granted. The GAC has Full Trust because it's on the local HD, and that has Full Trust by default,
you can change that using caspol . (More...)

What are the steps you need to follow to use jQuery in ASP.Net project?

  
It's really simple. One just need to add reference of javascript file(.js). Go to Jquery.com and download the latest version of jQuery. When download is completed, there is a "jQuery-1.3.2.js" in the folder. Include this file




and you good to go now for JQuery.

Note : 1.3.2 denotes the library version.. It can be vary depending upon the version of Jquery you download. (More...)

What is Waterfall Model?

  
It's development method in which work "flows down" from one stage into the next stage. Each stage must be completed before the next stage can begin, and returning to a previous stage is often not permissible.

Various Phases are
1. Requirements
2. Design
3. Implementation
4. Testing
5. Release (More...)

What is Data Model concept?

  
Data Model is a collection of conceptual tools for describing data, data relationships data semantics and constraints. (More...)

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

  
For restoring the master db we have to stop the SQL Server first and then from command line we can type SQLSERVER -m which will basically bring it into the maintenance mode after which we can restore the master db. (More...)

What is Data Model?

  
Data Model is a collection of conceptual tools for describing data,data relationships, data semantics and constraints. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend