.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

Difference between Physical backup and Logical backup?

Posted By :Ramesh P     Posted Date :October 30, 2010    Points :10   Category :Sql Server 
Physical backup : It helps to backing up the individual database object like view,stored procedure,table etc....It is very slow and recovery is not possible

Logical backup : It rely on the OS to make a copy of the physical files like data files,log files,control files that comprise the database.

You can also find related Interview Question to Difference between Physical backup and Logical backup?  below: 

difference between backup file and .stp file in sharepoint site

  
A backup file is more like a DB snapshot (if you are talking about the backup operation of STSADM)

You can save a site with our without content as template and can create other sites based upon that site template. For that first you have to save your site as a template which will be saved with extension .STP, OOB there is limitation of 10MB in size but u can increase the size upto 2 GB using STSADM command. (More...)

what difference between EXPORT and BACKUP of site operation

  
1) stsadm -o backup/restore URL-http://serverName

With the URL and filename parameters, it allows you to backup site or site collection
when we restore the file then it generates the new GUID for the site collection

2) stsadm -o import/export URL-http://serverName

This is the only standard operation to store the site, it can also to be used to export the site
but here the drawback is as:
It not only changes the GUID of the site or site collection but it also changes the GUIDs of LIST, WEPART, SUBSITES and ITEMS (More...)

What are the built in ways to backup a SharePoint install?

  
Using central administration and the stsadm command you can take backup (More...)

How to take the backup through query?

  
Backup database dbname to disk="f:\users\db.bak"

Backup database dbname to disk="f:\users\kadha\sartest06.bak' with differential

Backup log dbname to disk ="f:\users\db.trn" (More...)

what are the content in Transaction log file backup?

  

Step 1 : Begin and End Transaction information

step 2 : Modified transaction information

step 3 : create or alter table information or index information (More...)

How to find the last backup time and date for particular database

  
step1: open enterprise manager

step2: select the particular database -->properties-->Now we are able to see last full,transaction log backup time and date (More...)

Before you RESTORE or ATTACH the Database/backup file on Production server from other source, What are the things you should do ?

  
The following are the basic recommendations when attaching or restoring Database(s) from other source:

1. Do not ATTACH or RESTORE databases from unknown sources.

2. These databases could contain malicious code that might execute unintended Transact-SQL code or cause errors by modifying the schema or the physical database structure.

3. Before you use a database from an unknown source, run DBCC CHECKDB on the database on a nonproduction server first.

4. Examine the code, like stored procedures or other user-defined code.

5. If you feel everything is fine thenonly proceed with production server.
(More...)

What are the Methods of Backup and Recovery in SharePoint 2010?

  
Microsoft SharePoint Server 2010 provides a broad range of levels for performing backups, including the entire farm, farm configuration information, site collections, subsites, or lists.

SharePoint Server 2010 uses two different tools to configure backup and recovery.

1. Central Administration : Central Administration provides a user interface where SharePoint Administrators will be prompted via menu structures to select the information that needs to be backed up. (see the Image below)


2. Windows PowerShell : Windows PowerShell is a command line tool that provides SharePoint administrators a way to perform backup and recovery with additional options such as file compression or working with SQL snapshots.

Listed below are a few of the benefits available when working with Windows PowerShell:

. Windows PowerShell scripts can be developed and scheduled (with Windows Task Scheduler), whereas Central Administration is used for single-use backups and restores.

. Windows PowerShell has the advantage of running against SQL snapshots instead of the production database. One of the parameters of the Windows PowerShell command will cause a SQL snapshot to be generated, and then Windows PowerShell will run the action against the snapshot instead of the production database. This will reduce the resource impact of the backup operation on the production environment.

. With Windows PowerShell, SharePoint administrators will have more granular control of options for the backup or restore. (More...)


Q. What are the Methods of Backup and Recovery in SharePoint 2010?

  
Ans. Microsoft SharePoint Server 2010 provides a broad range of levels for performing backups, including the entire farm, farm configuration information, site collections, subsites, or lists.

SharePoint Server 2010 uses two different tools to configure backup and recovery.

1. Central Administration : Central Administration provides a user interface where SharePoint Administrators will be prompted via menu structures to select the information that needs to be backed up. (see the Image below)


2. Windows PowerShell : Windows PowerShell is a command line tool that provides SharePoint administrators a way to perform backup and recovery with additional options such as file compression or working with SQL snapshots.

Listed below are a few of the benefits available when working with Windows PowerShell:

. Windows PowerShell scripts can be developed and scheduled (with Windows Task Scheduler), whereas Central Administration is used for single-use backups and restores.

. Windows PowerShell has the advantage of running against SQL snapshots instead of the production database. One of the parameters of the Windows PowerShell command will cause a SQL snapshot to be generated, and then Windows PowerShell will run the action against the snapshot instead of the production database. This will reduce the resource impact of the backup operation on the production environment.

. With Windows PowerShell, SharePoint administrators will have more granular control of options for the backup or restore.

For more info See : Windows PowerShell Tutorial



(More...)

What is the STSADM command to backup and restore the sharepoint site

  
The STSADM commands to take backup and restore the sharepoint site are given as below:

Backup command:
stsadm -o backup -url http://sp-moss:9999/ -filename c:\backupsite.bak

Restore Command:
stsadm -o restore -url http://sp-moss:9999/ -filename c:\backupsite.bak (More...)

How to Restore a site backup using Powershell command in SharePoint Server?

  
Use below Powershell script command
Restore-SPSite -Identity http://myserver -Path "c:\backup\file.bak" (More...)

Difference Between Delete and Truncate

  
.Delete table is a logged operation, so the deletion of each row gets logged in the transaction log, which makes it slow.

. Truncate table also deletes all the rows in a table, but it won't log the deletion of each row, instead it logs the de-allocation of the data pages of the table, which makes it faster. Of course, truncate table cannot be rolled back.

. Truncate table is functionally identical to delete statement with no "where clause" both remove all rows in the table. But truncate table is faster and uses fewer system and transaction log resources than delete.

. Truncate table removes all rows from a table, but the table structure and its columns, constraints, indexes etc., remains as it is.

. In truncate table the counter used by an identity column for new rows is reset to the seed for the column.

. If you want to retain the identity counter, use delete statement instead.

. If you want to remove table definition and its data, use the drop table statement.

. You cannot use truncate table on a table referenced by a foreign key constraint; instead, use delete statement without a where clause. Because truncate table is not logged, it cannot activate a trigger.

. Truncate table may not be used on tables participating in an indexed view. (More...)

Difference between assembly manifest & metadata?

  
assembly manifest - An integral part of every assembly that renders the assembly self-describing. The assembly manifest contains the assembly's metadata. The manifest establishes the assembly identity, specifies the files that make up the assembly implementation, specifies the types and resources that make up the assembly, itemizes the compile-time dependencies on other assemblies, and specifies the set of permissions required for the assembly to run properly. This information is used at run time to resolve references, enforce version binding policy, and validate the integrity of loaded assemblies. The self-describing nature of assemblies also helps makes zero-impact install and XCOPY deployment feasible.

metadata - Information that describes every element managed by the common language runtime: an assembly, loadable file, type, method, and so on. This can include information required for debugging and garbage collection, as well as security attributes, marshaling data, extended class and member definitions, version binding, and other information required by the runtime. (More...)

What is the difference between ref & out parameters?

  
An argument passed to a ref parameter must first be initialized. Compare this to an out parameter, whose argument does not have to be explicitly initialized before being passed to an out parameter. (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