SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 342 Page Views: 

Specify the ways which can be used to move data or databases between servers?



Posted By: Avi Date: 1 October 2010 12:00:08 PM
 Answer:

Lots of options exists to move the data or databases. Depending on our requirements we can opt for the required option. Some of the options are Backup/Restore,Replication,dettaching and attaching databases,BCP,loghipping,DTS,Insert…Select,Select..Into,and creating insert scripts for generating the data.


Posted By: avibtech

Date: 1 October 2010 12:00:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image i4SMEw
Related Questions
SQL Server : Define user defined data types and when they should be used?

Define user defined data types and when they should be used?

User Defined Data Types:- These are the data types based on system data types. They let the users ex....
Category: SQL Server Date: 10/1/2010 11:50:07 AM
SQL Server : Differentiate between Dynamic SQL and Static SQL?

Differentiate between Dynamic SQL and Static SQL?

Static SQL:- Static queries are the simple queries which are directly embeded into the program. They....
Category: SQL Server Date: 10/1/2010 11:49:07 AM
SQL Server : What is blocking and how this problem can be solved out?

What is blocking and how this problem can be solved out?

Blocking occurs when one process holds a lock and the other process requires a conflicting lock type....
Category: SQL Server Date: 10/1/2010 11:48:07 AM
SQL Server : Do you think that it is compulsory to delete duplicate rows in a table with the help of temporary table only?

Do you think that it is compulsory to delete duplicate rows in a table with the help of temporary ta....

No,Temporary table is not compulsory.It can be deleted without craeting temporary table by using ROW....
Category: SQL Server Date: 10/1/2010 11:47:07 AM
SQL Server : What is SQL Job and what are its uses?

What is SQL Job and what are its uses?

SQL Job is set of specified operations set on server to be performed sequentially and automatically.....
Category: SQL Server Date: 10/1/2010 11:45:07 AM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories