Home
|
Tutorial
|
Articles
|
Forum
|
Interview Question
|
Code Snippets
|
News
|
Fun Zone
|
Poll
|
Web Links
|
Certification
|
Search
Welcome :
Guest
Sign In
Register
Win Surprise Gifts!!!
Congratulations!!!
Top 5 Contributors of the Month
ffttt
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 Type of Processing model asp.net simulates ?
Event-driven
(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